We use a similar script and recently partitiond a database. Now I receive a syntaxerror on this statement:

ALTER INDEX [MUTA_PI3]

ON [prd_00rpd_hrm].[hrm].[MUTA]

REBUILD

WITH

(ONLINE = ON,

FILLFACTOR = 90,...

If you're already setting up a separate server, why not use MOM?

I've looked into that and cannot find a rule to monitor failed jobs. If I have to build this...

I'm trying to get a question answered and have not found the complete answer; consider the following:

I create ba new database, NewDB with a table, NewTable. I create a new...

You probly want a PIVOT table; lookup PIVOT in BOL.

If it is for just 2 of the fields I can do it like this:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Table_3](

[Username]...

Then I cannot help you...

Maybe this explanation will help: http://www.mssqltips.com/tip.asp?tip=1202

Check 2 settings:

Server: nested triggers

Database: recursive triggers.

Read BOL on these subjects, if you wish to know about this, or check this: http://msdn.microsoft.com/en-us/library/aa175801.aspx

Have a look here: http://www.mssqltips.com/tip.asp?tip=1220

Your question is too vague, I think. Do you mean failover clustering to keep your data available when something breaks? Or do you mean clustering for loadbalancing, so the responsetime...

Maybe I'm not an expert, but I am unsure what it is you wish to accomplish. I do not want a block of code, just the bussiness logic. As I...

He said something about not using ALTER...:-P

Hi J,

It's far from clear to me what you mean: when you talk about 'duplicates', do you talk about records in the 2 tables? Or do you mean the values...

Hi Mahesh,

To start with the PUBLIC-role: you have is spot on. Any autorization to PUBLIC is for every login, since PUBLIC is a role every Login has.

A db_owner for 1...

8kb,

I think Grant has the right ideas. I wish to comment on something you wrote:

...and I think our design team will have a problem with that.

I believe your design...

Dunno if this helps you on the way:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[#Table_1](

[F1] [nchar](2) NULL,

[F2] [nchar](2) NULL,

[F3] [int] NOT NULL

) ON [PRIMARY]

GO

INSERT INTO #Table_1 VALUES('A','B',1)

INSERT INTO #Table_1 VALUES(null,'B',2)

INSERT INTO...