No, you will still have your two input parameters declared as datetime. You are adding two new variables (@beginDate and @endDate) as datetime variables. You are then going...

This sounds like an issue with a bad execution plan for the stored procedure, or it can be related to parameter sniffing.

Try adding the following to the procedure:

AS

DECLARE @beginDate datetime,

...

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...