Try this script. Remember to set the context to the database you are interested in before running the script.

/* ================================================================================================================================ */

/* = ...

I found this software back in the summer. Has a 15 day free trial. I installed it for testing and it was nice. You can see if...

Check for the maximum number of connections that the os allows to the workstation. It may be 10 for non-servers. Whatever the number, only that many SQL connections...

Don't know if this is exactly what you are wanting, but I wrote this to search all tables for occurance of given string. Just change the database context line,...

Unfortunately, I have a food court server with several databases for almost as many applications. Some vendors have access to their databases. Also unfortunately, some have db_owner rights...

Just to add my scenario, I have multiple SQL Servers (approx. 8), with a few databases on each, not big, largest db is 25 GB. (One Oracle DB is...

See the following url for an Instance Security Audit script I wrote. It prints in columnar format, and you can change one variable to make it print the actual...

Of course, SQLServerCentral.com is great for SQL Server, but for one-stop-shopping, you might try http://www.databasejournal.com. It covers SQL Server, Oracle, DB2, Access, MySQL, PostgreSQL, Sybase, etc. ...

Well, that didn't work very well, did it. You get the picture.

http://www.sqlcourse.com/index.html

Try this:

I know it is still early in the day, but given the logic of the select and update, would this not work?

UPDATE AGS_Hands_InProcess SET

Win= 5, -- the value from the...

If you don't have any mount points, here is a script for using the xp_fixeddrives function. The threshold is set in the if exists line, and sends an email...

FYI... Here is the batch file line that I use to run a .sql script.

sqlcmd -S MyServerName\SQLEXPRESS -E -i C:\SQLScripts\SomeScriptToRun.sql -o C:\SQLBackupLogs\SomeDescription_backuplog.txt

It will write the output log to the SomeDescription_backuplog.txt...

First, see the following url for an Instance Security Audit script I wrote. It lists out all the users, roles, and object permissions for every database in an instance.

See the following url for an Instance Security Audit script I wrote. It will tell you whether you have a DENY in your permissions for the database. Hope it...