Also be aware that, unless this has changed, it only allows two concurrent connections. This may be an issue if multiple people need to connect at the same time...

Another thing to look out for is security. Some databases may require CLR be turned on, some may not. Some servers may have cmdshell turned on, some may...

I'm confussed. Are you looking for an Oracle data dictionary creator, or a SQL Server one?

I would also recommend getting the book "Expert SQL Server 2008 Encryption" by Michael Coles and Rodney Landrum, Apress is the publisher. It is very good at explaining the...

You can create an internall-generated one using T-SQL scripts. Just remember to back it up and save the file, along with the passphrase used. Then, this certificate can...

Don't know if it will help, but here is a script I wrote that loops through all tables, and creates the script to look for a particular string in any...

If the objective is to essentially truncate the numbers after the second decimal place (and not actually round the number), use the FLOOR() function. However, it is Friday, and...

Have the vendor run it on the database and let you know if any records are returned.

Here is the DMV mentioned:

/*can identify all Enterprise-edition-specific features that are enabled within a user database by

using the sys.dm_db_persisted_sku_features Dynamic Management View */

--SQL Server 2008 only

USE <DBNAME>

GO

SELECT * FROM...

See the following url for an Instance Security Audit script I wrote. Hope it helps.

http://www.sqlservercentral.com/Forums/Topic1251262-146-1.aspx?Update=1

Use the following to grant VIEW SERVER STATE to a user. With this permission, they can see Activity Monitor. Please research this permission to make sure it does...

I figured someone would cringe.....

Thank you, Sean. I'll take a look at these. Much appreciated.

Pedro,

One place to look is the sp_depends procedure.

To use, just call it and give the object name. This is an example for a trigger. (You can...

I know some will cringe, but here are some UDF's that I have created for this type of manipulation. When you are in a time crunch, they really come...

Opc.Three and Steve are dead on. I would take a step back and take an inventory of who has SA rights, who has local admin rights on the box,...