Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic782083-359-1.aspx

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

SELECT < Column list >,

CASE WHEN AuthorDate IS NULL THEN '' ELSE 'Last Upload: ' + CONVERT(VARCHAR(30), AuthorDate, < Appropriate formatting code >) END

FROM Documents

Got an older backup?

You can try a log...

No. An identity can be set to start at any number and increment by any fixed interval.

I do have to ask, why do you want values like this?

Well, I'm not a DBA anyway but...

Probably as a web or front-end developer. I still enjoy coding. I was half-planning some years back on going back to dev. A friend...

Sudeepta (9/3/2009)

---

Thanks for your response, Gila. Unfortunately, the Job History and SQL Server Error log doesn't reflect much. The only information it gave that the backup log is failed with...

Sudeepta (9/3/2009)

---

We found that for one DB (Say A), the t-log backup was failed. I have verified that the disk is having enough disk space and the T-log has 500...

sql_lock (9/3/2009)

---

Dave Ballantyne (9/3/2009)

---

My favourite is the over eager virus...

Did you add a location or did you replace the location with the new one?

If you added a location then you're asking the backup to be striped across the two...

Brackets around the select shouldn't be there.

What do you mean by 'not working'? What's it not doing that it should be?

Please read through this - http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Maybe.

Can you read through this...

That used to be true, somewhere around version 6.5.