dan-572483 (11/26/2012)

---

To remove clustered SQL instance, you can launch the SQL installation Wizard, Select Maintance and then "Remove node from a SQL Server failover cluster." Start on the...

[/quote]

my recommendation would be definitely back and restore, instead of detach/reattach; especially when migrating to a new server, for example if the sector size on the new server is 4096,and...

Hi

Thanks for your prompt response , considering it is the same size is there any other inconvenience regards attach vs restore

Yes I will be considering all the rest you mentioned

Thanks for your responses,

I sent the script so you can confirm if the valid option to avoid this error is declared the cursor insensitve

Thanks

Hi This is the script, Thanks

ALTER procedure [dbo].[LMCDBATmp_Rebuild_Indexes]

AS

BEGIN

SET NOCOUNT ON;

DECLARE @objectid int;

DECLARE @indexid int;

DECLARE @partitioncount bigint;

DECLARE @schemaname sysname;

DECLARE @objectname sysname;

DECLARE @indexname sysname;

DECLARE @partitionnum bigint;

DECLARE @partitions bigint;

DECLARE @frag float;

DECLARE @command varchar(8000);

--DECLARE...

Thanks, where can I find like best practices for SSAS?

Thanks

Thanks for your answers I totally agree,

Web server uninstalled

Thanks for the article very helpful , based on your experience what do you recommend for 2 nodes active\active , 2 sql server instances

Thanks

APA

Hi I did what you recommended but on the management studio is returning me results but the bcp it creates the file but 0 rows copied below the script that...

Thanks very helpful

🙂

The Database is too big to implement this option,

Do you know how can I do this through PowerShell using SMO:

I started something like this but I don't know how to...

Thanks,

So I just need one MSDTC on the Active\Active cluster?

On which cases would I need two MSDTC?

Thanks again

GilaMonster (4/29/2012)

---

Let's take a step back for a moment.

The grant statement that you ran grants execute rights to all functions and stored procedures in the database, that's all it does....

Perry,

I finally found the article Part 3, this is wonderful, I just have question can I have multiple default sql instances on a SQL cluster? Or just one default instance

Thanks...

Perry Whittle (4/18/2012)

---

You can do it either way. If you pre create all your...