Excellent information Thanks SSCrazy

Dom

Hello,

I know it is an old post but any updates on this issue?

I have SQL MP 6.4.1 and the alerts are flooding if the rules/monitors are enabled...

Thanks,

DOm

To defrag is it always a manual process for safety reason or other or could we automate the process?

Hello,

Thanks to Rick...

Solution

The following are two sets of instructions to try. This gets to be VERY picky so please watch all of the details. For example,...

Hello,

The problem is that I don't have access to Microsoft SQL Server Management Studio as when it tries to connect I am getting the error:

TITLE: Connect to Server

------------------------------

Cannot connect to...

Let me try

Thanks

Dom

Hello,

I found the same field called twice by different queries because they were wrongly created:

EXEC sp_addviewdef N'Workitem_only_view', N'workitem.floor AS workitem_floor', N''

GO

EXEC sp_addviewdef N'Workitem_only_view', N'workitem.floor AS workitem_room', N''

GO

I think it is...

Hello,

I was able to locate the dependencies with this query, but how to delete / drop these links?

Thanks

Hello,

I am getting the same error. Please could you give me more details about your resolution...

Thanks,

let me try

Thanks

the service was really excellenmt and I hope it will continue as the discussion and articles were really helpful and detailed.

I hope the offer from Red gates was good and...

I tried this but it does not work... any ideas?

exec sp_attach_single_file_db N'MyxxDb' , N'E:\SQLServerData\MSSQL\Data\xx_Data.MDF'

I got the error and the log file is not created...

I tried also:

EXEC sp_attach_single_file_db @dbname = N'Altiris',

  ...