Hello James

Check out "DISCONNECT" in Books Online help.

Thanks and have a great day!!!

Hello Daniela,

Please go through this link

http://msdn2.microsoft.com/en-us/library/ms188371.aspx

Thanks and have a great day!!!

Hello Viking,

I'm not sure of whether the below information is useful, as I haven't performed a restoration from tape.

 {DISK | TAPE } =

'physical_backup_device_name' | @physical_backup_device_name_var

Allows backups to be...

Hello Cindy,

Please go through the syntax in SQL 2005. Here are the examples

Using pipes to import data from a file

BULK INSERT AdventureWorks.Sales.SalesOrderDetail   

FROM...

Hello Mark,

Yes, you can refer them with the alias names you want. Please go through BOL for topic "Assigning Result Set Column Names"

Thanks and have a great day!!!

Hello Silva,

You can restore the backup from the network drive. First you need to note down the full remote path and the backup filename.

You can test the remote path access...

Hello Uma,

Please go through the Books Online on the flg topic

Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views

Thanks and have a nice day!!!  

Hello Steve,

A nice article for me at the right time. The tips are worth for a person like me and will follow them until my last job

Hello Madiha,

Please go through the Books Online help on this topic:

Setting and Changing Collations

Thanks and have a nice day!!!

Hello Manutosh,

Can you check up "sp_change_users_login" in the Books Online. It might give you the idea.

Thanks and have a nice day!!!

Hello Andy,

If you have the complete backup file, then it would not be possible to restore only the .mdf file as it is a full backup consisting of both the...

Hello,

You can script the objects available currently and add up the word "_Copy" to the scripted objects and execute the same.

Thanks and have a nice day!!!

Hello Eric,

Please check the system table "sysprocesses". You will get the hostname of the machine.

Thanks and have a nice day!!!

Hello Colin,

Can you check up by entering the value as '0000123' in the excel cell. Finally it shows up as 0000123'.

Thanks and have a nice day!!!

Hello Jeff,

You can modify the second stored procedure to include only the select statement and there is no requirement for the temporary table.

You comment out the temporary table creation statement,...