I have been searching for a solution.

It appears to be a bug that is not fixable.

http://dba.stackexchange.com/questions/124655/are-unfixable-spatial-index-corruptions-considered-normal

Any ideas?

A developer created a spatial index and after it was created the error occurred on the DBCC Command.

I run the following command and it display the table and the extended index name:

SELECT

OBJECT_NAME(PARENT_OBJECT_ID) AS table_object,

name,

create_date

FROM...

How do I get the parent Object?

The following gives me the name of the Index:

select OBJECT_NAME(1239532045)

It returns:

extended_index_1682469418_384000

I was trying to determine what the command would be since I do not think I have the actual index name?

I saw that link that you provided.

Thanks.

They need to be able to create Jobs.

I tried assigning Fixed Database Rolls but that did not work.

I know this is an old post but I have to Grant an individual permission to manage SQL Server Jobs.

That is Create, Modify Drop, etc.

Do I need to create a...

ok, that was simple.

Thank you.

RESTORE DATABASE PrismDataBillingTest

FROM DISK = 'G:\MSSQL11.MSSQLSERVER\MSSQL\Backup\PrismData\PrismData_backup_2016_06_26_130000_9108635.bak'

WITH REPLACE,

MOVE 'PrismData_Data' TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_Data.mdf',

MOVE' PrismData_FG2_0' TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBilling_Indices_0.ndf',

MOVE 'PrismData_FG2_1' TO' D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_Indices_0.ndf',

MOVE 'PrismData_FG1_0' TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_FG1_0.ndf',

MOVE 'PrismData_FG1_1' TO 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismData_FG1_1.ndf',

MOVE 'PrismData_Log' TO 'F:\MSSQL11.MSSQLSERVER\MSSQL\DATA\PrismDataBillingTest_Log.ldf'

Msg 3234, Level 16, State 2,...

ThomasRushton (7/1/2016)

---

You've got a big WITH clause in your RESTORE statement which contains lots of options to move files around. Just add...

ok, thanks I'm not feeling that well. I thought you might be aqble to help me out.

Have a nice day.

John Mitchell-245523 (7/1/2016)

---

You're attempting to restore PrismDataBillingTest from a backup of a database with a different name. Use RESTORE HEADERONLY to find out what database(s) are in your backup...

ok, I'm tired could you please help me with the...

John Mitchell-245523 (7/1/2016)

---

You're attempting to restore PrismDataBillingTest from a backup of a database with a different name. Use RESTORE HEADERONLY to find out what database(s) are in your backup...

Thanks John could you kindly provide me with the syntax?