'sp_OA***' procs have always been on a bumpy road.:sick:

With sql2005/8, if you can, convert all extended sprocs to CLR modules.

it the rollback takes to long, just stop/start sqlserver.

Also keep in mind, this rollback may cause issues on your linked server (if updated).

In that case, what would be wrong with this ?

/*

What would be wrong with This solution ?

Keep in mind it starts with date 1900-01-01

*/

;With cteSum

as (

Select sum...

You need to add the date column to your time column or you will end up with negative times

Work with datetime datatype so at the end you just need...

With sql2000 I used to run sp_updatestats and dbcc updateusage (0) with count_rows after the...

There will be an overhead when deleting rows, and because the dependant table will be empty, that overhead will be minimal.

But If you have control to that process, you could...

JacekO (4/15/2009)

---

...I tried to exeute it directly in query window to test it's impact on the temp tables but the server claims it does not exist. So who the heck...

An other alternative to Gregs proposal:

(Only a referenced table cannot be truncated without first removing the relationship.)

from BOL: "Truncate table"

You cannot use TRUNCATE TABLE on tables that:

- Are referenced...

As I learned from Gail Shaw, the issue of outdated statistics with sql2000 caused by the way your data is added/deleted/updated shouldn't be an issue with sql2005 anymore. Its statistics...

from bol:

Temporary Tables

You can create local and global temporary tables. Local temporary tables are visible only in the current session, and global temporary tables are visible to all sessions. Temporary...

Aparently The BusinessEntity table is an implementation of a SuperType table.

Tables Person, Store and Vendor are Subtypes

As is with that implementation, BusinessEntity only provides a means of unique key for...

Can you add SP1 ? support.microsoft.com/kb/968369

BTW. your version numbers are incorrect !

They don't publish like 10.00.***

but the results I get are like 10.0.*** (SP1)

(with both

SELECT SERVERPROPERTY('productversion')

select @@VERSION

)

And...

You are correct.

Apparently MS is also promoting the .Net infrastructure to achieve optimal integration.

If you are developing a new application it is recommended that you consider using ADO.NET and the...

Use SQLNCLI as much as you...

Technically that isn't a problem.

However, symantically that doesn't make sence to me.

If the BusinessentityID is non nullable, you must first assing the person to an existing business entitiy ?

If BusinessentityID...