What types of locks are you having? Executes sp_lock. Remember that shared locks (S) occur when a user connects to the database or access a table with a select statement....

Check the script in http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=148

This one import data into sql, check the final line and change the i for I to o for Out like your command.

With many forms. You can make backups on the remote servers and then restore them in your local pc. Or you can set a snapshot distribution. Or script the database...

A trigger would work...but i think that you could create a stored procedure that executes the bcp command and also calculates the info that you need. Then with a...

check my script in :

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=148

this one does it for you, you just specified the table, the sa pass and the file path and it imports all the data.

...

I would suggest to create a job with more features

Try sp_who or sp_who2. In adittion, you can use sp_lock

You can let the db to growth automatically in the db options, but always check for disk space. It is not recomended for production databases.

Check that osql -d is used to specify the database, maybe when you execute the cmdshell, osql stands on master database. If so, specify the db with the -d option,...

We have a similar problem a long time a go, but it was related to the mail profile. Do you have a problem with that?

Can you check the properties with sp_configure with ISQLW

1)If you detach the db, you remove the info records in sysdatabases from the master database. You still have the data files but it does'n exists anymore in SQL Server.

2)Later...

Tell those programmers to develop an app to execute your sp and. Are you handling security?

Also check for one of my scripts posted some weeks ago. You can see all the triggers, and the state in wich they are. Also you can enable or disable...

What you can do is create the database in sql server as you want. Then script the database though EM, with all the objects in it and save it to...