This works to Kill users of a set database, sure you could reconfigure to do table lever:

CREATE PROCEDURE usp_killDBConnections @DBName varchar(50), @withmsg bit=1

AS

SET NOCOUNT ON

DECLARE @spidstr varchar(8000)

DECLARE @ConnKilled smallint

SET @ConnKilled=0

SET...

Agree with Ashish.

Try reconstructing guery to commit more regularly (run in smaller chunks). If possible you may want to consider restarting your instance and then running query straight away (before...

Can you give some mor information?

What does the job do? Whats changed? What user does the job run as? What have you tried so far?

😛

I'm not sure exactly whats involved but i do know that there is a higher level 'auditing' that can be turned on. As it suggests this loggs a lot more...

I second George's comments. Cross server authentication is a mine-field if it isnt set up with the right thinking-hat on in the first place.

Good Luck 🙂

I wouldnt know off-haand how this would be acheived but you would almost certainly need to turn on a higher level of logging.

Is this a frequent problem?

This hould give you all SQL accounts (so no domain or built-in accounts)

And then you will have to write a script to wrap around each account and turn policy either...

Research!

Are you installing this named instance on your existing a/a hardware?

It would be the same as the setps you followed to create you first two clusters (cause what you have...

If you look at at servers databases you will be able to identify the mirrored pairs by the database names.

Mirrored db's have two roles, the Principal (the current active...

I would imagine that it would generally be incompatible.

It depends on your package really. For eg, i use the 2k8 bids and then test my packages on 2k5. I...

forsqlserver (8/10/2010)

---

All the bigger bie's of this forum I am too confused..

When I have heard that MYSQL is also now governed by Oracle...

Is the future secure of mssql DBA's

Currently in...

Jason Shadonix (6/17/2009)

---

Mani Singh (6/17/2009)

---

What are the SQL Server Service accounts (local or domain accounts)

Are the DB compatibility modes same for both the databases.

What is the service pack levels and...

MTY-1082557 (7/30/2010)

---

HI Adam,

Thank you for your comment. Yes I was sarcastic and I apologize for that, I think Steve was nice and clear with his answer after my last...

MTY-1082557 (7/29/2010)

---

Geez! you are really a pain... lol

I just was trying to define one backup from another.. Seems like you are a guy that goes with the book... anyway!, I...