It seems the data for your query/sp was not in memory when you noticed it runs longer. In order to confirm it, try to free the data buffer using DBCC...

Frank, How are you?

I think the Identities definitions is kept in syscolumns table in user database with status = 0x80.

sp_help yourtable name will show all information you need.

You may create the encrypted SPs in a dataabse, send the database to your client and let them to import SPs into their database.

It just a thought and never test...

SQL Server 2005 is able to handle your request. It is not released yet.

Not I am aware of it.

You can create windows group, add new logins into the group and grant the group to access SQL Server. In this way, you really don't...

Try uninstall and reinstall.

It sounds like a security/permission issue. Did you have any error messages?

Check Microsoft KB 269074 for How to Run a DTS Package as a Scheduled Job

Can you post the error message you receiced when trying to connect to the SQL Server with named pipe?

Did you try to connect MSDE, Named instance or virtual SQL Server...

How do you define whether your table is not updated in your situation? Maybe you can show some examples?

OS administrates system resources and assign the resources to applications like SQL Server which uses and manages the resources assigned to it by OS.

Windows System Resource Manager (WSRM) is available for...

I believe we have already answered your question at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=177197#bm177278

1. Try to shut down your application/applications services.

2. Run sp_who2 to see if there are any connections to your database.

3. If some of connections are still there, run "kill yourspid"...

Which version of SQL Server are you running? I believe everyone here assumes you are running SQL Server 2000.

Revoke "exec" permission from public role and grant it only to some individuals.

The last statment from your jobs will be the sp that is still running.

Be remember that users can only see SPIDs they own if they are not 'sa'.