uSe my second last post's query

Something new to me :unsure:

STRANGE :w00t::w00t: , On production , you dont have MSDB backup.

take MSDB backup and

run the below script

USE [master]

GO

ALTER DATABASE [msdb] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

GO

ALTER DATABASE [msdb] SET SINGLE_USER

GO

DBCC CHECKDB (msdb, REPAIR_ALLOW_DATA_LOSS)

GO

ALTER...

or in safer side , you can restore recent MSDB backup

mirravi (8/18/2010)

---

hi,

When i run DBCC CHECKDB onto MSDB , the follwing error ocuured.

Msg 8967, Level 16, State 216, Line 1

An internal error occurred in DBCC that prevented further processing. Contact...

mirravi (8/18/2010)

---

Thanks For your reply.

i ran the query, it displys an error, but done the back up successfully.

Processed 325512 pages for database 'PGCENTURION', file 'SBOEdenvaleIntegration_RSA' on file 1.

Processed 41 pages...

Anamika (8/17/2010)

---

Hi all,

Thanks for the inputs.

I've checked in 2005. the Script Procedure --> Create gives the correct modified SP name. But while creating from the mentioned script it...

Anamika (8/18/2010)

---

Hi,

SELECT * FROM SYSOBJECTS WHERE XTYPE = 'P'

output of this query gives the new SP name.

My problem is while getting the create script for the same gets created in...

Anamika (8/17/2010)

---

Hi all,

Thanks for the inputs.

I've checked in 2005. the Script Procedure --> Create gives the correct modified SP name. But while creating from the mentioned script it...

Compression in Sql 2005 ??

what was the size of...

try to use ROWNUMBER() function , it will give you more flexibilty

BUt why do you require this ?

GilaMonster (8/17/2010)

---

Yes it is.

If you need to do something on insert/update/delete, I recommend triggers. That DMV is just to give info on how...