Who knows?

Forgot to ask:

Are you on SQL Server 2000?

Send me a private message with you email address, so I can send you a html help file which describes the system tables.

The table map is a poster that...

Hey biker,

your avatar is also kinda cool! Although I prefer a Fireblade

Now, for the pseudo topic relation:

I think Andy Warren mentioned some time...

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part3/c1161.asp should cover most of your questions

IIRC, when you edit and save it will become a user procedure again

I would definitely redesign your application.

Would that make sense?

I can understand when someone uses this approach (local dbs' that get uploaded during off-peak hours) when you were using Access, but with SQL Server I would...

From BOL

When xp_cmdshell is invoked by a user who is a member of the sysadmin fixed server role, xp_cmdshell will be executed under the security context in which the SQL...

Any reasons why you're doing this at the server and not at the client?

TSEQUAL is not totally undocumented.

Although BOL lacks an explanation of use to use this function, you can find it in the list of reserved keywords for SQL Server.

Not sure if I understand you.

Can you post your code?

Hey, if it fails we could blame David

I had actually only the reference to the original thread in the old forum, and was...

Yes, take a look at the undocumented sp_MS_marksystemobject

 in your master db.

I was not sure if it works, but here is the complete thread http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=18764