Good to know, thanks

David

I don't know why DATEDIFF would return a "*" rather than the number of minutes. At least the INT version works but still very odd.

I can run the query...

and then i got this when running the entire script with the varchars--

Msg 245, Level 16, State 1, Line 10

Conversion failed when converting the varchar value '*' to data type...

I didn't get any casting errors when I ran it but I agree your version is better with having the variables as INT and...

After reworking it the @today is only use once so don't even need that variable.

SET NOCOUNT ON

DECLARE @crdate DATETIME,

@days varchar(3),

@hr VARCHAR(50),

@min-2 VARCHAR(5)

SELECT @crdate=crdate FROM sysdatabases WHERE...

Only a minor thought but if you replace the formulas with variables, I think it makes the code easier to read.

SET NOCOUNT ON

DECLARE @crdate DATETIME,

@days varchar(3),

@hr VARCHAR(50),

@min-2 VARCHAR(5),

@today...

My understanding of the licensing for SQL Server on VM's is that you pay for the CPU's used by the SQL Server instance on the VM regardless of the CPU's...

All of our production servers and SQL 2K5 Servers are running on ESX Servers with no problems so far (knock on wood). One benefit of the virtual environment is...

If you migrate a database from SQL2000 to SQL 2005 via db restore, there are few steps you should remember:'

- Read about migrating from SQL2K to SQL2K5 in BOL

- Run...

I disagree with Alex, it does not matter if SQL Server 2005 was release 2 minutes ago or 2 years ago, there is always something new to learn about...

I guess I'm not sure what you mean by trace files. Are you talking about having some piece of the database/application write data to a separate file and use...

Unless you are looking for a "bible" series, the best source, in my opinion, for information on SQL Server 2005 is Books Online and it's free. 🙂

http://msdn.microsoft.com/en-us/library/ms130214.aspx

I agree...

Very good article but you should add trace files to your option for auditing. I'm currently using Idera's tool which uses this method and been pretty happy with the...

How are you trying to connect to the remote servers?

Is your SQL Server agent running under a domain login or local account? If a domain account, make sure this...

One option without triggers would be to add a TableName or TableID column to the parent and each child table. In each child table, this tablename or tableID column...