I think the same could be found through the windows registry;)

Competition Club Count

Premier a ...

Hi, as far as I know when you restore a database the dts packages would also be restored corresponding to the database.

🙂

you have the SP sp_grantlogin..

there is the IMPORT/EXPORT wizard in sql server..not sure what is error file in BCP:)

oh ok..

Do you have any DTS packages that need to be migrated?

any relication setup done?

: computername\instancename

Hi, you could find out if the default named instance is used, you reference the instance as computernameame:)

I faced some issues while running some SPs on 2005, which were running perfectly fine in 2000. Then once we changed the compatibilty level it worked fine!

Some features of the...

The sql server I am working with stops every night since last Friday-> you mean after some time you are able to connect back to the instance?

Check for any jobs...

Hi,

If you are to migrate databases then :

1)

Backup the database in the current server

Move the backup file to the new location

Restore the backup file to the new server

After...

Hi, am not sure, but have read somewhere that if you are use sql server 2000 then the MSXML2.XMLHTTP object & sp_OACreate sp is one of the solution for...

Since you have just one user abc, you can

1) create a new login named abc under security

2) map the new login to the database you want to give the...

Hi, here's an example to explain : DBCC SHRINKFILE(testlog, 3)

Now if the target size is not reached with the above command, we can go on to truncate the transaction log...

Hi,

what does 'log_reuse_wait_desc' --mean?

Log backups do fail at times when the space available in the disk is less.

🙂