I have to write it to a file later, so it is easier with...

Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 <X64>...

So I understand I would have to re-install the default and the named instances to make them failover, but will be able to keep the names of the instances in...

This is where I got so far:

$DBScriptFile = "C:\Scripts\test.sql"

$replacement = invoke-sqlcmd -query "Select CountryCode From [DBUtilities].[dbo].[EnvBuild] Where Id = (select MAX(Id) from [DBUtilities].[dbo].[EnvBuild])"

$Query = $DBScriptFile -replace "{CountryCode}",[string]$replacement[0]

Invoke -Sqlcmd -ServerInstance...

This one worked, because it has "dbo."

Thanks!

opc.three (6/25/2012)

---

😛 and then I remembered the initial intent...

Try this one:

Get-ChildItem | Where-Object {$_.name -NotLike "sp_MS"} | %{$_.Script($so) + " GO...

I tried:

Get-ChildItem -exclude sp_MS*

But I am still getting those replication stored procs in the list. :crazy:

Perry Whittle (6/20/2012)What on earth makes you think that? It's no different to any other node failure in a cluster, the instance will restart on a partner node. Where do...

okbangas (6/19/2012)

---

My first thought, is why do you want to do this? As the servers already are licensed for enterprise edition, and assuming that you have license for all the...

Yep, but how does it help with Full text indexing?

I used an insert putting convert(varbinary(max), Description) for the column.

I tried playing with

-CommitBatchSize

-CommitBatchThreshold

and

-ReadBatchSize

-ReadBatchThreshold

for distribution and log reader agents respectively and it seemed to had helped, but the replication looks slower.

Where should I use Snapshot isolation? The SPs that...

eforta.it (3/21/2012)

---

Hey

My response is going to be a complete cop-out in terms of what you want around licensing advice....

....but....

.... speak to your licensing agent and see what you can negotiate...

John Mitchell-245523 (3/20/2012)

---

If I remember correctly, you have to license every processor that the operating system has access to. (That's how it was in previous versions - please correct...