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...

nope there's no way, AFAIK.

your options are to use a trusted connection with their windows login so you don't need the username and password at all,, or to use EXECUTE...

--edited, as a duped answer that does not work....

i think his new "SQL Spackle" which is code used to fill in the cracks counts as one....

For reference, this is readily consumable data: Anyone can copy and paste this sample data into SSMS and then start working.

i changed all your column names.

SELECT 1 As OrderID,1 As...

at our shop, it's still starts with the basics:

backup...restore.

then a custom script we wrote munges the data....deletes records and child records based on FK hierarchy...which can be a real pain....

it might take a bit of work, but this article teaches you how to read the transaction log that is in full recovery, but no backups to recover with:

http://www.sqlservercentral.com/articles/Transaction+Log/71415/

the author...

no, you read it right...my attention deficit order only let me read the first eight words of the thread before i came to a conclusion...

Thansk Paul!