For DST, as there is a Windows Patch and there is no SQL Server patch, there is no SQL Server patch information to retrieve.

Rather than retrieve the value of @@trancount, test in the VB code and send a rollback if greater than 0, just always send this SQL:

IF @@trancount > 0 rollback

Simple and...

Q: How many Oracle DBAs does it take to change a light bulb ?

A: Three - it takes three Oracle DBAs to do anything.

Q: How many SQL Server DBAs does...

"What I need to do is return all Customers that have the same Flags as the Order. The Customer is allowed to have more Flagsthan the Order, however, they must...

you are correct.

When you run the package thru SQL, the package runs on whatever machine is running the SQL Server, with the security rights of the SQL Server and all OS references...

Always alter - if the procedure does not exist, then create a "stub" that does nothing and then alter. If you drop/create then any security privileges will need to...

I assume you want a user to be able to create stored procedures but not any other objects such as defaults, functions, rules, tables, or views.

Jeff's approach is prefered as...

"Before I sent the disk to be re-imaged, I stopped the database and then I burned all the database files to a DVD. "

As you are discovering, this method of...

is '24/4/98' can be interpreted as the 24th month with 4th day OR as the 24th DAY, the 4th Month. Which interpretation is dependent on the DATAFORMAT setting for...

Your SQL has this in the WHERE clause

and g.yr = upd.year(datecreated)

and g.mnth = upd.month(datecreated)

Remove the "upd." before the year and month system...

As Standard Edition supports a maximum of 2Gb of memory, the outsourcing vendor is correct that Enterprise edition must be used.

So much for that idea !

Seems MSDTC has many bugs and some do not have any fixes.

BUG: Error 3910, "Transaction Context in Use by Another Session"

Found the configuration settings:

For the child packages:

Under "Package Properties" on the "Advanced" tab:

Checked on for "Use Transactions"

Checked off for "commit on successful package completion"

For each step under "Workflow Properties" on...

For SQL Server 2005, here is an intersect with multiple tables:

select a1 , a2 from a

intersect

select b1 , b2 from b

intersect

select c1 , c2 from c

Here is the SQL...