Please review this topic in BOL as was suggested earlier. From BOL:

nvarchar [ ( n | max ) ]

Variable-length Unicode character data. n can be a value from...

I tried - but now this is an SSIS process? Please read the article I linked to earlier and see if you can provide the information we need to...

I'm sorry - I still don't understand what you are trying to accomplish. To insert into Emp from OldEmp it would be something like:

INSERT INTO Emp (EmpId,Empno,Empname,Jobno,Jobdesc,JobTitle)

...

Actually, I have no idea (yet) of what you are trying to accomplish. Please review the following article and see if you can put together an example I can...

What do you want a script to do?

Check to see if SQL Server is running, and if not - start it? If so, I wouldn't want to just restart...

Not sure what you are asking for here. Can you provide DDL for the tables, sample data in each table, and examples of what should happen in each case?

Jeff

You can use SQL Server Configuration Manager to identify all SQL Server services available on that system. Since I don't have SQL Server 2000 and 2005 loaded on the...

SQL Server runs as a service on Windows. You set the service to start automatically and every time Windows is restarted, SQL Server will be automatically started.

Just set all...

In addition to what Gordon has stated, what kind of SAN did you get? Are you going with an EVA 4000/5000/8000/8100?

When building the LUN's, pay particular attention to how...

1) Are you sure that sp_updatestats only updates stats that need it? a) if autoupdate is on this would be pointless since they would already be done presumably and...

Not sure I follow you - what did you change?

If you modified the column from a varchar to a datetime, and that column contained invalid date data it should have...

I just reviewed and SQL Server 2000 does support BACKUP WITH SNAPSHOT.

You can review the document: http://msdn.microsoft.com/en-us/library/aa173495.aspx

This definitely looks like an issue with the backup software.

Jeff

Unless you are using 'sp_updatestats' or something similar that only updates statistics on those objects that need to be updated. Running that right after rebuilding indexes will skip your...

Yep, that is it - once the drive is added as a resource for SQL Server, you can move the group to test.

I would also test by opening any dialog...

What is Yosemite Backup? Is this something provided by your SAN vendor to perform some type of Snap/Snapshot backups on the SAN?

Anyways, all of these errors are being generated...