Do you mean place the database files on shared drives on other servers? You can add the trace flag 1807 in the start up parameter. This is supported in  2000...

If SQLAgent service was not running, the jobs cannot be ran. There must be some applications start the SPs.

Check the plan history when the plan was running, and start profiler to trace...

Got your point. Sounds like a bug. Right now I don't have an upgraded server so I cannot confirm it.

One simple solution is to create indexes on your view. So the view will be materialized (a physical copy of data). SQL server still maintains the data in the view...

The password of the login you created does not meet your windows security policy (e.g. the length of password, etc). If you want to ignore the policy for the login,...

compatibility level is set for individual database, not for the server. Are you sure you are working on and checking the same database? From your smo code, you are checking...

Check your password is expired or not. If password expired, you will get the reported error. If not, check the following links.

http://www.sqlservercentral.com/columnists/cmiller/cannotgeneratesspicontext.asp

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=32&messageid=10251

Did you get this error every time when you started a distributed transaction, or just occasinally?

There is a ms kb article http://support.microsoft.com/?kbid=307802 for sql 2000. Not sure it's helpful or...

When you upgrade or restore a 2000 database to 2005, the dblevel is unchanged (80). You need to manually change to 90 if you want to use 2005 features.

Just check BOL. ANSI_NULLS setting is not for this purpose. It controls the result when a column/value comapres to NULL.

The SQL-92 standard requires that an equals (=) or not equal...

Does the SP have dynamic TSQL code? Dynamic TSQL breaks owner chain and need to grant priviledge explicitly.

First of all, are you sure this is an security issue? run sql...

1)

get all clustered index, including the clustered index defined by PK and Unique constraint:

select b.name as tablename,a.* FROM sysindexes a, sysobjects b where a.id=b.id and b.xtype='U' and a.indid=1

Clustered...

I don't know how to do it by DMO. One solution to your problem is that you can deny the login permission to all the windows accounts.

sp_denylogin @LoginName='Windows NT user...

Check whether the EXEC privilege on the SP is denied for the user.

it's a catalog view under Views-->System Views under each database.