#1 problem:

select sql = '''2'''

You are trying to make your variable become '''2''', but that's not a variable. It's missing the @ symbol.

select @sql = '''2'''

-SQLBill

Nope. The issue is with NAMING stored procedures. This is why you should NEVER name a stored procedure with the beginning 'sp_'. That automatically defaults to the master database....

And when you select View Job History, the next part is to check the box.."Show Job Steps". That way you can see the exact step that failed.

Quick guess.......you are probably...

Nope...the PRINT part is only part of the sp_who created in Northwinds. When the script actually runs (EXECUTE sp_who) it runs the version in Master. That is why...

It's not that you shouldn't post Oracle questions. You'll see others do it since some people have to link Oracle and SQL Server databases. However, you should let everyone know...

You say "I have a full and differential backup, while restoring differential backup I have used recovery option." But the only command you show is the one above and...

You say " I see the new log created". So it seems you only checked the new log....take a look at the previous log also. There will be more than...

You cannot revoke sysadmin from SA. That login is 'wired' in by Microsoft and can't be changed. However, if you really want SA to 'not work', you can change the...

I would look at the server. Did it 'crash' also? Was there a power surge? Also, look at the 'previous' SQL Server error log. (Restarts create new logs). See what...

What were your restore commands? Is this database part of a publisher/subscriber replication?

-SQLBill

Just some advice.......that looks like ORACLE syntax (TO_CHAR, SYSDATE, SUBSTR), not SQL Server syntax. You might do better by posting ORACLE queries in an ORACLE site. While some of...

How do you backup the databases? You CANNOT just 'copy' the .mdf and .ldf files to tape. It won't work...well, you can copy them, but they are unusable.

There are two...

Use the ALTER DATABASE command to set them:

ALTER DATABASE dbname

SET Quoted_Identifier ON,

Arithabort ON

Then to test for them, check the DATABASEPROPERTYEX.

SELECT DATABASEPROPERTYEX('dbname', 'IsQuotedIdentifierEnabled'),

DATABASEPROPERTYEX('dbname',...

Is there only one instance, or do you have several SQL Server instances? If you have more than one instance, you must run the upgrade for each instance.

-SQLBill

Okay. You stated what you need to do. So what's your question?

-SQLBill