Yes from each of the DB server i can connect to DB server

I have SQL Server (only) and the server configuration is win 2003 64 bit, 3.90 GHz Intel Xeon @ 2.66 GHz 15 GB RAM.

I have set my Memory settings in...

Even after adding all the necessary counters, it is not getting logged. where as the same thing if i do add the counters for SQL Server 2008 it is getting...

Thanks for the inputs.

With Regards

Dakshina Murthy

Okay thanks a lot

With Regards

Dakshina Murthy

Thanks for the quick response.

Sure we will install 64 Bit SQL, but wanted to know will there be any major impact in serving the requests from the application side. Because...

Thanks for the info

Yes exactly

Thanks for the Quick Response.

It worked for us Successfully.

Again i need one more clarification, assuming that i used the command STOPAT and then if i have iterate the timings (STOPAT)...

Will you please let me know how this can be acheived. Please..

I would trace it with Profiler to see if some error is raised from SQL Server (and possibly ignored by the application).

Have you tried that?

I have traced with profiler its...

Yes its the same user, which i use in application with the SSMS. it doesnt throw any error while profiling the same and execute in SSMS.

sa login is not having sysadmin rights, checked with it. i am getting the below issue.

i am not able give permission to msdb as well.

The EXECUTE permission was denied on...

I tried with sa and a normal login which has all DML operations and Exec permission, but it is not having sysadmin rights.

i am also not able to grant bulkadmin...

Yes, i agree. Normally we do that, but i dint notice that it was not there. Thanks for all your help.