You can make use of OPENROWSET functionality available in SQL Server 2000

http://msdn.microsoft.com/en-us/library/aa276850(SQL.80).aspx

Also, you can do it by creating a dts package that does the importing stuff and...

Adam,

I was writing the script but was caught up in getting the missing login creation statement execution on DR. I was able to figure out the missing logins but how...

I didn't receive any such error message when I ran this code on SQL 2000 box.

Manu

Make use of PASSWORD clause of BACKUP DATBASE command. See books online for syntax and its usage.

Manu

If server is not coming up in single user mode then try starting it using trace flag 3608 and then do what Steve has mentioned above.

Manu

Try reading the default trace file(running in background only in 2005). I think its located under default log file directory). See if it has captured anything that you are looking...

Vivek,

I think the sequence should be as mentioned below(not sure as I haven't done it so far):

1. Restore all user databases on new server.

2. Restore msdb database(it needs to be...

Try dropping the existing user(& login) and then creating login+user again with same rights and privileges as they had before.

Manu

You can do this by specifying CategoryID as one of the input for your stored procedure and then calling stored procdure once fr each 60 category IDs. Procedure needs to...

From the below mentioned link it looks you need to restart MSDTC on both the machines.

http://geekswithblogs.net/sureshg/archive/2006/02/14/69456.aspx

Not sure whether it will work for you or not. Hope, it helps.

Manu

http://msdn.microsoft.com/en-us/library/ms174269.aspx

Excerpt from books online:

Moving a file to a new location

The following example moves the Test1log2 file created in example A to a new directory.

Note:

You must...

It looks you have to manually update the password on each node. See

http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.clustering/2007-11/msg00062.html

As SSCM is not cluster aware it won't help in getting password resetted from one node.

Manu

If file got deleted properly(without any error message) then your database should come online with no issues. Did you deleted it when database was online(sql service was running) or when...

Try using filegroup restore in case you have filegroup backup available with you.

Manu

Re-org operation is same as DBCC DBREINDEX in SQL 2000. It needs space of approximately 1.2-1.5 times of database size for successful execution. To reduce the transaction log file usage...