Thanks! That seems to be working. I appreciate the guidance.

Unfortunately, the ClientDelete stored procedure contains significant information about the database structure for my entire application and I can't post that without breaking security rules.

Could I set @@ROWCOUNT = Select...

Thanks! This has given me a lot of good information to research and understand.

I gave up on getting 'time' to learn about my database because of overscheduling at work,...

Thanks! My properties show:

File Growth

By Percent - 10%

Maximum File Size:

Unrestricted file growth

Are these reasonable settings?

Steve and leepozdol -

OK - that makes sense. How do I find out how much growth space I have in the database? I have searched the BOL and looked...

Based solely upon this post - I'm ready to preorder the book. When can we sign up?

I think this might work. Thank you for the suggestions.

Sweet! I didn't know about jobs before this and this is just the answer I was looking for to run a query every hour. Thanks!

Thanks, Brian. Very easy to understand and follow based on your presentation.

Brian,

Interesting video. I work in a system where we don't use views because only the lead developer and myself (the DBA) directly access the database. Would there be...

My theory is - if you have a secure job at this point in time - keep it (even if it is not your dream job). I am working...

Personally, I don't know that 'clothes make the man (or woman)'. My current office runs to nice casual clothing, but we dress up when we are meeting with clients....

That should work. Thank you for your assistance!

I must not be explaining myself very well.

The problem is, I need to have the SET clause look like the following WHERE h.AppraiserChangeType = ''R''

AND h.AppraiserChangeType = ''M''

'UPDATE pa SET...

Steve,

I probably need to include both conditions because if the AppraiserChangeType = 'M', I need to update one more field than if the AppraiserChangeType = 'R'.