Viewing 15 posts - 91 through 105 (of 596 total)
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
April 7, 2009 at 10:23 am
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...
April 7, 2009 at 10:14 am
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...
March 6, 2009 at 7:40 am
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....
February 11, 2009 at 8:55 am
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...
February 11, 2009 at 8:44 am
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...
January 29, 2009 at 8:14 am
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...
January 29, 2009 at 7:23 am
-- 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...
January 28, 2009 at 2:43 pm
Have you tried enabling TCP/IP protocal and connecting this way rather than named pipes?
January 28, 2009 at 2:32 pm
no problem. Sometimes all it takes is a second set of eyes
January 28, 2009 at 2:29 pm
You have a GO statement after the
Insert Into rs_OTMHeadersTable (CampaignID)
Select distinct
...
January 28, 2009 at 2:15 pm
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...
January 21, 2009 at 11:49 am
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...
January 21, 2009 at 10:58 am
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...
January 21, 2009 at 10:38 am
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...
January 21, 2009 at 9:52 am
Viewing 15 posts - 91 through 105 (of 596 total)