use the "execute as login = " command and impersonate the login that you have issues with, see if you can work out what it is complaining about.

Something I didnt know, thanks for that Markus...

LOL, headphones should be part of the standard DBA kit.

I would be lost without my iphone, job is stressful enough without having to listen to background noise, like management or...

Yeah welcome back.

Just wanted to say Happy Thanksgiving to all...

Got to admit, interesting advice here, mixture of mis-informed advice and loads of good advice from senior members.

I would take Gails advice and think very carefully about your existing setup...

Do you see anything in the sql logs, and is there anything else running at this time.

What does the stored procedure do, and has anything changed recently, regarding accounts or...

Jeff is just pointing out the obvious, better resources can be found by googling and quicker.

I wouldnt say it was that challenging or anything special, but I fixed a permissioning issue that came close to losing a 400 million $ trade. Also lost all the...

Depends on what you need to know, can you give more details...

Yes, is the short answer. are you talking about all of the data. there are various ways of doing this.

including using SSIS or select into amongst others.

Really liked the explanations, great articles so far 😀

parthi-1705 (11/18/2009)

---

I am having XXXXX010109.Tran file it has been kept in C drive,

some one have renamed it or deleted how to find whether it is deleted or rename

How to find...

Well you have different options, there is nothing on the idera site about restrictions on not using the freeware version, however they no longer now offer the freeware version for...

I am curious how this account can have 1 visit and over 10,000 points 😛

Not exactly sure what your question is, your tests are very generalised.