Thanks for reply me..

Script name : MONITOR_LOCKS, this is working fine in stand alone server and getting email alert when process being blocked with SPID.

How can I monitor process...

Thank you Gila for your reply, I got it clear myside about how density as defined.

In SQL SERVER By default auto update enabled in this database, why agian create another...

I have tired below query, but it is not hope

msaccess Table name - NIR_INPUT

oracle table name - LIMS_NIR_RESULT

UPDATE NIR_INPUT T1 SET T1.SAMPLE = (SELECT T2.SAMPLE

FROM LIMS_NIR_RESULT T2...

Thank you Edogg, For your reply.

As per your reply, I got the point how datafile has grown 450MB in optimization jobs.

Can you clear me doubts.

1. If change the setting in...

resolved issues, after applied SP4.

😀

And more refer this link: http://support.microsoft.com/kb/322140

I have checked all cause, everything is correct

I found one error in sql agent error like

[364] The Messenger service has not been started -...

Thanks steve Jones for reply..

I am using SQL server 2000 version and sp3.

I could not found any error in event logs regds sql agent services.

resolved issues, to change the database owner

thanks

Hi Jeff Moden Thanks for your reply ..

One of my client installed this software and configured database, this is totaly web based application, once installed this s/w still...

Jeff Moden Thanks for your reply ..

It is a good script. For find out unused spaces for all tables.

I could executed this script, but i am getting afried on my...

As a datacenter part, we want know who was last login the sq server 2005? and we need to execute the script once in a week. If you provide the...

thanks for your reply..

I could tried the query as follows

select b.name as DBName,a.login_time,a.last_batch,a.hostname,a.program_name,a.hostprocess,

a.nt_domain,a.nt_username,a.net_address,a.net_library,a.loginame

from sysprocesses a, sysdatabases b where a.dbid=b.dbid order by a.last_batch desc

It was written the Info from only...

Thanks for yours reply...

Windows authentication worked for me.

I added my domain user in sql server login, and then given sysadmin permission, so now i can able to access...

I resolved the issues with help of below URL

http://support.microsoft.com/kb/827422

Sql server agent could not running on under windows account, after delete or deny builtin\administrators from sql server 2000.

How to resolve this issues?

thanks