Hands down... a pdf fan!

if you have tried all and still unable to release the space and you absultuly need to ... go this route

1*- On the shrink file chose your File Tyep...

*- is the agent have its own service account?

*- any service packs / windows updates were applied

*- could you paste the errors recorded in the error log. (Default location Program...

We have already implemented that is running with no issue. We chose beefy boxes as part of our consolidation project.

4 node cluster (3 with 08r2 and 1 with 2012)...

[/quote]

They want you to break mirroring while they move the storage?

YES

What are they moving, just the mirror instances storage or the principal too?

THEY ARE MOVING JUST THE...

Thank you jay & muthyala_51. I had not even thought about about and would not have thought about the dependencies!

They work like a charm!

I have added a snapshot showing how the columns look once the Indexed view is created.

Thank you for the response Andrew.

There is no luck with indexed view replication. In order to have this working we went a different route.

* We did straight Table...

Set Nocount on

Declare db Cursor For

Select name from master.dbo.sysdatabases where dbid>=11 --Doesnt include system dbs

Declare @dbname varchar(60)

Declare @execmd nvarchar(150)

Open db

Fetch Next from db into @dbname

While @@Fetch_status=0

begin

if @dbname...

thanks. it makes more sense now. 🙂

reason not using identity is because the id's can be repeated but will be differentiated by languagetype.

will try. thanks

Thank you all. will try it out.

thanks