First off, I know that there are some known memory leak problems in certain circumstances with sql server that may be fixed in sp3 or 4(I have not applied 4...

I bcp out my data into text files, zip them and move them off the server. Then you can delete the data you want knowing that you could restore...

First off, I looked it up and there is a way to script adding a role:

sp_addrole 'Professor'

GO

so to add to db_owner:

sp_addrolemember db_owner, jsmith

GO

Its better not to make everyone owner. ...

db_owner has permission to do anything on a table while the public role has no permissions untill you assign them. You can create a role and assign permission to...

Here is a link to the stored proc that microsoft recommends:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q251004

This is for sql 7 but there is a link to the proc for sql2k. I had...

One thing you can do is run sp_lock while your stored procedure is running. It gives you a time slice which may or may not be beneficial.

Isn't there an issue with bcping passwords? Which master tables should I bring over? What if the databases on the new server will not match those on the...

As I understand it sp_change_users_login is manual, so it would not save me much time over going into each user and granting them access to the db. Sounds like...

The only problem is that I am spanning my database across two drives and I am changing files and filegroup ect( I figure now is a good time to move...

How can I post the showplan as an atatchment(it does not format correctly in this space)? Is that all you need to look at?

There are numerous parameters in that article. Do you know which ones they changed in order to alleviate the problem?

the user can log out of citrix and their sql session is still there. They seem to have begin and end times(in sql) that are about 5 seconds apart....

sql 7 sp3. I think it may have something to do with citrix or a slow server as none of our other clients have this problem.

There is a product called sql programmer that is great. Kind of expensive though.

Here is a review, and where to get it:

http://www.orafaq.com/tools/bmc/sqlprog.htm