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

good question actually.

at some point, the connection to the database that is going to be upgraded has to be input...

Like me, I'm sure you've noticed that you've never seen an...

if the stored proc is doing ALTER TABLE and then anything else, i think you have to switch to dynamic sql for the ALTER commands.....that fixes the GO statement, since...

ahh, that's our point...if you don't have a handle on LOGON triggers, read up on them,...

here's a proc i have laying around for that situation with dyn named FK's: drops all the FK's on a specific column in a table

usage is simply EXEC DROP_FK_FROM_SPECIFIC_COLUMN TableName,ColumnName

if...

could it be possible that ANOTHER foreign key, a duplicate the specific FK you are looking for, but with a different, dyamically create name exists?

it's possible, unfortunately, to have duplicate...

yes you can, but you have to use a logon trigger to do it.

I'm sure there's more to it than the # of connections that you need to figure out...

yes you can change compatibility mode without a problem;

compatibility mode only tells SQL to filter the commands coming in against a set of version-specific-syntax; it does not change how the...

if the windows user has been explicitly assigned a login withthe server roles sysusers,

or belongs to a windows gorup that has been assigned sysadmin rights (like BuiltIn\Administrators),

then that user...