yes, of course. sql supports two kinds of...

something like this, maybe?:

CREATE ROLE [MyNewRole]

--Select permission (assuming every object, not specific tables)

ALTER AUTHORIZATION ON SCHEMA::[db_datareader] TO [MyNewRole]

--Insert update delete permission (assuming every object, not specific tables)

ALTER AUTHORIZATION ON SCHEMA::[db_datawriter]...

looks like mine is similar to yours; just different fields that i'm capturing.

here's what i see as the differences:

I'm using sp_GetDDL not sp_GetDDLa, which returns multiple rows. i am using...

i remember having to restart when i was playing around with lots of traces;

when C2 auditing is on, c2 traceid = 1, the default trace = traceid 2, and any...

i'm very sure you need to simply change the c2 audit setting, then just stop and start the server;

i've done it quite a few times, and that's all i did.

well i am not na expert in xml by any means, but i googled a bit and got this to almost work; this might give you some ideas:

--the query to...

I'd recommend the method Krishnraj suggested; this is especially true with big tables with lots of constraints or foreign keys or other dependancies....the GUI does all the grunt work behind...

try using greater than instead of equal in your query:that way you get everything delivered since yesterday

where DELIVERY_date >= select DATEADD(dd, DATEDIFF(dd,0,getdate() -1), 0)

Jayraj.Todkar there is no easy way to do this, and especially not easy in SQL itself.

I can think of two ways to do this:

get the execution plan as xml.

inside that...

also look at the data in delivery date: if it contains a time portion, you'll want to strip that time off as well to do your equality comparison.

--substitute zero for...

you'll get used to handling dates; this is one of the coolest things to use once you get your head wrapped around it.

the issue you are seeing is that getdate()...

i know there are some built in sp_* functions that use cursors, so i ran this query to see if you made the change, would it be easy to identify...

a quick google for me seems to show that sp_prepexec and sp_unprepare are used internally by SQL to create/use a cursor; most of the posts i found are related to...

ahh kewl let me know how that works for you; that is one of the many reasons i made this proc( and a function that does the same thing)

i had...

dayum that made for a really nice enhancement, Vincent.

here's links to two updated versions of the script.

sp_GetDDL V 309 returns the definition as a single varchar(max) of any of...