I don't know of any way to INSERT from a stored procedure that returns multiple result sets. Is it an option to rewrite the stored procedure?

John

Greg

The CASE expression returns a result with the highest precedence data type of the all the result expressions. I'm not sure how you get round that.

John

It's not about the permissions you have. You need to make sure that the SQL Server service account has read permission on the backup location in order to do...

vijay.singh 14112 (6/10/2014)

---

Hi John,

Please find the error message below.

Msg 3169, Level 16, State 1, Line 1

The database was backed up on a server running version 8.00.0760. That version is incompatible...

Could it be a firewall or routing thing? Presumably when you run it from BIDS, you're doing it from your PC, whereas with SQL Server Agent, it runs from...

Because you can roll back a DROP DATABASE, but not a RESTORE.

John

Don't bother with the trigger. Grant the user CREATE ANY DATABASE, but make sure he/she/it is not (a) the owner of any database you don't want overwritten, (b) a...

Probably because in BIDS, it runs in your security context, whereas in the job, it runs in the context of the SQL Server Agent service account. Have you checked...

Vijay

I'm sorry, I misread your question. I thought you were asking about upgrading the server. You should be able to restore a 2000 database on 2012. What...

Vijay

There's no direct upgrade path from 2000 to 2012 - you have to go via 2005 or 2008. You don't have to go through them both, though.

John

Is the SQL Server VSS Writer service running? I think that makes backups at times that can appear arbitrary.

John

Andrew

To me, that looks serious enough to raise a case with Microsoft and send them the stack dump. Other than that, maybe someone who knows more than I do...

OK, then this is only going to help with the one you posted. Do you have any other examples, please?

John

Andrew

Yes, you will get exactly the same problem if you're using the same script or maintenance plan or whatever to back up your databases. Like I said, this is...

Andrew

Do you have any other examples of Operating system error 170, please? Whenever you get an operating system error xxx message, go to a command prompt and type [font="Courier...