BEGIN DIALOG CONVERSATION is the name of the BOL article. I did not know that we had names for the TSQL statements. I thought TSQL statements have  a syntax. In...

Hi Rob,

Here are some hints and some experiment results:

a batch file accepts parameters. I created a sample sqlcmd_allservers.bat as following:

sqlcmd -S %1 -Q"Select name from syslogins"

PAUSE

here the query is any...

BOL says: "...Analysis Services Scripting Language (ASSL), an XML-based syntax used with XMLA to administer Analysis Services..."

So the name of the language is ASSL ?

Check out this:

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

Before running the Update query, I normally would run a similar Select query to check if the appropriate rows would be updated properly. Try to run a Select with all...

Could you please describe what the user is trying to do and post the error message?

go to the discussions for this article, in the discussions there are scripts for the remote servers

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=102&messageid=15135#bm399366

the reply by Guus Kramer is a script that at the second part...

You can get Visual Studio 6, Visual Basic and Visual C++ references from MSDN library

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

something probably related to Server Principal Name registration. Normally comes up with Delegation, when you are trying to use your Windows account to connect through the second server to the third...

Did you read today's article of the day?

it is exactly on the topic

Andy,

with WMI you have to be an admin on the server to use it.

Did you see the today's article by Greg Larsen? There are several steps for the linked servers that can help

http://www.databasejournal.com/features/mssql/article.php/3696506

Setting Up Delegation for Linked Servers

I did not get it.

BOL says :"Use real-time ROLAP for current data that is being continuously updated" so I selected B.

Why it is a wrong answer?

How did you create the linked server? Did you specify the login mappings on the security tab?

Isn't it called Dictionary Objects?

http://www.microsoft.com/technet/scriptcenter/scripts/misc/diction/default.mspx?mfr=true

Dictionary Objects