Thanks!

Found it out: http://www.brentozar.com/archive/2013/01/best-practices-table-partitioning-merging-boundary-points/

This is a replicated database with NOT ALL tables...

JeeTee (1/8/2015)

---

I'm not sure I follow. The first example allows you to do just that. You can define any sql you want and still insert it into the temp table...

JeeTee (1/8/2015)

---

if this is to perform cross database maintenance, powershell might be a better option (one which I'm altogether not familiar with). But what I was saying about the temp...

ALZDBA (1/8/2015)

---

What's the goal of your action ?

The use of temp objects is fearsome, because - I assume, you'll be dropping and re-creating the DRI in the process. If that...

JeeTee (1/8/2015)

---

You could use a regular temp table as well, unless you need the temp table to be accessible from other SPIDs, in which case I'd recommend using a persisted...

Arhhhh! I forgot to execute the @s-2 command.

In this case another question: can this be done without using global temp table?

quackhandle1975 (11/20/2014)

---

Hi Robust,

You can create a file group for each monthly partition, so you would need 36 partitions for 3 years. You can setup an automated job that will...

I've also checked the linked server code (below), which had @provider=N'SQLNCLI10' in the definition. I've changed it to @provider=N'SQLNCLI11', same error. Changed it to @provider=N'SQLNCLI12' (sql...

I've also found this in the system event log:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{806835AE-FD04-4870-A1E8-D65535358293}

and APPID

{EE4171E6-C37E-4D04-AF4C-8617BC7D4914}

to...

Grant Fritchey (10/29/2014)

---

It doesn't sound like it's 2014. It sounds like your linked servers and your DTC are not set up correctly. It's also possible it's a security issue. I'd...

I don't, this was just for the test....

Fixed this by adding the code below. Yet this is a bug in SQL 2014.

$path = "A:MyDB\08_SPs $timestamp.sql"

$word = "ALTER "

$replacement = "GO `r`n ALTER "

$text = get-content $path...

Taking the database offline and than back online solved the problem.