Could you show us the restore command you're using, the messages you get out of the restore operation, and the DBCC commands you issue after the restore is complete? ...

Permissions problem? When you run it under your credentials, it works, but the agent is using the credentials of the account the agent is running under. The first...

Is it the time portion of the date that causes the incomplete delete? Getdate will return a time portion also and subtracting days will leave the time portion intact...

Just a shot in the dark without being able to see the code, but if you're using the variable in any concatenation operation, you might want to set the CONCAT_NULL_YIELDS_NULL...

So it's

select '09' + Ther_id

or

select '09' + convert(varchar(4),Ther_id)

depending on whether Ther_id is a character or numeric datatype already.

It sounds more like a concatenation problem rather than a substring.

select '09' + convert(varchar(4), id) from ....

will get you 09xxxx where xxxx is the id. If the id...

Tacoma, Washington

Born and raised in Cannonsburg, Kentucky

Lived in Huntington Beach, California, for 9 years then moved north and plan to stay. Washington is beautiful, the people are friendly and...

I'm not sure there is a 'best practice', but here's a link to a Microsoft article that, I think, covers what you want to do.

http://support.microsoft.com/kb/272318

Good luck.

When the database is in full recovery mode, the log will grow until you back it up, at which point, it will remove the committed transactions and reuse the space...

What recovery mode is the database in? Can you back up the log to another drive?

Judging by the tone of the posts, I think he meant 'you couldn't have been more helpful' . It was a sincere 'thank you', not a complaint.

Build another table. Copy the data from all the individual tables into the central table and add a customer id, if there isn't one already. Report from the...

They spent 4 months testing the applications to make sure they would work in a native 2005 environment. The test databases were also in 2000 compatibility mode, so they...

Yes, it's a strange position to be in. I just found out that the outsourcer, who shall remain nameless, was paid to migrate some databases from SQL Server 2000...

If all you're really trying to do is reverse the string, why not use reverse()?