This can be accomplished through COM.  If you look at the object model for "DTS.Package2", you will find that you can programmatically open, modify, and save packages.

You should be able...

Carlos,

If you are able to get the /F SomePackageName.bas and /!X options working, you will create a COM-Object structured file with a .bas extension.  This is probably not what you want.

I think...

You can install the Developer edition, which is mostly like the Enterprise edition.

http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx

jg

This error, somewhat erroneously reported as a "Syntax error":

....Server: Msg 245, Level 16, State 1, Procedure sp_load_workspace_for_publishing, Line 41

Syntax error converting the varchar value 'DECLARE docinsert CURSOR FAST_FORWARD for........

Is what...

Educate him further, and he will open a chain of fried fish restaurants.

That sounds quite strange, indeed.  It would be nice if you could post up the before and after versions of the trigger so we could become more educated as to...

If you set up the Physical Disk resource for your new drive a dependency of the SQL Server resource in the resource group, EM should present the drives as part of the...

Darn system ate my post the first time through.

You don't mention any output from table3 so I'm leaving it out.  I used some different column names, so you'll have to...

Sort of a wrong question.  The trigger is created ON the database, but FOR specified events. 

You need to remove the INTO from the second select in the UNION.

You can:

select into newtable

Select columns from table1 ....

union

select select columns from table2

jg

Add this to the script for comparing the perfomance of method #4:

convert(datetime,convert(int,GetDate()-.5))

set @loop = 1

set @dStart = getdate()

--uses int conversion

while @loop <@lMax

begin

 set @d= convert(datetime,convert(int,GetDate()-.5))

 set @loop = @loop + 1

end

select datediff(ms,...

I've seen this type of problem before, where a DBCC check reported errors that didn't really exist.

We eventually traced the problem to firmware on our SAN (MSA1000), which required an...

"Usually a week later is when you experience corruption or a server crash. "

Don't forget.... Murphy's Law is not included with Oracle.  You have to pay extra.

heh

jg

Also, the timestamp changes when file growth happens.  So, you could shrink the database file, then insert enough data so that the file grows.  That will update the timestamp on...

Whaddya mean hard to understand?

IVC10100 = un-posted invoice header.

IVC10101 = un-posted invoice detail.

IVC30101 = posted invoice header.

IVC30102 = posted invoice detail.

SY00500 = posted invoice batch header.

etc....

How is that hard to...