I edited the post above when I read Gail's blog, but even that isn't a great solution in toto once I started testing it. You CAN use EXECUTE AS...

What about security?

If you use stored procedures as a security method, this approach will fail. Some applications use only stored procedures for DB access and completely remove all access...

Not every DB can be virtualized. By "legacy" I imply a low-CRUD volume DB. There are far more reads than writes. You don't have a DB that...

We have DBs on the 2000 and 2005 platform (fortunately the most important are now 2005). We also have one legacy app that is 7.0 and there is no...

While we are talking primary keys -- I have to post my primary key pet peeve. It's OK if you have a reason to cluster on primary key fields...

Would...

Agree with many of these, how about another one not mentioned here -- consistent typing? We have had multiple issues of developers either being careless in data type matching...

Probably the most way-out degree on this thread: BA and MA in ancient Greek and Latin (and someday still want to be a prof of ancient history). But I...

:angry:

Never mind. I finally found the issue. Unbelievable:

http://support.microsoft.com/kb/326485

the directory to which we were writing the reports (a new location) had a "-S" in the path....

Our office has a centralized data center/IT server area with over 20 remote offices, some only 1 or 2 people, some with up to 80 or more.  All of these...

We caught and prevented one of these types of disasters -- there was a sprinkler system in the ceiling of our data center.  All it would have taken to destroy...

I can't imagine trying to do my job now as is in Vista.  I live by "shift-right-click choose Run As" to get me into admin mode on my machine to...

We restore the main production DB backup every night as a reporting backup or in case we need it for some data-related issue.  But checking backups is a very good...

Two monitors hands down.  I can put the list of jobs on one monitor and scroll through the procs that they should be calling in another.  Admin was never so...

In order to index a view, it must be created with SCHEMABINDING option in force.  This is not the default.  If the view is to be indexed you will need...