If you are looking "Process info" it is total connections (active and inactive) to sql server.

You may see >1000 connections also if your system is highly active OLTP server.

It all...

How often you run the tlog backup?

If your recovery model is full/bulk_logged, log will not be truncated unless you run the tlog backup.

If the db is configured for transactional replication, log...

Is this database restore from some other server?

Might be SID missmatch problem.

check the sysusers table in that database, if the row exists you can delete the row and set the dbo...

Are you installing named instance if yes, you have to create the alias...

And also check the following webcasts...

Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering  

I will agree with Steve why do you need all columns from both table? As Salim mentioned 19 GB data is nothing these days...

Check the estimated query plan?

What are you trying to...

Get the directory listing using xp_cmdshell into temp table and delete the files what ever you need..

I should use DOS based ftp commands to get the directory listing and deleting...

http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/1eddb33e5e116759/cab63c1c579ea15b?lnk=st&q=sp_setapprole+password+encrypt+SqlClient+&rnum=1&hl=en#cab63c1c579ea15b

What is the error you are getting when you are running 4 part name query?

Check why it requires SA login, are they using any specific functionality which requires SA access...

I don't think you can anything if you grant SA access other than auding the...

Create Table Test

( Col1 int, rowguid uniqueidentifier  default newid() not null

Only merge replication and transactional replication with immediate updating subscribers will have rowguid not all replicated tables...

Looks like db was not detached properly, if you have the previous backup restore it ro you can Try attaching through QA using sp_attach_db or sp_attach_db_single_file...

Create a new table... populate the data and rename the tables...

EM also using the same method...

It simple syscolumns.colorder column update but I don't advise you to update the system tables...

Becareful if want to disable the auto update stats...some times it effects performance too...

When it is disabled make sure you update stats manually when you load the lot of data...

Run the queries in QA after enabling executon plan,SET STATISTIC I/O and see the plan where you need indexes and which are being used...

Tempdb is RAM is not supported and...