Hello Harris,

On which version you are trying to restore the backup?

SQL2000:

Go to SQL Enterprise Manager -> Your new SQL Server -> Databases -> Right Mouse Click -> Restore

General Tab ->...

Hello Bill,

You can do one thing. As you said that you could attach them to one of your local 2000 instance, try to make a full backup of the databases...

Hello Reddy,

You can save the DTS package to a file and then copy over the file to your required location. Open the DTS package from SQL Enterprise Manager DTS designer...

Hello Ahmed,

You can build a dynamic sql statement for the exclusive drop statement and execute the same.

Hope this helps you.

Hello,

You can use Replace function to update the domain name in your email address:

update <tablename>

set <columnname> = replace(columnname, 'abc', 'acb')

Note: it will replace for all the data rows in your table.

Hello,

It is better if you can script your user-defined functions and run the same on SQL 2005 box.

Hi Richard,

Do you mean views???

if so

CREATE VIEW [< owner > . ] view_name [ ( column [ ,...n ] ) ]

[ WITH < view_attribute > [ ,...n ] ]...

Hello Bill,

You can set the default value to the required like this

Alter Table <your table name>

alter column <column name> set default <your value>

Hope this helps.

Thanks

Hello Chris,

Can you run svrnetcn.exe from the command prompt to check whether the default port for TCP/IP is 1433?

You can download a tool from Microsoft to scan your SQL instance

Hello David,

You can have a look at SQL Diagnostic Manager from Idera.

Take a look at View menu (Management Studio) in that u can find Ctrl+Alt+G short cut for registering the servers in group.

Hello Ken,

You need to physically remove the foreign key constraint before heading to truncate the table. after truncation you need to re-create the constraint.

Hello,

In the query, you are not using the column "logical_name" but in the order by clause you have mentioned the same.

Remove the same and the query works fine.

Thanks

Hi Nick,

If you mean that the user needs to select / modify data then you can go ahead with "db_datareader" and "db_datawriter".

Thanks

Hello Martin,

You can go ahead with WinZip Command Line Support Add-On.

Thanks and have a good day!!!