The suggested procedure described in the readme file actually contains both restoring and re-install steps.

http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-C44E06B0D2A3/ReadmeSql2k32sp4.htm

-- snip from readme --

To revert to a pre-SP4 version of SQL Server

1. Detach all user...

Have a look at DBCC SHOWCONTIG and see if that may be of help to you.

/Kenneth

Though, authentication modes aren't different between SS2k an 7 (ie has nothing to do with compatibility) so my guess is also that it's the compat level that is referred to...

/Kenneth

A very short summarization would be that a 'registered server' is a link between your client tool and a SQL Server. (ie Enterprise Manager and a server), while a 'linked...

How about trying to connect with Query Analyzer..?

Enter your servername 'newdb'  ..(?) is that the name of your computer?

..and try connecting with  - windows authentication

(requires you're logged on with...

How do you name the server when you're trying to connect?

Try using a . (period) as servername and see if it works.

(this is assuming you're sitting at the same console...

Why forbid instead of educate?

Anyone into the habit of using fully qualified names (aka aliasing) their queries won't be caught unaware by this, which for those who have not read...

Also of importance - exactly what is it that times out?

That is, are you running a bulk insert statement from a QA window, from some .NET app or something else?

Sometimes...

If I'm not mistaken,

JOIN a.col1 != b.col1

..is the same as

JOIN a.col1 <> b.col1

The legacy outer join operator is *= (the one noone should use anymore)

/Kenneth

Though it's an incomplete example, for this particular item, it looks like you could scrap the cursor and just write  a

SELECT itemID, SUM(b.var1)

FROM  yadayada

WHERE ...

GROUP BY itemID

If the other...

Agreed.

Only way I know of is if you use count(*) as a value in some expression, then the result of the expression may be null...

select count(*) -...

The short answer is Yes, it's regarded as lazy and potentionally dangerous.

Why? Well, 'efficient' isn't all about 'performance' - ie there's not really any difference in the immediate performance here -...

First thought is - don't do it like that.

Why do you have 'apples, oranges, bananas' as a single string in a single column?

This is where your problem lies. Would it...

I *think* I've heard somewhere that if you do something like: INSERT ... SELECT .. ORDER BY

..then no, you can't be 100% sure that the order by would *always* be...

There are many different scenarios where an ORDER BY can be.

Exactly what does this quote mean?

Could you please provide an example?

Is it like:

SELECT  a

FROM     foobar

ORDER BY b

...or something else?

Also, what is the source...