Sorry about that.

The only thing I can offer would be to dynamically build the query, but for a large group of sprocs this would be depressing.

Would this work?

USE Northwind

select LastName + FirstName +

CONVERT(varchar(2),(DATEPART(mm,GETDATE()))) +

CONVERT(varchar(2),(DATEPART(dd,GETDATE()))) +

CONVERT(varchar(4),(DATEPART(yy,GETDATE()))) +

CONVERT(varchar(2),(DATEPART(hh,GETDATE()))) +

CONVERT(varchar(2),(DATEPART(mi,GETDATE()))) +

CONVERT(varchar(2),(DATEPART(ss,GETDATE()))) +

CONVERT(varchar(4),(DATEPART(ms,GETDATE())))

AS UID

from Employees

Hello. A list of databases can be found in master.dbo.sysdatabases.

For a rough solution, you can use a CHECKSUM approach. Below are links to an article, a script, and comments on SQLServerCentral that go me going on this.

Keep in mind that if the sproc has test variables then the data (variables in question) can be plugged straight in to the sproc and the behavior monitored.

I find that...

I’d use Query Analyzer. In fact I design my sprocs (and DTS scripts) in Query Analyzer with variables to test the sprocs, and then comment out the variables when...

Thanks for the history. Also, I too like the email notifications.

If I had to ask for one thing, it would be for the reply form to work with Mozilla....

Thanks for the information. This is shapping up to be a nice tool.

Everett

Hello.

I'm looking forward to playing with the 'Validate SP's and UDF's with checksum' over the next couple of weeks and I was wondering if there's a way to use this...

Hello. Getdate() will work. As a test I created this function:

CREATE FUNCTION x1(@x datetime)

RETURNS datetime AS

BEGIN

return @x

END

and ran this in QA:

SELECT dbo.x1(GETDATE()) AS...

It seems like even in a DTS you're going to end up using T-SQL (Execute SQL Task).

I'm curious, why are you using DTS and not a sproc or a...

Quick answer is success/failure when failure matters, completion when the package should continue no matter what.

Everett

Thanks Antares for the information.

Everett

Everett

Does anyone have a reference for log error codes? My (supposedly successful) installation recorded error codes of 2 and 997 which I believe are related to the fact that...

Here are some thoughts:

Standby and clustering sound good if your server is heavily taxed

Replication sounds good if the primary concern is disaster recovery, this route can...