why back it up? at the moment of creation it is an empty copy of model. it would be better to simply schedule a script to backup every db at...

that's not the line raising the error; paste the whole trigger.

the error line is going to say something like this:

WHERE SomeVariable = (Select SomeVariable from someTable)

the select in parenthesis is...

this is just a WAG to get the max's without the temp table and double join;

does this return the desired results? how does it perform?

SELECT

s1.Recordid,

s1.SubrecordID,

...

well, without the execution plan that Wayne requested, we can only offer the obvious advice:

the problem is probably the WHERE statement:

WHERE (s1.Substantiation_Indicator = 'N'

OR s1.Substantiation_Sequence_Letter_Code =...

sdounds like you are trying to use this...

Stumpy D (6/11/2010)[hrSo other than indexing restrictions, there is no difference if I declare a varchar(8000) and a varchar(10) to store a 10 character string?

Seems odd as why even bother...

I don't think sql server does not have access to any printer objects; Because of that, I think what you want to do is use/create a program that reads...

i think the biggest impact on varchar sizes has to do with the ability to index the column.

if the column is bigger than 900 bytes, the index rasies an error,...

take a look at the thread below; another poster had the exact same problem, except he had semicolons at the beginning at or end;

there are some fine solutions in that...

what i was getting at is the procedure you menthioned, dbo.xpPutPalletOnQueue

if the procedure features EXECUTE AS in it, It runs with different priviledges, and your application role wouldn't need...

by normal scripts to fix this problem do you mean the EXECUTE AS clause?

I'm not sure what you mean; you should be able to create a procedure with the EXECUTE...

here's a question looking at your issue sideways:

if you are running a script to create a database and all it's objects, why not just include a backup of the...

No, MS sql server is locked into the MS windows operating systems, with no plans for multi-platform.

so while the SQL Engine itself must run in a windows environment, you...

while there is an event for CREATE_DATABASE you can use for a server trigger, stewartc's questions are right on track....it depends on what you want to do;

he hinted at auto-creating...

SQL validations typically are CONSTRAINTs, whether a UNIQUE constraint, or a CHECK constraint. you can also use triggers or even functions as a CHECK constraint...so the tools are there...but...

As...