That's not the source...

I take it that your Month data is numerical and non-repeating, i.e. January of your first year is '1' and January of your second year is '13'?

Where is your source...

Correct. The drive letters and sizes can be different on each cluster.

Make sure that if you have a firewall between your two clusters you have set the appropriate firewall rules...

It looks like the 'To' parameter need to be set explicitly, but you should be able to get a 'cc' list from a text file, e.g.

foreach ($recpt in $recpts) {

$to...

The error is telling you that import-txt is not a Powershell cmdlet....which it isn't. To read contents from a .txt file use this command:

$recpts = get-content "d:\services\EmailList.txt"

Make sure that each...

We use SQL Sentry by SQL Sentry Inc. I don't know how it compares to the other products you listed, but it is a lot cheaper! 😉

There is also some...

There's an article in today's SQLServerCentral.com about horizontal partitioning:

http://www.mssqltips.com/tip.asp?tip=1796&home

As far as I am aware, SSRS is not cluster aware so you would need to install it (and IIS - unless you are using SSRS 2008 which has dispensed...

Bharatvip (7/22/2009)

We have 11 databases and only 2 databases (not tables) that have data changing in them (get hit by the application). One of these two databases X (has about...

It does work in SP1. There have been improvements (performance-wise) in SP2 and SP3.

If you have a list of recipients in a CSV file, this should work:

$recpts = import-csv

if ($body.Length -gt 0)

{

#Create a .net mail client

$smtp = new-object Net.Mail.SmtpClient("10.4.54.22")

$subject="Microsoft SQL Service...

You could possibly create a named set using the MDX 'EXCEPT' function, e.g.

CREATE SET [YourCube].[SelectedProducts] AS

{ Except( [Products].[ProductName].AllMembers , { [Products].[ProductName].&[11],

[Products].[ProductName].&[12], [Products].[ProductName].&[13] } )

}

I'm making assumptions about what your Dimension...

Hi Vip,

I'm not sure that I fully understand what you are asking so if my reply does not address the questions you are asking, please shout!

1. Yes, you should be...

Hmm, ok. I notice that you are not using a fully-qualified TCP address, e.g. "TCP://svrbdb..com:5022".

Try specifying a fully-qualified TCP address.

Regards

Lempster

netstat -o will show you the established ports and as 1433 doesn't appear in the list then it should be available. You can confirm this by running: netstat -an |...