What did you mean by this?

Can you post...

I was hoping to see the plans when run against your live data 🙂

I went ahead and mocked up 1MM rows of test data and your query 1 performs worse...

Sqlsavy (7/27/2011)

---

Thank you all.

Well I ran the upgrade adviser on SQL 2000 server and books online says

In earlier versions of SQL Server, system object and system type names are matched...

Is it a CLR user-defined type (UDT), or a T-SQL UDT?

Try capturing the value as an SSIS double with this as your Execute SQL Task source:

SELECT CAST(MainID AS FLOAT)...

Chances are it is not a permission issue related to reaching the executable or related to something the SSIS package or executable are trying to do otherwise the job would...

Disclaimer: I am relying on my knowledge of how SQL Server Browser is meant to work. I have never actually worked in this exact scenario.

I think you're running into an...

Thanks for the reply Leo.

This is a DR scenario so the three secondary databases I have are all in Standby/Read-Only mode. The Read-Only part might be the deal-breaker and I'm...

You are bordering on "get a consultant"...but I'll throw in my two cents.

pete 85875 (7/26/2011)

---

We have a single table with historical time series data which has over 2 billion rows...

dan.forest (7/26/2011)

---

For newly introduced corporate security reasons, I need to run 3 instances of SQL Server 2005 on the same host computer, all on port 1433. I got this to...

GilaMonster (7/26/2011)

---

Ninja's_RGR'us (7/26/2011)

---

Assuming the db is usable on sql 2000, wouldn't scripting the tables and redeploying on 2k5 (or even 2000), possibly after changing the collation to something else "save...

GilaMonster (7/26/2011)

---

opc.three (7/26/2011)

---

What does this return on SQL 2000?

SELECT DISTINCT

collation

FROM syscolumns

WHERE id = OBJECT_ID('SALES')

...

What does this return on SQL 2000?

SELECT DISTINCT

collation

FROM syscolumns

WHERE id = OBJECT_ID('SALES')

...

This question came up before and IIRC .NET FW is only required for the installation package of SQL Server, not for the actual product itself.

That said, if you have any...

How large of a table is TB_ARTICLE? By "compare the 2 tables in different servers" if you mean to sync data between them, i.e. from the looks of your query...

This is true for implicit as well as explicit conversions:

DECLARE @bit BIT ;

-- no error on implicit conversion from number...