You can use the SP sp_help_revlogin

which is given by Microsoft. http://support.microsoft.com/kb/246133

You will find 2 SPs and you need to create both of them in your master db.

Then execute...

Exactly what do you want to achieve?

If you are using NO_LOG or TRUNCATE_ONLY options in any case your log sequence is going out of order.

don't you want to recover the...

Change the logon service account of Litespeed to a account which has admin rights on the other server as well, like a domain account, and then try again.

possibly this should...

You can use this command:

master..xp_cmdshell 'xcopy G:\SMSDTH2000_Diff_backup\SMSDTH2000_Diff_backup_latest\DIFF_Backup.sqb \\172.16.9.249\j$\SMSDTH2000_Diff_backup\SMSDTH2000_Diff_backup_latest\'

This is the link

http://support.microsoft.com/kb/246133

and if you want to use sp_change_users_login

Auto_Fix

Links a user entry in the sys.database_principals system catalog view in the current database to a...

All you need to do is go to microsoft site and find the SP sp_help_revlogin.

A Diff SP is available for both versions SQL 2000 & SQL 2005.

Then after creating this...

This will help you.

GRANT SELECT ON DATABASE:: TO public

Alternatively, you can also add those users in DATAREADER Role also.

Anyone tried creating Master keys on 1st server?

This shows me the decryption error which geenrally comes when we are trying to bridge a connection with a server which has a...

Its either because of high fragmentation or a low fillfactor.

try to run showcontig on this table to see the percentage of fragmentation on this table.

and double check the Fillfactor.

I don'...

There is no Disable option in SQL SERVER 2000, the option has been introduced in SQL Server 205.

If you don't want to give access to any SQL Login then you...

And yes try to ping the server and see if its working on not.

Make sure your system has no firewall enabled.

Take the help from Sys Admin and ask them to check the DNS Entries, if trying to connect using windows authentication make sure...

Hi Brij,

See we've used the following as a range substring(convert(varchar,getdate(),112),1,6)+'01')

Now this will obviously put all the data of last month in first partition because we are taking here getdate() what...

Do let me know the result.

ALL D BEST 😎

Hi Brij,

I've tested this, and this is working as per your requirement:

-- Create filegroups and files

GO

ALTER DATABASE test2 ADD FILEGROUP fg1

ALTER DATABASE test2 ADD FILEGROUP fg2

ALTER DATABASE test2 ADD FILEGROUP...