If I understand you correctly you have a primary key with two columns in it.

A search using the two columns within the primary key should use an index seek, or...

Are you talking about SQL 7.5/2000?

I used to do something similar using a Data Transformation Services (DTS) package within SQL Server.

Transfering the queries is a little more involved.

SELECT, INSERT and...

I am guessing that dope24_sa was an attempt to create a sysadmin role that wasn't the SA login.

Prior to SQL2005 NOT having objects owned by the dbo was always ended...

If you are using SQL2000 there are stored procedures that let you use ActiveX controls.

sp_oaCreate etc.

You can instantiate a copy of word then call methods from the Word object model.

I...

It is to do with the way in which EM makes its connections. You should try the new Management Studio if you have a timeout fetish. ...

Best practice would be to

• Be explicit in your field names
• qualify your object with its owner

If you truly need dynamic SQL look at sp_executesql rather than exec. sp_executesql will...

Hope the article on Symetric Keys and Certificates comes soon!

SELECT C1,C2

FROM dbo.YourTable AS YT

WHERE C1 IN (
    SELECT C1 
    FROM dbo.YourTable 
    GROUP BY C1 
   ...

Try the new SQL2005 table partitioning as a starting point but read up on backing up of the database first.

If your system is web based and .NET based then you...

At one place I worked the difference between the testing and production hardware was that the testing hardware was slightly more beefy than the production environment. The idea was...

You can only use INNER JOIN for an indexed view.

I take it that a MedicRecs record might not have a record in

• Rating?
• Providers?
• Locale?
• MedicProviders?

Where possible I design my databases so that LEFT/RIGHT...

SELECT CONVERT(SMALLDATETIME,(CAST YourBIGINTColumn AS CHAR(8)),112)

FROM dbo.YourTable

This assumes that your BIGINT is always in full YYYYMMDD format that is February 9th this year was 20060209

If you don't need double-byte characters (in SQL2000) use TEXT rather than NTEXT.

Phil, have you tried sp_executeSQL as a possible alternative to EXEC, it might give you a bit more...

CTRL R toggels the results pane off and on just like in QA.

By the way performance is almost acceptable if you stick 2Gb in your development machine.

My dev machine is...

No problems Daryl, there is actually a typo in your data because it has

2,1,8 AND 3,2,8 which is against the rules as 8 would be in the same 1st...