DBCC execution completed. If DBCC printed error messages, contact your system administrator.

PAGE: (1:783)

BUFFER:

BUF @0x00000002D8FE3800

bpage = 0x00000002D88E0000 bhash = 0x0000000000000000 ...

The database name is:

[User Profile Service Application_SocialDB_33fb0eab4eb54100a62a3bc4a1ca8191]

DBCC CHECKDB;

GO

Result:

There are 821 rows in 9 pages for object "sys.sysrscols".

DBCC results for 'sys.sysrowsets'.

There are 127 rows in 2 pages for object "sys.sysrowsets".

DBCC results for 'sys.sysallocunits'.

There are 140 rows in...

Yes, I am still getting errors, even after CheckDB.

Hi Gail

CHECKDB shows no errors. In application log I have following errors:

Attempt to fetch logical page (1:783) in database 27 failed. It belongs to allocation unit 72057595611578368 not to 72057595613675520.

Andy,

Thank you for the great post. This tutorial helped me a lot. I think your delete script is deleting from the source table instead of the destination table. The script...

Using event notification for logon auditing, I am getting multiple records for the same event. Is there a way to limit to a single record per event. For event type...

Thank you everyone for your support.

I solved the problem using a different variable to save the name into and use that variable in second File System task to delete the...