Hi,

with the same error message I have tried everything. DTC settings, permissions etc. The only thing that helped was to run my distributed queries from SQL Server 2005.

I had the same problem in 2005 for 1 day. I could not see steps of the job I created. The next day it was fine. I can not reproduce...

Hans,

Please, try to do the following in the command prompt from the client computer

telnet servername 1433

telnet servername 445

where servername is you server name. 1433 is the default port for SQL...

The "correct answer" will NOT return the number of columns involved in ANY constraint of ANY table. According to BOL it will return info about the objects to which CURRENT USER...

Hans,

did you create a client network utility entry or a client entry for your server in Configuration Manager on your Client? you have to have Named Pipes enabled on the...

SA,

I say AS Expected only in relation to the linked article that you posted. The article says it was OR instead of AND and it was an empty string instead of NULL,...

Nikole,

I am glad you figured it out.

Just in case for the future: you may want to ask you system engineer to check RAID array in Computer Management (Device Manager and...

Did you see a joint episode of CSI Miami + CSI New Yourk where the bad guy kidnapped a girl so she would open the parent's safe with her hand impression?...

Do Query - Display Estimated Execution Plan and Query - Include Actual Execution Plan

Do it on both servers when running your query in Management Studion. Check if something takes...

I reproduced the SA's link above test and I was getting "Expected Results" not bug results for SQL Server 2005 Standard Edition RTM and SQL Server 2005 Enterprise Edition SP2

Try to connect on Named Pipes. If Named Pipes connect then it is a Firewall issue

Hee-Hee!

read this question right after reviewing the hardware quote for my new busy OLTP server 🙂 Nice to know my quote is better.

I would opt for None Of Above as...

Microsoft releases patches every month so probably after monthly Windows update you will have to reboot the server anyway.

Yah.

I set an sp as a startup, created a login Hacker with access to Master as db_datawriter, db_datareader and db_ddladmin. Connected as Hacker user in Management Studio I was able to...

I would detach the database then re-attach with sp_attach_single_file_db . It does not really let you to specify a different directory for the log, but if you want your log...