are you using SP_OA calls?

please can you post the code that generates the error...

that error is typically a COM/REGISTRY issue for an sp_oa call to a DLL

im guessing that the OP wants

Apples

bannanas

Chocolate

Coffee

turning into

A

Apples

B

Bannanas

C

Chocolate

Coffee

in SQL 6.5 you would use the command DBCC CHECKDB

something like this

with x (id,letter)

as

(

select 65 as id, CHAR(65) as letter

union all

select ID+1,CHAR(id+1) as letter from x

where ID<90

)

select letter as name from x

union all

select name from sysobjects

order...

are you doing full backups at any point in your maintenance plan - log shipping does not prevent you from running full (non-copy only) backups - it just re-starts your...

Jonathan AC Roberts (6/1/2012)

---

michael vessey (6/1/2012)

---

If you are supplying SQL Server have multiple vendors and using SPLA licenses the cost is not far off $1,000 per cpu per month for...

If you are supplying SQL Server have multiple vendors and using SPLA licenses the cost is not far off $1,000 per cpu per month for enterprise edition, possibly half that...

You could get a multiprocessor SQL Server machine with a $1000 a month per cpu license fee or you could find an open source database that would do the necessary...

Jonathan AC Roberts (6/1/2012)

---

Hugo Kornelis (6/1/2012)

---

Jonathan AC Roberts (6/1/2012)

---

IceDread (6/1/2012)

---

I see no valid reason to why you'd want to do this.

If you want to go from MS Sql server, you...

Jonathan AC Roberts (6/1/2012)

---

Hugo Kornelis (6/1/2012)

---

Jonathan AC Roberts (6/1/2012)

---

IceDread (6/1/2012)

---

I see no valid reason to why you'd want to do this.

If you want to go from MS Sql server, you...

+1 hugo

it's also a complete re-hash of an article posted 30 days ago

http://www.sqlservercentral.com/articles/MySQL/88971/

both referencing the website convert-in.com

perhaps they should pay for an advert rather than posting articles with inaccurate content...

sqlnaive (6/1/2012)

---

Can you please suggest what steps should i take or what data should i capture which might help in finding the root cause during the time when that proc...

i...

why don't you have a look at your wait stats? - flush them before you go home and then if there is an instance then you can maybe see if...

does that include the heartbeat IP addresses as well?