Have you closed and reopended QA since you moved master?

You could try http://www.halfpricecomputerbooks.com/ or look at the merchant listings on paypals website http://www.paypal.com/cgi-bin/webscr?cmd=_shop-cat-ext&loc=11720

There is a problem with your IF statement, you need to add BEGIN and END for the IF to work...try this....

Declare @CYCLE as int

select @CYCLE = CYCLE from CC_LOG_CYCLE

if @CYCLE...

I also believe that it would be the transaction being open answer. There does not appear to be any corroborating evidence to prove the listed correct answer is correct.

4Mb

Looks like you are attempting to update the #jeff_combo table before putting any data in it. Try changing the update #jeff_combo to insert #jeff_combo

You could remove BUILTIN\ADMINISTRATORS from the SQL Server logins. Bear in mind that you had better not lose your sa password if you do this.

When you look at the task manager is the majority of the cpu used by SQL? And if so, try running a

SELECT * FROM MASTER..SYSPROCESSES ORDER BY CPU DESC

to get...

Have you been able to establish that the cpu utilization is being taken up by SQL?

Have you tried shelling out to a CMDExec and ftping the file? It's more of a pain, but at least you could log the steps involved to find the problem.

It could just be a timeout error waiting for the reponse from the ftp location. Are there particular times that it fails, and do these coincide with events on the...

When I did this I made a change to the user options so that all connections would be made with ArithAbort on as by default the connections were made with...

In Enterprise MAnager drill down to Database Maintenance Plans and it will show the plans. It also lists the db's afftected for each plan and the plans actions (ie. Backup...

I'd look to increase the cache size on the SAN as well.

Do you mean to select from both, or run a join?

SELECT A.COL1, B.COL2 FROM DB1.DBO.TABLEA A, DB2.DBO.TABLEB B

SELECT A.COL1, B.COL2 FROM DB1.DBO.TABLEA A INNER JOIN DB2.DBO.TABLEB B ON A.COL1 =...