When I try to restore the msdb db, it says exclusive access could not be obtained bcoz db is in use.

When I try to restore the master db, it says...

Should the logins be transferred before or after the restoration of system and user dbs.

Regards,

Sushant

Try by deleting it and again creating it.

Lowell (5/5/2011)

---

change it again. if you typed in the password in a config file, it's in clear text in that file and a security risk of the highest order.

create...

.

Cant you modify it from the maint plan also?

Regards,

Sushant

I founded out the application whcih was trying to connect every minute.

I went into its (application) database connection settings and updated the 'sa' password and everything seems to be fixed...

SQLRNNR (5/4/2011)

---

Track down the ip address from that log table you just created and find out what application resides there. An application is using .Net 3.5 to connect to...

select * from T_DBA_FailedConnectionTracker

order by tsRegistration desc

I get :-

<ApplicationName>.Net SqlClient...

Ok

i drop the event notification:-

DROP EVENT NOTIFICATION N_Failed_Login_Notification ON SERVER

Regards,

Sushant

and the created table T_DBA_FailedConnectionTracker is empty

Regards,

Sushant

I get this wehn i run tht script after craeating new db :--

Table [T_DBA_FailedConnectionTracker] Created

trustworthy switched to ON

Msg 2714, Level 16, State 21, Line 2

There is already an object named...

ALZDBA (5/4/2011)

---

Maybe this can help out.

Failedconnectiontracker is using sqlserver event notifications to capture all login info.

We have a dba database on every sqlserver instance to host all sysadmin/dba systems stuff.

In...

Phil Parkin (5/4/2011)

---

SKYBVI (5/4/2011)

---

Koen Verbeeck (5/4/2011)

---

So you have data in one table, you want to manipulate it with TSQL and put the results in another table.

I would use an Execute...

Error says Client :...