You don't need to create a proc, but I would. Makes it easier. Most things you can run from SQL Server, you could send through from Access as well.

you don't...

No effect. If you disable it, it will be the same as now, same password or now.

A trigger will do this, or you can read the log later if you buy a tool.

http://www.sqlservercentral.com/articles/Security/sqlserverauditingpart1/1451/

I struggled through the Dune books. Much preferred the Foundation series.

If you want something newer, The Lost Fleet series is great, as it Helfort's War and the Clone series (Clone...

If you're interested, there's a discussion on this in our LinkedIn group as well

While I appreciate the information, there's no need to pile on. We'll award back all points to this time since the question has an error.

And as for the complaints,...

I've asked about the a la carte versions of SQL, but I think MS avoids that to prevent a nightmare of support issues. Which features do you have when you...

OK, upped the PM count to 200. I assume most people don't keep that many, but this should help Mr Moden at least 🙂

People can't post their own articles. They can submit them, but they're all reviewed.

Hmmm, I'm not sure how this is SPAM. It's listed as a case study, the description says it's a tool.

We run these sponsored articles, and they are paid for. In...

Moved to job posting

I don't like bits for things like this and I'd go with ISO. Who knows what crazy categories someone might assign, so leave room for growth or changes.

In 2000 I checked it, but didn't count on it. I tended to restore often enough to dev/test that I didn't worry about scheduling things too much. We did have...

I'm not completely sure. Why not try it in 2005 and see where it might error out? You can do the compile and not run it.

The delete message might be hard, but I'll see.