Viewing 15 posts - 571 through 585 (of 1,131 total)
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...
SQL = Scarcely Qualifies as a Language
October 19, 2007 at 3:27 pm
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...
SQL = Scarcely Qualifies as a Language
October 4, 2007 at 4:23 am
"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...
SQL = Scarcely Qualifies as a Language
September 27, 2007 at 6:47 pm
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...
SQL = Scarcely Qualifies as a Language
September 18, 2007 at 2:47 pm
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...
SQL = Scarcely Qualifies as a Language
September 18, 2007 at 2:38 pm
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...
SQL = Scarcely Qualifies as a Language
September 17, 2007 at 6:19 pm
"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...
SQL = Scarcely Qualifies as a Language
September 17, 2007 at 5:34 pm
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...
SQL = Scarcely Qualifies as a Language
September 16, 2007 at 5:44 pm
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...
SQL = Scarcely Qualifies as a Language
September 16, 2007 at 5:40 pm
As Standard Edition supports a maximum of 2Gb of memory, the outsourcing vendor is correct that Enterprise edition must be used.
SQL = Scarcely Qualifies as a Language
September 9, 2007 at 8:38 am
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"
SQL = Scarcely Qualifies as a Language
August 11, 2007 at 6:59 am
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...
SQL = Scarcely Qualifies as a Language
August 10, 2007 at 2:54 pm
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...
SQL = Scarcely Qualifies as a Language
August 10, 2007 at 9:37 am
Start SQL Server Enterprise Manager and on "Data Transformation Services", right click and select "Open Package"
Do not right click on "Local Pacakges" as that only works for packages saved to...
SQL = Scarcely Qualifies as a Language
August 10, 2007 at 9:19 am
Viewing 15 posts - 571 through 585 (of 1,131 total)