These should provide some good reading on the topic of TX log management

Why is my transaction log full - http://www.sqlservercentral.com/articles/Transaction+Logs/72488/

Managing Transaction Logs - http://www.sqlservercentral.com/articles/Administration/64582/

Stairway to Transaction Log Management - http://www.sqlservercentral.com/stairway/73776/

Accidental...

Maybe this will help http://www.microsoft.com/en-us/download/details.aspx?id=22052

You should only put people in System Administrators / System Users who you want to have elevated rights to SSRS.

System users description

View system properties, shared schedules, and allow use of...

http://msdn.microsoft.com/en-us/library/ms175835%28v=sql.90%29.aspx This should help

I would recommend purchase a copy of the developer edition, costs around $50 and has the same features as the Enterprise edition, just it can only be used for development...

Can you attach the execution plan for the procedure, there might be something obivous in the plan.

As a side note, have all statistics and indexes been checked for being up...

Thanks for the DDL but it is not syntactically correct.

There are misssing columns from table1 (PCount), you are not specifiying enough columns in the union for the results table.

But from...

Another one would be to use Systems Center Orchestrator with the TFS Integration Pack.

http://www.microsoft.com/en-us/server-cloud/system-center/default.aspx

http://orchestrator.codeplex.com/wikipage?title=Integration%20Pack%20for%20Microsoft%20Team%20Foundation%20Server%202010

Use windows task scheduler would act as the alternative to the SQL Agent.

Then you can use SQLCMD, Powershell etc to write a script which will do the backup.

Yep. I'm an admin and it doesnt work for me in VS2008

Managing Transaction Logs - By Gail[/url]

Stairway to Transaction Log Management[/url]

Accidental DBA Guide - Read Chapter 8[/url]

And also remember to change the order of the columns in the foreign key to match the new primary key order. (Just in case anyone finds this in the...

Space will not release once it has been consumed, this is due to the expensive procedure of allocating more space to files.

If it grew to 5GB it will stay at...

Thanks Lynn, have tested in Dev and Test for the column change order and it does indeed now seek on the index instead of scan, for the particular query.

From the...

As Gail mentioned, figure out what is causing the log file to grow, otherwise if it happens again you will be in the same boat.

Something wanted the log file to...