please can u check with application team ,how many user connection they have mention in application.

if that exceed problem will arise.

or u can used below query for no connections on...

hi you can check using following way.

please logon into sql using datareader login

then exec sp_helprotect

it will give no object accessible to him.

hey you can use sql profiler for this.

then u will come to know that which thread taking more time to execute.

after that check with developer and do needful changes.

hi mahesh,

This error occurs when someone has run a process that has broken the log chain. Probably ran the command BACKUP LOG [Jul_Reports] WITH TRUNCATE_ONLY, or the database was switched...

hi ,

you can used copy_only option to take full backup. when transaction log backup job created for same database .

bcoz it will not break lsn squence of database .

Hi ,if you want to monitor sql server activity you

can sql server heartbeat

if you having sql server mgmt studio 2008,

you can registered no of instance using central server mgmt .

once registration done u can directly execute query on multiple instance.

PFA.

C:\Documents and...

hi,

you can create bat file which will send mail to you whenever sql server agent service get stopped.

go to run-->services.msc-->sql server agent service -->property-->recovery option

---->run program

please check any sql system background process is running with high CPU

like CHECKPOINT , LAZY WRITER ,RESOURCE MONITOR

you can start sql service using low priviledge user ,

also you can remove rights of user which having access on sql server installation folder

check cmdshell is not enable.

you can also use, in case u want give dbowner role

use database name

sp_changedbowner 'login name'

login auditing can be done easily using below option.

Failed logins

Successful logins

Both failed and successful logins

which write to error log .

but if you select successful logins and Both failed and successful...

can plz tell , how will u change sid of particular login

hi,

you can use sql server administration wizard this is new feature

right click on sql server agent you will get multi server administration wizard,

select master server (where you can...

hi ,

you can use whatup gold ,

please check below link

http://www.whatsupgold.com/