Anytime, happy to help 😀

BATCHSIZE controls the number of rows committed to the DB at one time.

This worked for me:

Add-PSSnapin SqlServerCmdletSnapin100 -ErrorAction SilentlyContinue

Add-PSSnapin SqlServerProviderSnapin100 -ErrorAction SilentlyContinue

[System.Reflection.Assembly]::LoadWithPartialName(‘Microsoft.SqlServer.Smo’) | Out-Null

foreach($linkedServer in (Get-ChildItem SQLSERVER:\SQL\MYSERVER\DEFAULT\LinkedServers)) {

$linkedServer.Script() | Out-File ("C:\LinkedServer." + $linkedServer.Name.Replace(".","_").Replace("\","$") + ".sql")

}

Jeff Moden (1/26/2012)

---

Yep... I understand that. But disabling these features is of no use if someone hacks in with "SA" privs which is why user and application logins should...

Jeff Moden (1/25/2012)

---

Nicely done.

Shifting gears a bit (and no implications about...

The environmental oddities introduced...

Wow, 20 thread views and not one poll reply or comment? Is everyone ignoring the Windows Event Log entries on their SQL Servers?

An update on this: we disabled the job that was running the process doing 1.3MM reads every 30 minutes during the day since it was learned that it was a...

From Metadata Visibility Configuration:

Synonyms...

The EXECUTE AS Clause sets the execution context to a Database User, not a Server Login. The distinction implies that the Database User executing the proc must exist in all...

You can check for encrypted connections with this query:

SELECT *

FROM sys.dm_exec_connections

WHERE encrypt_option = 'TRUE' ;

baal32 (1/2/2012)

---

So basically the scenario is let's say I have 100,000 'items' and 1,000,000 users.

Each user can rate each item 0 or 1 times. Let's assume the rating itself...

I am confident I could actually pass it off too 😛

Thanks for the guidance. I am not going to dig into the possibility of an internal memory leak. I think...

As far as I know you need to reformat the disk.

I have had a perfmon counter log capturing several counters, one of which is Available Megabytes. I can show that the number remains steady through the PLE drops and...