Host name is passed by the client and therefore easily faked. It's in one of the articles of mine on the site, I think the one on login weaknesses. I...

I have intentionally stayed a generalist. However, like Steve I've gained more experience in the technologies I do support. What this means is sometimes requesting, justifying, and taking training courses...

If you want to ensure that ParentID of 3 is only used in TableA and not TableB or TableC, this isn't technically referential integrity. Referential integrity is about relationships between...

GSquared (5/30/2008)

---

Windows domain authentication can't chain to more than one computer. What you have to do is use "Be made using the login's current security context.", and then set...

To clarify some things...

Since you are coming in via a SQL Server login, you don't need to set up Kerberos, much less Kerberos delegation. This is required when you come...

Companies that embrace telecommuting can drastically reduce overhead costs, too. Think about the overall savings to power/space as the percentage of personnel work remote. You'll have to provide some desks...

If there are any specific objections they raise you need some help with that you don't feel comfortable posting in the forum (since this is security-related), feel free to PM...

Sounds like a great thing. I've got a couple of guys I'm thinking about nominating.

Aye. Just...

paksyeet (5/28/2008)

---

Problem:

1. how many number of database do you think a dba can handle?

2. is it possible to just have one database server where i can run scripts and have...

MPS Reports... it's what Microsoft Premier Support almost always has you run when you've got an issue. We basically run the appropriate one as we're placing the call so we...

They must have SELECT and INSERT rights on a table in addition to being a member of the bulkadmin fixed server role in order to be able to pull off...

I believe you can grant EXECUTE rights against the sp_sdidebug stored procedure. It'll be in the master database, meaning you'll have to grant the user access to the master database....

I don't have my copy handy (visiting family), but if I remember right, cross database ownership chaining isn't covered in a whole lot of detail. It's generally frowned upon, and...

Here is how to script out the logins:

How to transfer the logins and the passwords between instances of SQL Server 2005

That doesn't grab the permissions, however, as most permissions are...