from older BOL

Requires USE permission. USE permission is granted by members of the dbo or sysadmin fixed server roles by executing sp_adduser; or by members of the sysadmin fixed server...

from bol:

The minimum permission required is ALTER on table_name. TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed...

I think this working in sql 2005 is part of the confusion.....:D

this is actually if an index in a table contains a computed column....but close enough...

http://support.microsoft.com/kb/902388

this maybe a scheduled job running as a .cmd or .bat....check the servers scheduler as well.....

I've been down the merge replication road....don't go there, at least for the situation you are describing. Requires table changes which is usually not feasible. On a limited...

Is the db a reporting or read only db? Is the db restored on a nightly basis from some other source?....I only mention this because I have seen this...

Kelsey.Thornton (2/14/2008)

---

I was reading the same article, and inferred from the fact that it "is available to CLR clients as the SqlHierarchyId data type" that the CLR data type was...

I think you have to have input parameters. If the function is deterministic it will return a consistent result given the same input parameter(s).......give that a whirl...

🙂

I'm going for mcts in 2005 first, skipping mcdba.

How large is this group? What I've seen is the larger the group, the bigger need for change control, read only permissions, etc. You may be in between...

Not an easy question. One thing that occurs to me is a change control procedure...Maybe something requiring a second sign off before modifying records in the production system. ...

Prep for the 70-431 certification exam with a good book and build a test environment. The cert requirements touch on a bit of everything and is a good overview....

If any of the objects fail to copy over using either the dts wizard or the database migration wizard, you will get see errors in the wizard.

A full backup and restore should work fine for the database, users, stored procs, etc. You can also use the database migration wizard in sql 2005

The DTS packages...