Cath Trimble (10/7/2008)

---

Hi,

Did you copy and paste Miguel's query? If so there's a typo - it should be sp_change_users_login 'Report' the 'c' was missing from 'change'. ...

When you run the stored proc on one of the DBs, what's the output you are getting?

Steve Jones - Editor (10/6/2008)

---

I don't agree with companies scraping this information, though I'm not sure they're wrong, either in the moral or legal sense. You put it out there...

Richard Gardner (10/6/2008)

---

Seeing as you wanted a debate I'll disagree with you.

When building a data architecture you have to consider the front end, the bouncers, as you call them.

You need...

I strongly dissagree here -maybe because I am taking this quote slightly out of context, but I still like a healthy debate:

Those of us that work with data tend to...

You should be able to work this out with a little cursor (yack!) to execute and dump results for every DB on the server. Use this system stored proc like...

Run the following on each DB you restored on your test server:

sp_change_users_login 'report'

Any rows coming back are orphaned users you have on those DBs. If the users coming back are...

Mike Levan (6/10/2008)

---

is there a way to split the transactions and execute like ,deleting 5k rows each time. so that it has small log file and can easily get rid...

Mike Levan (6/10/2008)

---

may be there are relationships between tables and so they are droping indexes so that it allows them to delete blank records.

Actually its an old system running which...

Start looking at the statements that cause blocking. This is a handy script I've used in some ocassions -since tracing was not an option.

SET NOCOUNT OFF

DECLARE @blk_spid as int

DECLARE @blk_sqlhandle...

Thanks Jack! Well, the solution turned out to be quite simple -though probably not optimal.

Like you said, I can EXEC a stored procedure remotely via a linked server -just make...

Similar situation here....any references outside of Quest's knowledgebase -which I can't login to, since I don't know who within the company registered Litespeed?

Jeff Moden (3/5/2008)

---

And, no... I'm not making fun of anyone who uses DTS... if you take it that way, then I apologize. I'm just saying I've always been...

Definitely an ingenious solution; however, it can quickly become a poor approach when having to deal with larger import file -think telephone call records for instance.

I've found that the best...

Adam, the problem was that I was referencing fields by using [remoteserver].[db].[owner].

.[field] and MSSQL wasn't liking it. All I had to do was alias the [remoteserver].[db].[owner] as [aliasname].

In other words,...