Thanks for posting the solution and a link - I know it will help somebody else out in the future.

Makes perfect sense - now, can you show what you have tried so far? Please read the article I link to in my signature about how to get better...

Well, the message tells you exactly what you need to do. You need to restart the restore operation for the last log file that was interrupted.

But, if all you...

RESTORE DATABASE ... WITH RECOVERY;

Ally, no - the problem here was that Jamie was having a problem accessing the system resource database which is not referenced anywhere in startup procedures. The only way...

Glad we could help and happy to hear that you have completed your integrity checks cleanly.

and over, and over, and over - until...

Powershell is not going to be very good at loading data - since it really is not designed for that. But, you can use powershell to build the bcp/bulk...

Just to follow up - you need to verify that you have regular transaction log backups being performed on your live server. My guess is that when you shut...

Lynn Pettis (5/22/2009)

---

I know this one too well. My middle daughter has her permit now, and there are times I wonder if she even knows what she's doing, even...

I was going to show the convert method also, but Sergiy beat me to it. You could also use CAST as in:

CAST(Wages AS decimal(10,2)) / 100

Here is what I did for those accounts:

In Windows - Local Users & Groups, I renamed each group to reflect the correct server. I then dropped the logins from...

Be careful using NOT IN - there's a small little gotcha that you have to be aware of. If just one item can be returned as NULL, it is...

The requirement, as far as I know, it that you cannot mirror from 2005 to 2008 or 2008 to 2005. As long as the databases are on the same...

Saam Tariverdi (5/22/2009)

---

Thanks for the advice, it is greatly appreciated. One question -- how do I properly drop and recreate the stored procedures? I mean, what is the process...