ahh, i got you...so you are simply altering them with identical code so the dependencies get entered in correctly, right?

if it's grayed out, then it's already installed, right?

your only option is SSMS's output results to file.

SQL server does not have a native TSQL command to output to a file; the expectation is the presentation layer would do...

i agree with GSquared;

if the disk is NOT full, that implies someone might have put a hard limit on the max size of tempdb; you'd need to allow it...

functionally, developer version and enterprise are identical, except for licensing.

also, enterprise can't install on a non-server version of a machine...it requires a server OS.

developer version has everything you need, without...

glad i could help and thanks for the feedback!

dunno if it will make a difference, but instead of using IN()

i always use a join for the inserted table instead:

UPDATE Vendors

SET Vendors.Modified=getdate()

FROM INSERTED

WHERE Vendors.kpVendorID = INSERTED.kpVendorID

in that situation,...

saved in my snippets: bulk insert will not accept a variable, so you need to use the EXEC command instead:

--bulk insert won't take a variable name, so make a sql...

i saw your other thread on dependancy order...what does that have to do with altering your functions? i'm confused on that....

getting the objects in dependancy order is pretty easy;

here is an example:

CREATE TABLE #MyObjectHierarchy

(

HID int identity(1,1) not null primary key,

...

it depends on what you are doing Dean;

offhand, if it was a simple find and replace, you could do something like this:

declare

@sql varchar(max)

declare c1 cursor for

SELECT ROUTINE_DEFINITION...

i was going to suggest teh same thing Paul suggested...forget trying to enable/disable a trigger, simple put an IF statment to check for that specific user;

here's a handy script to...

i assumed this was pseudocode and he was using a temp table in the procedure;if it's a real table, Madhivanan is right , you'll have concurrency issues.

you need to either built your table with all it's columns, or use the EXEC(@sqlstatement) to do the alter an iupdate.

the database engine expects either a GO statement, so it...

I was stubborn and decided i had to do this the hard way via T-SQL;

take a look at my script contributions here:

Get DDL for Any SQL 2000 Table

Get DDL for...