What entries in the SQL Server log do you see for Service Broker?

Unfortunately, I do believe you're going to have to live with granting VIEW ANY DATABASE.

I'm not familiar with the product, but there are a couple of things it might be.

First, did anyone remove BUILTIN\Administrators or reduce its permissions within SQL Server? Second, if that...

If the virtual server name is sqla17 and the instance name is sqla17n1, the connection would be to:

sqla17\sqla17n1

One thing you might want to check is to see what port SQL...

Or simple SELECT @@SERVERNAME, which you can use to verify you are connected to the SQL Server you think you should be connecting to.

You can easily write a script to create a script. Something along the lines of:

SELECT 'CREATE USER [' + sp1.name + '] FROM LOGIN [' + sp1.name + '];'

FROM [sys].server_principals...

Cory Ellingson (4/11/2008)

---

individual Table restores are not possible yet. An option is to restore the DB to a new name or server, and then copy the table(s) needed back...

Have you verified your DSN by clicking the Test button? Have you turned on Audit for Failures with respect to SQL Server? If so, are you seeing an audit failure?

TDuffy (4/11/2008)

---

Nice article thanks.

One thing I found interesting in 05 is that when you use the UI to script an existing login, it still uses the old syntax!

/****** Object: ...

WITH GRANT gives the ability to also GRANT that permission.

If you just GRANT SELECT to John, He can SELECT on the table.

If you GRANT SELECT and use WITH GRANT to...

SecurityAdmin cannot grant rights to himself/herself.

SecurityAdmin cannot enter into a database unless specifically granted permission.

SecurityAdmin can't add anyone to the SysAdmin role.

SecurityAdmin can't reset the password of...

Tom Garth (4/11/2008)

---

Great article Brian!

An application that I wrote has an interface for the app admin to create and manage users, and role memberships. It has been running on SQL...

This is true, the default trace has it, too. However, you'll need to read it using Profiler with respect to user-related events. The report handles objects (DDL changes) just fine,...

If Windows authentication is used, a hash is sent. This would likely meet the requirements. If SQL Server authentication is used, while technically the password is encrypted, it is an...

MarkusB (4/4/2008)

---

Sorry Steve,

that's not an option.

First of all SQL 2005 do't allow you to remove...