What's so precious about your data that you don't want the user (i.e. the owner) to access it through anything but you interface?  I wouldn't buy a software product if...

So, are you saying the login used to start the service for MSSqlServer was removed?  Or just the Administrator rights were removed from the login?

I believe that the service must...

The problem is you are using an INSTEAD OF INSERT trigger when an AFTER INSERT trigger would work better.  With the INSTEAD OF trigger you have to do all the...

The only way that I am aware of to unlock a table is to kill the process that has it locked.

I agree that you should be trying to track down...

I would use max(transaction) instead of count(*) in case a row got deleted.  This would result in trying to insert a duplicate key.

Otherwise, it looks good.

Steve B

Why do you want both groupings and an ID field?  Perhaps there is a way to do a join or a sub-query if we knew why you wanted both groups...

I whole heartedly agree with Don.  Maybe some of those reasons can be presented to the powers that be.  I have no clue what you are talking about when you...

I'm curious, what kind of industry are you in where the data does not belong to the client?  I've done a lot of application development in my day and all...

I assume that you are only looking at user stored procedures and don't plan to touch the system sp's.

You could use profiler for a limited time to identity a good...

I do have a contructive thought, build a routine in your application that will check the structural integrity of the tables.  Run it when the application is started and don't...

If a vendor tried to sell me something where I couldn't see the structure of the data I wouldn't even talk to them.

You may want to do some further checking for last names that includes a space like "Mc Donald" or "O Brien".  I believe a case statement can be used in...

If you like a table definintion that can be printed on the width of a page and saved as text that can be imported into documentation, I have the following...

The apostrophe trips up many a DBA.  See discussion http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=290168

Full backups nightly sound good but you may wish to look into doing some Differential Backups (maybe every other night) to save some time and space.

Steve