Try this:

If you open the IIS manager, and expand your server you should see Application Pools, Web Sites, and Web Service Extensions.  Click (don't expand) Web Service Extensions.  On the...

Deferred Transaction article on Mikrosoft Website

http://msdn2.microsoft.com/en-us/library/ms188290.aspx

has this note about handling deferred transactions in Enterprise, Standard and other editions.

The same article in BOL as installed with the SQL Server 2005...

You have to be running as a domain admin for that.

Use WMI scripts, connect in a loop to each server by IP address in the IP address range of your...

I overcome these issues in 2 ways:

1. I create a Client Network Utility alias with TCP/IP as a protocol and uncheck "Dynamically Determine Port". I specify the port number explicitly whatever it...

I just downloaded it too but did not install yet. Let us know here if it worked for you.

Says only in Books Online as in ONLINE.

Does not say in Books Online as installed.

Open a report in Report Server or click Show Details in the folder view and select Edit. When it opens click Properties tab. On the Properties tab on General tab...

As they say, 3 Hah-Hah.

I always tell stories about Windows authentication. I am not even mentioning the Domain Trust.

I love cursors.

I set up my servers a certain way that a new...

Mirroring propagates updates right away. I know about the case when somebody had the upgrade failed and the mirror database got corrupted too. Next time he requested to break the...

Good question!

I had to look it up. I would implmented it (the object) differently.

This is most probably an application issue.

I am working with the third-party SW that produces the same kind of error when the values in the application don't correspond what...

Sergey,

It is just the opposite. 4 is more then 3. But this person will need to work with another SQL Server DBA. This is not a junior position, but also it...

That is correct. I decided to mention Management Studio settings because it was one of the answer options

I answered sort of correctly, but if this person selects using the Management Studio, he would not have this problem and will have a different problem. The  query settings in my...

Agree with all above. The documentation does say that "However, if you experience difficulties creating indexes, consider increasing the value of this option from its run value."

http://msdn2.microsoft.com/en-us/library/aa196708(sql.80).aspx