Thanks for the clarification on the OUTPUT parameter...

I'd be suspicious of your logic in the asp.net app which decides whether it is 'New' or not, and thus sets that parameter...

I'm just asking because I'm puzzled:

You define parameter @StageID as OUTPUT but one of the very first things you do is test it --if (@stageID=-1)-- but at that point...

No, TCP/IP is also enabled. I guess the implication is that if I am not allowing remote logins (port 1433) then I do not need TCP/IP. Correct? (The only accesss...

OK, will do that. I access the server remotely through Remote Desktop, so I as an admin authenticate through Windows. Sounds like a good idea to disable sa completely.

So...

I read that disabling the sa login was a good idea, but was unsure as to how to proceed. I need to create a login with the same privileges and...

I'm seeing these messages in the Windows Application Log. Curiously, not in the Windows Security Log.

I'd look in the SQL Server log, if you can tell me where it is!?...

Well, lots of discussion anyway. My 2 cents is that those of us programming since way back in mainframe days still wonder why they added lower case to the...

That doesn't seem like a bad idea, since I'm not keen on becoming a replication 'guru' for the sake of one project.

I have to force fit the old 'Access' data...

Answred my own question... SQLCompare would have upgraded my live db (SQL2000) to match my dev db (SQL2005) within reason.

Rats, did it the hard way.

I said I was sure that I had moved the db's back before, but now you have me doubting it. What you say must simply be true, I now have...

Thanks, that was exactly the clue I needed!! I couldn't figure out why it was not doing what I wanted. You also cleaned up my CASE statement as well, so...

Thanks, I'll post back when I get to this, which hopefully will be soon.

Phil

Sorry for the delay, looks like my post vaporized.

I don't know whether my db was upgraded during installation, but I can make a file copy of the db and then...

Thanks for that. It confirms my intention to install SQL2005 as a named instance. I'll shut down SQL 2000 later.

During my testing, I have no recollection that I backed up...

FWIW, those of us in the ROW (rest of the World) would like to see something other than the US format. For dates in the first twelve days of every...