i wish (sigh)

there is no access/no control...

Rodney i was able to recreate the error for tables that contain a default value, you are right.

a bandaid i found that works was to go to master and run...

wierd Rodney; I tried to duplicate your steps,but I AM able to use the script as function in SSMS when i login as my test user. i wonder why it...

ok here's another idea...besides the planned filtering, what if the application started a transaction, ran the script, and then rolled back the transaction?

if it was a valid SELECT statement, no...

with regex, i can use word boundaries, so UPDATE would be a match, but UPDATEDDT would not. same with EXEC/EXECUTE vs a word that contains the keyword.

I'm going to play...

Thanks Gsquared, your idea would work if i had control of the database.

imagine if i gave you an application: you download it, put in your connection info at your...

we have a third party database on our server, and if an issue is found in thier application, they often need a backup of the database to diagnose.

I simply created...

nope, sorry; synonyms are for Objects...Tables, Views, Stored procedures, functions, etc.

you can make a synonym for a table on db1.databasename.dbo.tablename, but not the server, database nor schema.

you could use...

it's his variables...he declared them up at the top, then lost the @ in the rest of the script:

@STARTUP_TIME datetime OUTPUT,

@SHUTDOWN_TIME datetime OUTPUT

if he replaces his STARTUP_TIME with @STARTUP_TIME ,...

I'd suggest trying to comment your code and use indenting to help you more easily identify syntax issues like this;

i try to put a comment after every END so I...

this is how i thin k it needs to be written...somewhere near the end you are calling your audit proc, but not passing the values...i think that's the issue.

also, your...

pretty sure the issue is that the error is raised BEFORE the procedure is executed.

like you identified, when the compiler tries to send 'asbc' to an integer datatype, it raises...

yes that is exactly correct. the Products table...

don't know how others do it, but I've used an updatable view. the view is basically the main products table, which is joined to a group by/subquery of the "ProductReceived"...

this is an excellent question that trips up a lot of people.

try both of these queries and see the results should be different:

select * from table a

left outer join table...