If you're using SQL Server 2005, connection pooling can be used with application roles. There is a new stored procedure, sp_unsetapprole, which should be run before "closing out" the connection....

I don't know of any way to do this because usually upon shutdown the systems wants everything to come down as quickly as possible. You might look at running periodic...

The first thing to remember about SQL Server security is that unless permission is explicitly granted, SQL Server defaults to no access. Therefore, you don't usually have to use db_denydatareader...

The connection string doesn't provide the permissions. Permissions must be on the objects, such as tables, views, stored procedures, and the like, as previously indicated. In order to do this,...

Yes, if a linked server has been set up. Also, OPENROWSET() provides this functionality.

This article assumes that you've already installed the Database Engine and Analysis Services both. The first thing you'll want to do is verify that you've got Analysis Services installed. If...

There's a new cumulative update out just last week. I've requested and received it from Microsoft, but haven't applied it yet.

Cumulative update package 4 for SQL Server 2005 Service...

For other components, I usually check the file versions. I just grabbed the cumulative update 4 from MS. Have you noticed any issues with it?

SANS has done a good job of building a training / certification program that's considered an hands-on certification with GIAC. It might be useful to look at it as a...

Stephanie J Brown (10/18/2007)

---

In response to Andy noting that SSC has so many more members than PASS does (and that's despite Steve's constant plugs 😀 ), I'd like to note...

Renuka (10/18/2007)

---

Hi,

Actually as you mentioned, creating a role on Database B with the required access on required objects should be fine. (Im not sure if there is any other way)....

Grant Fritchey (10/18/2007)

---

PASS does offer training through the Summit and a couple of other large scale events overseas & here in the US. But, that's only the cost based side...

I'm having the same issue on one of my SQL Servers. There are numerous forum postings about xp_delete_file (which is what the clean up task actually uses). It's an undocumented...

What specifically are you looking for? OS configuration? Best practices for installing the database engine? How to integrate CLR? All of the above?

Out of curiosity, why are you doing this through SQL Server? The extended stored procedure xp_regread isn't supported for use by normal processes. Is there a reason you aren't reading...