There is nothing particularly unusual with the numbers you are seeing, especially if SQL Server is the only application running on the server.

SQL will not release memory unless there is...

Try running the SQL Server Network Utility. Check whether TCP/IP is enabled

The duplicates you are seeing are probably threads for a SPID. This is quite normal and is probably not the cause of your problem.

Have you tried to connect to this instance using the local administrator account ?

And, have you tried using the old DBA's windows account ?

Can you login to the server as a local administrator (not a domain administrator) ?

Do you know the password for the sa login ?

By default, members of the local administrators group for the server get admin access to SQL Server through the SQL Server "login" called "BUILTIN\Administrators". Does this login exist on...

I tend to agree with Kumar. The authors do not demonstrate a good understanding of clustering or log shipping. If you are not familiar with the MS options,...

have a look at http://support.microsoft.com/default.aspx?scid=kb;en-us;842425

The indexes on the rowguid columns are created because this is what merge replication uses to select data out of these tables. If the indexes are dropped, the system...

They should be on separate disks so that there is no contention for I/O.

To move them, you can either

- detact the database, move the files as desired...

This looks like you do not have a sheet called "Markets" in the workbook Markets.xls. Your Select statement works fine for me.

I think the answer is that the name of the sheet used in the Select statement needs to end with $. In the workbook itself, the name of the...

Does the file contain a sheet called "Markets".

The table in the select statement 'SELECT * FROM Markets' needs to match a sheet in the workbook.

Does the file exist in C:\MarketsImport on the server ?

The query is run on the SQL box so the file must be on that server.

Alternatively, you could create...

SQL Server will not have any issues with you renaming these "things" using sp_rename.