databasecollation.blogspot.com
database collation: changing the types of particular columns in particular table in the database
http://databasecollation.blogspot.com/2012/03/changing-types-of-particular-columns-in.html
Thursday, March 29, 2012. Changing the types of particular columns in particular table in the database. I have more than 300 tables in the database. Out of that tables some table has column whose type is char.I want to change only those tables' column to the type nvarchar. Is it possible to make the modification all at a once? Since i am changing each and every table , this takes a lots of time. Thanks in advance,. FROM INFORMATION SCHEMA.Columns C. INNER JOIN INFORMATION SCHEMA.Tables T. Changing the ty...
databasecollation.blogspot.com
database collation: Changing the SQL Server Name
http://databasecollation.blogspot.com/2012/03/changing-sql-server-name_1634.html
Thursday, March 29, 2012. Changing the SQL Server Name. I have SQL 2000 std installed on a win2000 box with latest svc packs and box. Was originally designated with a development name which SQL also inherited. Now the server box name has been changed but the server still indicates the. What are the implications if I leave as is and how difficult is it to change. Can I just update sysserver in the master db through sp addserver or are. I noticed that some maintenance jobs I had defined. What are the impli...
databasecollation.blogspot.com
database collation: Changing the text of the code of multiple stored procedure
http://databasecollation.blogspot.com/2012/03/changing-text-of-code-of-multiple.html
Thursday, March 29, 2012. Changing the text of the code of multiple stored procedure. We have four different SQL Servers and each server has 2-3 databases. The stored procedures on each database use link servers to access each. Other The link server names are based on the actual server name. The Issue:- We are migrating to SQL 2005 and to save on the licence. Cost we are planning to consolidate all our databases on one more. Powerful machine which can take load of peak hours. Now will it be. Txt file (up...
databasecollation.blogspot.com
database collation: Changing the text of the code of multiple stored procedure
http://databasecollation.blogspot.com/2012/03/changing-text-of-code-of-multiple_29.html
Thursday, March 29, 2012. Changing the text of the code of multiple stored procedure. We have four different SQL Servers and each server has 2-3 databases. The stored procedures on each database use link servers to access each. Other The link server names are based on the actual server name. The Issue:- We are migrating to SQL 2005 and to save on the licence. Cost we are planning to consolidate all our databases on one more. Powerful machine which can take load of peak hours. Now will it be. Txt file (up...
changemsdbowner.blogspot.com
change MSDB owner: Changing connection transactions to database transactions
http://changemsdbowner.blogspot.com/2012/03/changing-connection-transactions-to.html
Thursday, March 29, 2012. Changing connection transactions to database transactions. I have decided to move all my transaction handling from asp.net to stored procedures in a SQL Server 2000 database. I know the database is capable of rolling back the transactions just like. But what about exceptions? In asp.net, I am used to doing the following:. Catch ex As Exception. Will the database inform me of any exceptions (and their messages)? Do I need to put anything explicit in my stored procedure other than.
changemsdbowner.blogspot.com
change MSDB owner: Changing Connections in DTS Packages
http://changemsdbowner.blogspot.com/2012/03/changing-connections-in-dts-packages.html
Thursday, March 29, 2012. Changing Connections in DTS Packages. I have 4-5 DTS packages with more than 100 connections. If I want to change the connections of the source (Oracle Database) from Server 1 to Server 2, how do I do it dynamically? I know that I can go to Disconnected Edit and change the connections manually , but it is a very tedious process as there are more than 100 connections. Do you actually have more than 100 connections (the Oracle Connection icon is the gold twin-disk-drives)? Changin...
changemsdbowner.blogspot.com
change MSDB owner: Changing config table location on the fly
http://changemsdbowner.blogspot.com/2012/03/changing-config-table-location-on-fly.html
Thursday, March 29, 2012. Changing config table location on the fly. I am trying to create a proof of concept to show that we can have packages deployed on 3 different servers and all we need to do is tell the package, upon execution/scheduled task, where to go fetch it's configurations from. The configurations are using SQL Server as the package configuration. This makes it easier for DBA's to maintain since DBA's are responsible for package executions and job scheduling. When I schedule OR execute the ...
changemsdbowner.blogspot.com
change MSDB owner: Changing Computer Name
http://changemsdbowner.blogspot.com/2012/03/changing-computer-name_5659.html
Thursday, March 29, 2012. Heres my situation. We have a production SQL server 2000 with about 18. Different databases running on it. The lease is up on the server and now i. Must roll everything over to the new server. What i need to do is join the. Domain with the new server using a different ip address and name than the. Current SQL server, get everything installed, test it, then take both servers. Down, rename the new server and change its ip address to what the old one. Also, if theres a step by step.
changemsdbowner.blogspot.com
change MSDB owner: Changing Computer Name
http://changemsdbowner.blogspot.com/2012/03/changing-computer-name_2577.html
Thursday, March 29, 2012. Here's my situation. We have a production SQL server 2000 with about 18. Different databases running on it. The lease is up on the server and now i. Must roll everything over to the new server. What i need to do is join the. Domain with the new server using a different ip address and name than the. Current SQL server, get everything installed, test it, then take both server. Down, rename the new server and change it's ip address to what the old one. Was, and put it into producti...
changemsdbowner.blogspot.com
change MSDB owner: changing compatability level from80(2000) to 90(2005)
http://changemsdbowner.blogspot.com/2012/03/changing-compatability-level-from802000.html
Tuesday, March 27, 2012. Changing compatability level from80(2000) to 90(2005). I am planning to migrate my database from sql 2000 to sql 2005. I need to know when i change the compatibility from 80 to 90. 1) What are the things which i need to look out for. If i have changed every thing as per upgrade advisor will i have to make or anticipate further changes. 2) Please tell me whether if i dont use 90 compatability level will i miss out anything? What am i missing out? Thank you for your reply. Subscrib...