If it's a user-owned laptop, not a company asset, this isn't going to be possible.

If it's a company owned asset, you can have the laptop be part of the domain....

SQL Server Audit is a new feature in SQL Server 2008 that is only available in Enterprise Edition. It is built upon Extended Events.

SQL traces have been around for a...

SELECT * FROM database.sys.database_principals

If you need to match that up with logins...

SELECT sp.name, dp.name

FROM database.sys.database_principals dp

INNER JOIN sys.server_principals sp

ON dp.sid = sp.sid

You usually see this when either of the following are true:

1) Something in the query hits a bug in SQL Server and causes the connection to abort. This would occur...

This will pick up users that were created using the WITHOUT LOGIN clause, but I don't know of any easy way to differentiate them from orphaned users. And likely there...

That was a fallacy. It never was.

I love SQL Server, but having stepped down from a directory services admin position less than a year ago, GPO is the right tool for the job since you're talking...

If the connectivity is really based on site, there's an easier way.

Create a custom administrative template (.adm) file for a GPO that specifies a registry location. That registry location specifies...

Store the group to instance mapping information in a shared database. Expose a call to said database to the application. Application makes the call, gets the connection string, and then...

Prakash.Bhojegowda (9/3/2009)

---

Please take a look at the possible workaronds:

1) Create a SQL login with dbo rights to the database where tables and other objects have to be created. Have the...

The db_datareader role allows for the use of SELECT against any table or view. It does not automatically allow a user to view the definition of a stored procedure. You...

Law #6 of the 10 Immutable Laws of Security:

"A computer is only as secure as the administrator is trustworthy."

Look, if I am an admin, and unless you're on Windows Server...

It's pretty much a two-step process. First, GRANT CREATE in the database on all the statements (TABLE, PROC, etc.). Second, GRANT ALTER SCHEMA on the schema itself. That should do...

Discussion here.

Yup, there are bigger problems if you've got a rogue admin on your hands. And there are more worrisome vulnerabilities out there. *cough* IIS5/6 FTP *cough*