Great Article Ritesh thanks

Yasir 😉

Long running transactions prevent the transaction log from shinking. you can check by running the DBCC command.

DBCC OPENTRAN()

Hi

You can use a UDF function in your check constraint to check the values in another table.

here is an example;

assume you have a table called state which have all...

Give the sql server Agent service account full permissions to the logshipping folder in the standby server and the logs will be deleted.

If the log files have "Archive" attribute, you...

By crearting the login on the distributor with sysadmin server role, i managed to configure the publication.

Regards,

Yasir

Hi,

I have a similar problem, I have a distributor sql 2005 SP3 with a publisher sql 2000 SP4 build 2148 and this setup is working with no problems. (i.e. pull...

I run profiler to see what the "xp_delete_file" is triying to do and I noticed an error "CREATE DATABASE permission denied in database 'master'."!!

The account that the sql server...

I had the same problem trying to upgrade sql 7. using the ip address worked for me.