>3)  Yes, you can use SQL QA 2000 to access SQL Server 2005, but only from another server. I believe that if you install SQL Server 2005 on the same server...

I think, the "Microsoft SQL Server 2005 Upgrade Advisor", which comes with the installation dvd is a good start.

>I think it's safe to assume this won't be a production environment<

How did you discover?

Basically, the procedure is OK. But how about some parentheses around it's parameters?

CREATE PROCEDURE [contact].[importContactClient]

(@userID int, @id uniqueidentifier) AS ...

I can't see, why a cursor would be necessary. Simply traverse your dependencies and issue a non-cursor call as long as you receive results.

'DELETE FROM ' + @tableX + ' WHERE...

Hello. I don't agree. First, people have no choice SQL-Server doesn't care, whether one ENTERS a time portion. That doesn't change the storage of...

Do you think there are "."-characters stored in floating point values? ;P

Of course not. The internal storage is always completely different from what you see. Never wondered how SQL...

-- There are a lot of possible solutions. The following is only one of them.

DECLARE @dtmEnd AS DATETIME,

            @dtmStart AS DATETIME

SET @dtmEnd = FLOOR(CAST(GETDATE() AS FLOAT))

SET @dtmStart = DATEADD(d,-1,@dtmEnd)

PRINT...

Of course, there are questions: will you pay me, if I do your work?

Otherwise your problem should at least be broken down to...

I wonder how many magnificent stored procedures could have been written, while you people prefer to talk ... 😉

Simply take a look at this discussion. Is it structured? Is it...

!exactly. The problem with the assumption of only one row being inserted/updated is obvious - but this wioll raise an error. The bigger problem is that inserts will go by...