Thanks for letting us know what the resolution was.

When I copied your code and passed in parameters as you mention in your first post and did a Select @strSQL this is what I got:

WITH Search AS

...

Here a couple of links that show how to get more information about your TX Log:

http://jmkehayias.blogspot.com/2008/11/database-transaction-log-part-2-how.html

http://sqlblog.com/blogs/kevin_kline/archive/2008/11/05/better-ways-to-get-transaction-log-information.aspx

It sounds to me like the issue is that the TX LOG is growing twice to its limit of 6000MB and then needing to grow again during the Rebuild and...

You can use the derived column transform and use the Left function.

Left(column, Len(column)-4)

Should work.

Okay, I'll chime in on the book series. I've never read Dune, but may now. I liked the Wheel of Time, read all of them this past summer,...

I just want to make sure I understand what you want. You want a trace that will identify databases that are no longer used? You can't specifically trace...

I agree it would be more polite and easier if the SQL was posted,...

Paul Morris (2/23/2009)

---

Now the issue I have run into is I get an error:

Msg 402, Level 16, State 1, Line 6

The data types char and text are incompatible in the...

How else would you refer to The Thread? We do not the gender of The Thread. ...

Here are a couple of threads that discuss converting julian dates to regular dates:

http://204.9.76.233/Community/forums/p/20619/114975.aspx

http://www.sqlservercentral.com/Forums/Topic438807-8-1.aspx

Assuming you want to create a true datetime value from the date and time portions then once...

If the Query Processor is compiling to the same plan I don't think either really matters. My preference would be to query the main table and use the smaller...

That depends on the amount of activity in the database and the amount of data that you can afford to lose in a disaster.

My general rule of thumb for backups...

This is not perfect and I am pretty sure Jeff will have a better solution, but here's an idea:

UPDATE dbo.Temp

SET Prev_close = (SELECT PREV.Close_Price

...

If you are really in SQL 2000 this link won't help, but if you are in 2005 this article may help you:

http://www.sqlservercentral.com/articles/T-SQL/62159/

Are your dates always consecutive or can there be...