forsqlserver (5/10/2012)

---

I want to implement this feature in my Production...NLB of Web Server with SQL Server Peer to Peer replication.

which one is better Merge or Peer to Peer replication for...

Here is a start for you. Post back if you have more questions:

Add-Type -AssemblyName “Microsoft.SqlServer.Smo”

######################################################################

$instanceName = '.\STD2008R2'

$databaseName = 'test_multi_files'

######################################################################

$server = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server -ArgumentList $instanceName

$database = $server.Databases[$databaseName];

Write-Host ("$database has "...

I would opt for PowerShell + SMO + BCP.

Pseudocode:

1. Using SMO loop over table collection for your database.

2. Inside loop call BCP once for each table and output data to...

I ran into another issue Tuesday and finally nailed it down to a file-copy operation that occurs prior to restore, but after the the block-level copy operation. I am just...

+1

Re: Visual Studio 2005/2008/2010 are all 32-bit programs,...

AIRWALKER-375999 (4/20/2012)

---

opc.three (4/20/2012)

---

AIRWALKER-375999 (4/20/2012)

---

Thanks for your response. I have already tried that appraoch but because the files are created at the same time the 2nd watcher does not recognise...

By default those types of errors do not go to the SQL Server Error Log or anywhere else except back to the client. You could setup an Alert to let...

I do not think Enterprise to Developer is a supported 'upgrade path'. I suspect you will need to install new Developer instances, and uninstall the Enterprise instances. Check with a...

It was deprecated and left behind because the OLE DB provider for ODBC performed horribly and there was little support for it moving forward with the energy being dropped into...

It may generate fragmentation. It will depend on the number of CPUs you have and whether SQL Server decides to parallelize the insert. All an ORDER BY will do is...

Anytime 🙂 If you happen to check out TRY_CAST and have a moment to spare, could you post back for later viewers to know how you got along with it?

If LoadDate is ever-increasing, you always insert your snapshots for a given LoadDate using a single insert...select statement (i.e. you never go back and add rows with an existing LoadDate...

An option on SQL 2005 would be a SQLCLR function similar to TRY_CAST specifically to handle XML, and return the original string if it is valid, else return escaped XML...

On SQL 2005 your only option is to check each :angry:

If you have an instance of SQL 2012 around it can be used to identify the bad XML using the...

phil.layzell (5/8/2012)

---

Hi everyone,

I am due to make a change to our 2005 Production DB. This change involves updating a Text field to XML.

The questions are:

•what impact will this have on...