....thought it was too simple.....

By writing NULL to the timestamp columns, the checksum calculation done by your Script2 then fails.

Mauro Ciaccio

Hi,

Let me add my voice to the chorus of compliments. GREAT WORK!

The only problem I encountered was with timestamp columns, for which I kept getting the following error:

Server: Msg 273,...

Thanks for that. I don't dare ask how long it took you to debug that!

Not quite sure why it's not one of the system SPs given that I would...

JDS,

I'm not sure the sarcastic tone is appropriate given that quite a few of us have pitched in to help with a variety of solutions. Your problem was exactly the...

Thanks for the link on Dynamic sql. All things I'd come across in bits and pieces, but finally an article that puts it all together.

In the case of the stored...

Hi,

I have to admit that looking at the table as it is now I don't even want to try answering your question.

BUT how about applying some lateral thinking. Can you...

Hi,

Try the following links

1) If you want to assign the SCOPE_IDENTITY to a return parameter

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=135608

2) If you simply wanto to SELECT the SCOPE_IDENTITY

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=7311

Hope that helps,

Mauro

Didn't I say it was something simple. I'd tried the following (which I'd never used before) and failed

exec sp_executesql @sql, N'@NewAcctID int', @NewAcctID OUTPUT

I've also just...

I too am what's been referred to as a Deputy DBA, and over the past 2 years have really come around to using SPs as much as possible.

I'd like to...

Great little tool! Finally something that can be used to evaluate impact of changes on nested SPs!!!

Hi Riga,

Following up on the previous reply what you need to do is the following:

a) Create a new login in SQL

b) Instead of entering a login name, press the browse...

Very good point. We are a small SW house, and as I pointed out above using SQL Auth and putting the user mgmt. in the database allows us to pass...

Well if that is the main difference, I would conclude that in our case SQL Auth is perfectly adequate PROVIDED our network security holds up. The trade-off in having us...

Amazing what one ends up taking for granted. Because we develop B2B web sites where we can specify the requirements for the client browsers, the option of not running JavaScript...

Hi,

Wow. Now that is serious coding!

But I'm not quite sure if it's not overkill. I have an identical requirement where I need to post back and save multiple checkbox selections...