RIGHT('0'+convert(varchar,weeknumber),2)

Something like the above.

The weeknumber will need to be a string, as if you stick a 0 to the begining of an int, it disapears, then if you get 1...

Has anything changed recently?

Report server migration

Database server migration

Encryption keys been restored

Can you run through the SSRS config tool to ensure it is set up as it should be?

What edition of SQL server are you running?

2005/2008 Standard / Enterprise

CDC is a 2008 onwards and Enterpise only feature

http://msdn.microsoft.com/en-us/library/bb522489%28v=sql.100%29.aspx

If using standard, you would need to use replication.

unless you have a way of telling SQL the order, then you can only order on what you have so that would be the id or the refid.

First off, it is best to get the terms active active, active passive out of the mind set, while these are valid terms they are not nessesarily correct when looking...

paul.knibbs (1/4/2013)

I can confirm it *does*...

1 - No, just execute permissions on the proc will be enough. They dont need access to select from the table or views, as long as the ownership chain...

In that case I would stick a server side trace on to run for an hour when the log grows to see what is happening.

You could have multiple things happening...

Not to far off

DECLARE @year INT

SET @year = 2013

IF (((@year % 4 = 0) AND (@year % 100 != 0)) OR (@year % 400 = 0))

PRINT CONVERT(VARCHAR,@Year) + ' is...

I would first check the used space of the log just before a backup is taken for a day, then you can see what space is actually used in a...

Can you detail what the process is doing at midnight to cause the 65GB log file?

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

Stairway to Transaction Log Management in SQL Server, Level 7: Dealing...

Are you doing a new installation or adding features to an existing installation?

The account which actually rights the backup is the engine, not the agent.

You will need to make the SQL Engine service run as a domain account.

You could try adding the...

You have data going into a column which it cannot fully store.

Eg Trying to insert VARCHAR(100) into VARCHAR(50)

Debug the source columns and...

Darn it, I always get confused on that, as they give you backup compression in R2 Standard, but not Snapshots.

In that case I would look at setting the isolation level...