The Foreach container is designed for this sort of task. You use the foreach container to iterate through the list of IP addresses (perhaps as data in being returned...

I suspect that Analysis Services is using a different drive for temp files. Have a look at the configuration of Analysis Services (Properties of the server from within Management...

I just created a publication with a single sproc in it. The script include sp_addarticle for that sproc with @schema_option = 0x0000000008000001.

I changed this to @schema_option =...

In addition to what FelixG said - with an active/active cluster, when a node fails, it is potentially quicker for the (one) services that were on the failed node to...

Your problem is happening because the scope of variables. When you use the EXEC command, the statements within the EXEC cannot "see" the variables.

You could try something like..

DECLARE...

Report Builder is a click once application that is available from Report Manager for all users who are in the (Reporting Service) Report Builder role. Go to http://server/Reports and...

This solution using registered servers probably won't work very well for you. Registered servers are used by Management Studio and are stored in the registry for the particular user...

At one time I thought that the only career options for me was to move from technical to a more management style of role. I tried it and found...

To ensure that your DR site is up to date, this can be managed with appopriate deployment procedures. As far as I am concerned, every change made to a...

your options are either a domain account or a sql server login. The web application should be able to handle both - it should have a configuration setting somewhere...

It does not make sense to me for you to add a local user to an instance of SQL Server on a cluster. You really need to consider that...

The reason for tools such as DTSBackup2000 existing, in my opinion, doesn't really exist for SSIS. DTS did not help you all that much with source code control,...

We have a 19 GB production DB and I need to replicate (transactional) ALL of it to a reporting (dev) DB real time.

Is it ideal to replicate something like...

I regularly install RS as an instance so that it can run alongside another RS instance. Most commonly this is for migration purposes.

From a technology perspective, there is no...

I don't think that you can change the locking model used by replication - it is intentionally used to guarentee transactional integrity of the publication.

You are correct that if you...