Paul White NZ (4/2/2010)

---

One simple approach is to script...

First of all, without posting other information like table definition/query, you made your post a bit complicated

so better to put this info to get result/response faster (Refer the link...

This query only give one value for table_id irrespective of no of rows afftected in main table by inset/update

see this code to get this...

Can you post the result of query you posted above SELECT

db_name(database_id),object_id, index_id, record_count, avg_fragmentation_in_percent

FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, 'detailed')

WHERE index_id > 0 and index_level = 0 and avg_fragmentation_in_percent...

First of all NEVER directly patch PROD server. Always do testing on lower regions like testing or staging.

Document the steps to follow, issues encountered and their resolution.

See the attached...

Refer this :

Restore Process

To restore the database you can either do this from a query window or from the SQL Server management tools.

These are the commands to restore the...

Paul, Great article:-)

Refer this link http://www.microsoft.com/systemcenter/en/us/operations-manager/om-overview.aspx and attached doc

Is it from any Stored proc ? if NO then i think u can incorporate this...

post tables defintions

From my previous post fetch data into permanant table DBRolePermissions from @DBRolePermissions

and then use SELECT Principal_Name,

CASE WHEN [CONNECT] IS NULL THEN 0 ELSE 1 END [CONNECT],

CASE...

Sasidhar Pulivarthi (3/31/2010)

---

DBNAme UserName dbo dbREad dbWrite............

MDEL sa yes yes...

Sasidhar Pulivarthi (3/31/2010)

---

DBobject UserName Read Write Execute

tbl1 tst1 Y ...

i think roust_m made it Uninstallable = 1. then did the uninstallation.

Seems like unmatured post . give more details