Viewing 9 posts - 1 through 9 (of 9 total)
After many hours of research, I've finally found what I was looking for. Here is my revised code:
SELECT tat.transaction_id as ID, tat.name as Name, tat.transaction_begin_time as [Start Time],
...
September 23, 2010 at 9:57 am
sorry, should have searched the forums before posting....
The correct syntax for what I'm trying to accomplish:
LEFT(esl.text,CHARINDEX('(',esl.text)-1) as Text
September 22, 2010 at 1:26 pm
Latest update: I moved the execution time of the full backup from 1:20 AM to 12:00 PM which is just before the lowest usage period of my site. I...
August 9, 2010 at 9:18 am
Brandie Tarvin (8/6/2010)
I'm curious. What recovery mode is your database in? FULL or Bulk-Logged?
I have no idea, and I've never heard of bulk-logged. How can I determine what mode...
August 9, 2010 at 8:54 am
Adiga (7/30/2010)
You can check in sys.processes to see if any backup job is running against a database. Put this logic in the Shrink TLog job step
I am now using this...
August 5, 2010 at 9:16 am
Latest update: I haven't gotten a chance to really dive into the root cause of this problem as some of you have suggested, so bare with me. I am...
August 5, 2010 at 8:48 am
Because when I do not shrink the log file, it continues to request space until it reaches its limit, and then my database completely hangs. I've had this occur...
July 30, 2010 at 1:25 pm
Ok, that failed with an error, but I am getting a logfile created for this job. I can see from that log that the problem is my step to...
July 30, 2010 at 11:55 am
I tried that, but I kept getting authentication errors. Not sure what was causing them, but they wouldn't go away.
I eventually used SQL Manager Lite for SQL Server (http://sqlmanager.net/products/mssql/manager)...
December 24, 2009 at 10:50 am
Viewing 9 posts - 1 through 9 (of 9 total)