SQLAgent service stoped automatically.

Can you post what is SP level is updated on you SQL 2008 box?

I have also same problem in SQL 2000 with SP3 due to dll files...

As you suggested me stop these two services after that install SP3, but it is not successed, same error occur.

During installation I choosed sa user ( for sql authentication), database...

Thanks for yours reply..

Is it possible direct depoly SP3 on sqlserver workgroup edition?

rgds

ananda

Hi,

I am not comfortable as SQLDBA just new SQLDBA. As per my experience, I had understand and configured day to day activity in production SQL server as below

1.Verify...

Hi

As per above URL, it is described DBCC cleantable command, It was worked whenever removed variable from table, this variable space only recliamed with dbcc cleantable command. so it...

Hi Bhuvnesh thanks for reply, could you tell me how much Threshold precentage to be set in value column for those counter names.

regds

ananda

There is no hope for openrowset command?

Target server port 1433 is open in local, but remote server connection is not open - telnet target IP 1433, I have checked there...

Adi Cohn-120898, thanks for your reply, and this is very userful information, so Micosoft's exten the support to the customer which are using sql server 2000 with SP4 only ....

Hi Perry Whittle thanks for your reply.. error like as below

An error has occured whil establishing a connection to the server. When connecting to SQL Server 2008, this failure may...

Mr.Perry Whittle said correct.

when I am using sp_help_revlogin sql 2000 then after exec this script in

SQL 2008 DB all Login were automatically maped with particulare database, which was already...

Perry Whittle, Thanks for your reply, I should take care further upgradation of login transfer.

Regards

Ananda

I got the result with your valuable help.

The following two SPs download and exc the test server,

1. 'sp_hexadecimal'

2. sp_help_revlogin

output as blow, after that Exec in SQL 2008 box, it...

Thanks for your reply..

In step 3.

I don't know transfer user before restored. I done just restored from SQL 2000 version database.

Apllication is does not connected, because existing login name not...

I ran one batch file for status of SQL ports, it showing all the ports service has not been started, But all sql services were started, I could not get...

Hi Vidya thanks for your reply.....