No. The tran log backup will have removed old log records and made the space inside the file...

Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic634491-106-1.aspx

SQL has no such functions. There's no documented way to get at the storage details...

It looks like it may have to do with deadlocks. What traceflags do you have enabled? What version of SQL?

Please post in the appropriate forum next time, not just anywhere....

Just post it exactly as it was written into the errorlog. You can cut off the log datatime if you like.

Easiest way is to open the errorlog in a text...

What are you looking to do with the CLR?

In most circumstances, especially when dealing with data access, T-SQL outperforms CLR procs/function

Gautam Saha (1/11/2009)

---

Thanks I'll give that a try. Also found that the DBCC Shrinkfile with the EMPTYFILE option

is supposed to move the contents of a file to all the other...

Lots of reading. I had one where the question was almost a full screen

How many questions in...

Whoops. That's not right.

I usually use < > to...

As I mentioned in the other thread, with SQL 2000, there isn't a really easy way to do this. You could insert the results into a temp table or table...

Do you want to see all the indexes in all of the databases on the server? If index_physical_stats is run for one database, it's easy to get index names. If...

What's wrong with MS Access?

Please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post in the 2005 forums, you're very likely to...

I wrote it as a beta exam. Fairly standard, multiple choice, pass mark 700. If you've written previous MS exams, the format won't surprise you. I found several of the...

Many of the DBCC statements have an undocumented option TABLERESULTS which changes the output of the statement from text to a resultset that can be inserted somewhere.

With OPENTRAN, it'll be...