Correct answers:1%(1)

I assume that's you, Tom? Wow... I hope I never have to troubleshoot a scenario like this. Tough, tough question. But very well laid out, great...

Stewart "Arturius" Campbell (3/19/2014)

---

snitnik (3/19/2014)

---

This question is messed up.

Option one:

The distributor needs to be the same version as the publisher

This statement is clearly wrong, as they don't have to be...

Transparent Data Encryption is another factor that can greatly reduce the efficacy of backup compression.

We did get resolution to this error message after a long back-and-forth with Microsoft. The messages will disappear if you enable CLR on your system. Change Data Capture...

karthik babu (3/6/2013)

---

Alternatively, we can use this too.. it takes about an hour to delete a million records

set rowcount 50000

DELETE FROM EventTracking.dbo.Event

while @@rowcount>0

begin

set rowcount 50000

DELETE FROM...

Would something like this work?

[reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | Out-Null

$s = new-object ("Microsoft.SqlServer.Management.Smo.Server") "SERVERNAME"

$d = $s.Databases | ?{$_.Name -eq "Sandbox"}

$t = $d.Tables | ?{$_.Name -eq "Table1"}

$t.Indexes | ?{$_.IsUnique} | Select Name

This may not be a complete answer (I don't think I'll be getting any bonus points), but I was able to get the proper output by adding -Property to the...

Without getting into the guts of your script, you can pass variables to other functions by setting the scope.

This doesn't work:

function AssignVar

{ $Var1 = "abc" }

function DisplayVar

{ Write-Host $Var1 }

AssignVar

DisplayVar

But...

Take a look at Select-String's -context parameter.

Here's an article with some examples: http://blogs.msdn.com/b/powershell/archive/2010/05/07/select-string-context.aspx

Are you using Change Data Capture?

We started noticing these same entries in the log when we were running some of the CDC functions that utilize CLR behind the...

You can pipe the results of Get-ChildItem to Measure-Object to get a count of files.

Something like this:

(Get-ChildItem -path "C:\DBBackups\" | Where-Object {!$_.PSIsContainer} | Measure-Object).Count

I tried the following and got the correct results. Perhaps others can chime in on why this behaves like it does:

Change:

if ( $specialmondaysvalue -eq 0)

To:

if ( $specialmondaysvalue.Trim() -eq 0)

The...

Something like this should work:

declare @TableA table (id int, puser varchar(5))

declare @TableB table (id int, primaryuser varchar(5), stime datetime)

insert into @TableA

select 1, 'joe' union all

select 2, 'burt' union all

select 3,...

You're looking for the COUNT function (http://msdn.microsoft.com/en-us/library/aa258232(v=SQL.80).aspx).

An example:

declare @Counts table (field1 varchar(10), field2 char(1))

insert into @Counts

select 'jim', 'a' union all

select 'jim', 'b' union all

select 'jim', 'c' union all

select 'john', 'a'...

What you're looking for is sysmail_allitems.

select * from msdb.dbo.sysmail_allitems

Here's a reference: http://msdn.microsoft.com/en-us/library/ms191278(v=SQL.90).aspx