Deleting tables will not change the size of the data files. Once you make the delete you will have to shrink the database to reclaim the space the tables...

Actually, I had to restart (forced shutdown) the box the server was on because it stopped responding because it could not find drive K:. I will do a clean...

You cannot backup specific objects within a database with SQL Server native tools. You will have to get a third party tool to do this.

Thanks Glenn

I have had to add an additional file to the tempdb database. I created the file on another disk with more room. When the data modification was over...

Brian,

Thanks for the help!

Lee

I am not concerned about the network services people that much. I just need to be able to say this is what I have in place to restrict unauthorized...

So if I remove sysadmin rights from the DBA user’s windows accounts and create SQL logins with sysadmin rights that should help prevent network services from having full access.

I am...

The vendor may have created the database with a large initial size to give the database enough room to grow. For example: I could set the initial size of...

You could open Access and create an ODBC link to the SQL 2005 table. You now have access to both tables in Access. Create a new query in...

You could create an SSIS package that copies database objects then create a job that runs the package. The users can either run the job or you could create...

Can you check to see if the job is failing because your servers resources (memory, disk or CPU) are maxing out. I found with intermittent problems it is usually...

When you setup the Mail Account you did not specify a server name in the Outgoing mail server section.

Have you considered Sanpshot Replication?

You have to configure Database Mail in management studio. It is listed under the Management folder.

Once configured you can use the sp_send_dbmail stored procedure to send email.

See books online...