In that case is Auto Shrink turned on the database(s). I don't know if you are familiar with these options but in case you are not see http://www.sqlservercentral.com/articles/Administration/autocloseandautoshrinkjustdont/984/

What is the recovery model? If its full are there tranaction log backups being run? What part is growing the mdf (data) or the log file? Where...

A paid for trip to PASS or SQLBITS might be nice. Not necessarily every year but every 2-3 years isn't unreasonable. I've been around long enough to negotiate...

I agree this is a funny name. I didn't know that Chaos wa a valid isolation level. I'm not sure I even get it after reading the explanation....

I actually had a SQL 7 database that was moved to SQL 2000. I then changed the compatibility to 80 and some of the procs stopped working so we...

The donation to the World Land Trust is a great idea. I had never heard of them before but the website is very interesting. Now I want to...

Are you saying its working now or not working? The reference you gave as well as you first post used CREATE LOGIN. In the code I gave in...

-- Setup a linked server on Server B called ServerA from which the

-- standard logins needs to be transferred. You can call it

-- whatever you want & modify the linked...

Have you tried enabling TCP/IP protocal and connecting this way rather than named pipes?

no problem. Sometimes all it takes is a second set of eyes

You have a GO statement after the

Insert Into rs_OTMHeadersTable (CampaignID)

Select distinct

...

As you have done already, make sure you've backed up the log file. SQL Server doesn't want to truncate a log file that's not been backed up, and this...

CrazyMan may have a point. If you change the recovery model to simple, you may be able to shrink the log. Then you can change the recovery model...

Try going a full backup and then try to shrink the log again. If it still doesn't shrink. See http://www.sqlservercentral.com/scripts/63782/ for a script to force it....

Use this code to find out what SQL thinks is the lastest backup file name and date of last full backup. (Use your databasename rather than 'databasename' in the code:

SELECT...