Are the keys stored under HKEY_LOCAL_MACHINE\SOFTWARE\....\Registered Servers X, or under HKEY_CURRENT_USER\SOFTWARE\....\Registered Servers X?

If the former then your EM options (Tools/Options) should have "Read/Store user independent" unchecked. If the...

Kevin,

The last example won't throw an error because it's a valid SQL string. The lack of intervening spaces means that the doubled quotes are interpreted as single quotes.

If you...

Tom,

I'm not absolutely sure of what you want, but try this....

 

declare @var sql_variant

exec sp_executesql N'SET @var = (SELECT StaffID FROM Staff WHERE (lastname =...

I've never heard of a change of password having such an effect. Your Windows account didn't change at all did it? Eg. Account deleted and then added back in...

No there's no ROW_ID. But, I'd like to see it in the next version.

Is there any column that differentiates between the duplicate rows (an identity column perhaps)? Or,...

I obtained a connection to administrative share (C$) on the server from from workstation (the administrator supplied the password). Initially no success, but after a series of steps which...

Could it be a remote login timeout?

How does a Query Analyzer select from the linked server perform?

Cheers,

- Mark

VB I'll accept. Thanks.

But swan draught is a threat.

Cheers,

- Mark

Here's one way...

 

select Counter from

(SELECT DISTINCT storeNumber FROM tblStore) storeNumbers

RIGHT OUTER JOIN

(

    select n1*10 + n2 + 1 [Counter]

  ...

I thinks it's difficult to replicate this Oracle functionality.

However, in osql (or a sql script submitted to osql) you can try host commands (!!) that also call osql. ie....

I encountered a similar problem on a box recently. Despite being connected as sa, I didn't have any administrative rights on the server.

I don't know if the cause your...

Maybe a bit convoluted, but it does the trick:

select CONVERT(varchar ,getdate(),101) + ' ' + LTRIM(STUFF(RIGHT(CONVERT(varchar ,getdate(),109), 14), 9, 4, ''))

Cheers,

- Mark

I've done this before for similar situations. It requires some changes to master stored procedures - notably sp_MSdbuseraccess.

I'm not sure of the implications of applying service packs thereafter. ...

see my comments under "General"

Cheers,

- Mark

By default the columns should line up ok. Are there any characters in your output (tabs, crlfs, etc) that could be throwing things out?

You might to need to employ...