I have this appllicaiton in my PortableApps collection: it finds keys for 2000/2005/2008, and ifg you know where the key to anything is stored, you can add it to the...

Elliott Whitlow (12/22/2010)

---

Ok, SQL Sever must be using an either local account (created on the machine) or a domain account to login. This account is what the services use....

it has to do with your function...if you did not use WITH SCHEMABINDING in the definition, i'm sure the function is non-deterministic, and thus any column that uses the function...

SSMS uses the extended stored procedures master.dbo.xp_sqlagent_monitor and master.dbo.sys.xp_servicecontrol to stop and start the services for the agent or the service on the server.

those procs are called without...

Geoff A (12/21/2010)

---

the ability to control SQL services via SSMS has nothing to do with SQL permissions.

it is based on windows level permissions. local security and domain security policies.

users in...

only a sysadmin has the ability to start and stop the server via SSMS; so do not give their login sysadmin and you are all set; just make them a...

it doesn't matter what...

for an index to be created, it has to be on an object that exists inside the database; that way constraints can be enforced.

constraints cannot be created accross db boundaries.;...

you might use soemthing like this to help track it down.

this can give you the spid of who ran the offending statement if it was recently run:

SELECT

...

yep caught between the proverbial rock and a...

any field that needs to be searched should not be hashed; otherwise you are right, you can only get an exact match of hashed values; hashes are not sequential so...

there are some free reports from Microsoft that you can add to your Reporting Services:

SQL Server Health and History Tool (SQLH2)

looks like the insert statement from your ddl audit has a table that doesn't allow nulls for the object name;

i'm thinking that the creation of statistics might not generate a...

it is actually deceptively simple...you just repalce a palceholder in the msg body with the variable actuial value ...just make sure the variable values cannot be null, and you...

From the GUI, you cannot; switching a table from one schema to another, at least in 2008, requires a script; there's no GUI to help you do it.

The GUI lets...