michaela (4/7/2008)

---

It's a fairly easy select to be run, no need for sps;

use yourdb

go

select dp.NAME AS principal_name,dp.type_desc AS principal_type_desc,

o.NAME...

Yes, for SQL Server 2005 I was thinking of the EXECUTE AS clause as that allows us to get away from assigning rights against the base tables. It means we...

Piggy-backing on what was already said...

Create a database role and grant it the rights to execute the stored procedures. Make the user a member of that role. Don't assign rights...

Let me preface this by saying I intend no offense.

Tools are great and I'm all for them. However, having the script in your back pocket (or knowing how to build...

Try to log on to a system with that username / password combination. Verify the combination you were given is valid.

Maybe using a tool like SQL Data Compare? It's effectively doing the same thing, but it may help you find/display the problem children a bit easier.

On a related note, anyone...

A small but important point with respect to SQL Server 2005... If the database is in 90 compatibility mode (SQL Server 2005 mode), technically your objects don't have owners. Your...

A KB article I always have handy:

How to transfer the logins and the passwords between instances of SQL Server 2005[/url]

If you run sp_help_revlogin periodically, you can ensure that not only...

Each instance of SQL Server (this is important, because it also applies to a non-clustered setup with multiple instances) has its own master database. In the master database, the information...

The SQL Server Agent job goes back to before SQL Server 2005 service broker and here's how it works.

There is a job that runs periodically which polls a table. That...

If you are using SQL Server 2005's SQL Server Configuration Manager, if you expand the SQL Server 2005 Network Configuration in the left pane, you should see Protocols for ***...

EdVassie (4/3/2008)

---

Be aware that the concept of 'C2 Auditing' is obsolete. The C2 level was based on the old US DOD 'Trusted Computer System Evaluation Criteria', that became obsolete...

James Greaves (4/3/2008)

---

And we have seen that even these fields with their established standards don't always produce what you'd expect based on the qualification. We make jokes or here stories...

James Greaves (4/3/2008)

---

Until the Information Technology field has an established organization with standards like lawyers, doctors, and engineers, charlatans will always be there hocking skills which do not exist on...

First piece of advice: get Microsoft involved. You've got an enormous amount of risk here.

If you're looking at re-using one of the sides, you'll first want to run the setup...