I would recommend you to repair the .NET Framework in add remove programs and also apply the latest service pack for SQL Server (If SQL 2005 then install SP4) and...

Hi

please try to use sp_changeobjectowner and see whether it works.

If possible could you please share the db script with all objects so that i can try it at my...

Hi

I understand the requirement is to avoid fragmentation , but lets takeit step by step.

Error

====

Failed: (-1073548784) Executing the query "ALTER INDEX [IX_asstaging_1] ON [dbo].[asstaging] REORGANIZE WITH ( LOB_COMPACTION...

SYS.CONFIGURATIONS Derive information from mssqlsystemresourcedatabase which is a hidden system databaase.

while we execute the code "select * from sys.configuration" sql server would fetch the data from this database.

Hi here is the BOL Extracted content which answers your question.

<>

How to: Configure a User to Create and Manage SQL Server Agent Jobs (SQL Server Management Studio)

To configure a...