I can recommend two. If you want a GUI on it, use the Quest tool:

Discovery Wizard for SQL Server[/url]

If you want to automate it, use SQLPing3's command-line version. BTW, the...

The only option that doesn't require a 3rd party product is SQL Server 2008 Enterprise Edition. You're looking for Transparent Data Encryption.

Third party backup products like Red Gate's SQL Backup...

Barkingdog (4/12/2010)

---

I work with a dev who would lke the following permissions on several databses, on different servers (sql 2000, sql 2005, sql 2008). Is his request a reasonable one...

Try to avoid assigning any permissions to public. That's a worst...

I would not recommend C2 audit trace unless you have a regulatory requirement for it. You can create a much more lightweight server side trace to audit logins. Or better...

I can tell you SQL Server 2000/2005/2008 are compatible with AD2008. R2 doesn't fundamentally change authentication mechanisms, so far as I am aware. So all 3 supported versions should still...

It will follow what is set on the server. The server should be getting it from the default domain policy. If that is 3 months and you enforce both policy...

I'm surprised you didn't scoop everyone with SQL Server 2008 R2 releasing on Linux.

EDIT: Saw Steve's response. My comment is based on this article - SQL Server on Linux[/url] -...

Even though it is generic, can you post the error message?

Also, try and query something that should be available to everyone through that linked server connection. For instance:

SELECT * FROM...

In SQL Server 2000 and below, no, there's no way to do so. In SQL Server 2005 you can use the EXECUTE AS clause as part of the CREATE PROC...

Are the IIS servers configured to use Negotiate,NTLM for NTAuthentication providers? Because you're working with SQLTest02 is not necessarily a sign that Kerberos is being used. Because the web...

I believe that's a login failed error code (do a Bing search for 0x80040e4d and you'll see other instances, not just related to SQL Server). Has the service account for...

This Microsoft KB article details how to transfer logins between SQL Server 2005/2008 instances. It will require you to create a couple of objects in master on the development server.

How...

As mentioned previously, schema tend to be the way to go, although we usually grant VIEW DEFINITION at the database level for our developers to be able to see the...

TDE encrypts the data at rest. That means the file on disk and any backups generated from that database.

It doesn't keep the data encrypted if someone has legitimate access to...