Viewing 15 posts - 5,566 through 5,580 (of 9,715 total)
mortalic (7/13/2011)
July 14, 2011 at 5:33 am
seth delconte (7/13/2011)
--try/catch guarantees that shrink log will not happen...
July 13, 2011 at 1:06 pm
Stick your File System task into a For Each Loop container. Pass the file name / path down from the For Each Loop to the variable and use the variable...
July 13, 2011 at 12:17 pm
mortalic (7/13/2011)
What else can cause the tlog not to shrink?
The need for the space. Just because the tlog backups are happening doesn't mean the log is going to shrink. There...
July 13, 2011 at 12:14 pm
Have you thought about the idea that it might be auto-disabled / enabled via a job?
Search the text (column name might be "Command") in sysjobsteps and see if you can...
July 13, 2011 at 12:08 pm
I think it's time to call the vendor. It might be an issue with the application itself, especially if they never upgraded it to use SQL 2008, and we can't...
July 13, 2011 at 11:47 am
Thanks for posting your solution, Erik. That will help.
July 13, 2011 at 11:39 am
It occurs to me that I've been assuming your application is an in-house developed app. Is that correct or is this a third party app you're using?
If the former, you...
July 13, 2011 at 11:37 am
SVR (7/13/2011)
July 13, 2011 at 9:04 am
Glad I could help.
July 13, 2011 at 8:59 am
Kiara (7/12/2011)
crookj (7/12/2011)
SQLRNNR (7/12/2011)
Armageddon
Pour Some Sugar on Me
Sugar Sugar
Honey Honey
Buzz
July 13, 2011 at 7:29 am
Check the server Event Viewer logs (especially Security) for around that time frame. What do they say?
The connection string would be helpful. Maybe a screenshot of the error as well.
July 13, 2011 at 7:24 am
dilipd006 (7/13/2011)
that means Even if i use different filegroups there is no improvement in DB performance if I don't use different physical disk drive right.
Pretty much.
Is there any improvement...
July 13, 2011 at 6:39 am
Koen Verbeeck (7/13/2011)
WHERE HASHBYTES('MD5', cast(ImageColumn1 as varbinary(MAX)))
=...
July 13, 2011 at 6:07 am
Koen Verbeeck (7/13/2011)
Gianluca Sartori (7/13/2011)
Here he goes again.I didn't notice it from the start.
Funny. 🙂
Which actually brings this thread back on topic! :w00t:
NO!!!!!!! Say it ain't so!!!
We can't have...
July 13, 2011 at 5:54 am
Viewing 15 posts - 5,566 through 5,580 (of 9,715 total)