Kwisatz78 (6/26/2012)

---

Hi

I am needing to export some data from a backup into our live DB due to some issues. Currently I am thinking the best thing would be...

It did not work out the way I had hoped:

It is recommended that you start using the new DMV sys.master_files. sys.sysaltfiles was left in the product for backward compatibility only. The recommended replacement is sys.master_files.

Mapping SQL Server 2000 System...

Why setup, then tear down transactional replication just to get a snapshot made? Have you looked into Snapshot Replication?

Regarding your request about RMO, you're asking for help on an uncommon...

True, but I found it does not work in the rest of the pipeline....

Roust_m (6/26/2012)

---

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) + "...

😛 and then I remembered the initial intent...

Try this one:

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

Try it with -Name, like this:

Get-ChildItem -Name -Exclude dbo.sp_MS*

i ve tried merge replication..

i want to know how the log file will be

when subscriber is not connected, Publisher should not try to send the data to the subscriber

how to...

I thought I was in a SQL 2008 Forum when I posted, so I tested on SQL 2008. I noticed I was in a SQL 2005 Forum after I posted....

Mindy Hreczuck (6/25/2012)

---

I have index statistics taken care of by a scripted maintenance plan but I'm going to be setting up a separate plan to take care of updating the...

Yes, you connect to a SQL Server 2008 instance using SQL Server Management Studio 2012.

Have you tried it in your environment and it did not work? Or are you just...

dir is an alias for Get-ChildItem

Get-Alias dir

One of the options for Get-ChildItem is -Exclude which accepts a pattern.

help Get-ChildItem -Detailed

If you devise the repl proc pattern and provide that...

Hi Steve,

I would like to correct a few minor typos in the article before it is published. Given that it has been scheduled for publication can I modify the article...

For what it's worth this PowerShell:

$v = [System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO')

$v.FullName

$s = New-Object ('Microsoft.SqlServer.Management.Smo.Server') ".\SQL2012"

$bkup = $s.Settings.BackupDirectory

$bkup

Yielded this output on my machine:

And yields this T-SQL when pointed...