If I understand the question, you could add an extended property to identify the current version of the procedure.

You'll have to walk through the databases on the server. Try something like this. It'll work, but it's not perfect.

sp_msforeachdb 'select DB_NAME() AS ''DBName''

FROM INFORMATION_SCHEMA.TABLES t

WHERE t.TABLE_NAME = ''Customer'''

I agree with what most everyone has posted here. We have ten questions we ask everyone. They're really easy questions, insulting even, if you know SQL Server to even a...

Make sure you do the initial read to get the next 100 unflagged records with UPDLOCK (update lock) so that those records are no longer available for the next user...

Sorry, I'm just not that acquainted with the details of implementation any more. I wrote a whole app against direct calls to ODBC about 13 years ago, but... It's all...

Sorry, missed 3) I agree. Cursors are a killer. It doesn't much matter if it's client or server side. However, if you're talking disconnected, then client side is the least...

I don't know, I've seen your posts, Jack. You look pretty knowledgeable. I know I could learn from you.

BTW, we are hiring over here in the Island of Rhode (aka...

diallonina (2/29/2008)

Let me know your views and your experiences concerning this:

1-A SQL consultant told me that SQL performance was better when it connects/deconnects to every request by...

Not a problem.

You want one more, take a look at the execution plan and be sure that it's using a good index to select the record. You might be doing...

Nice article Kathi. Good job.

This article[/url] covers the basics on backups in 2005.

When you say database integrity, do you mean, data integrity as defined by primary keys, foreign keys, constraints, etc. or are you looking at database consistency and running the database...

You'll need to set a flag on the table itself, marking the records that no one else can access and include that check in your queries.

Otherwise, you have maintain...

Cool. Sounds like you're in the right track.

Sorry, I was spending more time thinking about the logic than the syntax. You can cut my pay for this job. 😉

How about something like this (this assumes one row...