To add to Gail's comment, you should look into SCOPE_IDENTITY() or the new OUTPUT clause (the recommended solution).

You could loop through the databases using sp_msforeachdb. Check out this article for how to use it.

This query "may" be better:

SELECT

at.UPC as UIC,

ut.Addr_City as City,

at.Auth_Para_Dsg as PARA,

at.Auth_Line_Dsg as LINE,

...

Is there an error regarding permissions being returned or is there just no data being returned? I have done some testing and a database user in the db_datareader role...

I reply to PM's but not emails, unless from a select few users. I actually use PM's instead of email in most cases also.

So there is a header row and footer row that you want to skip? You can setup the file connection to skip the header row.

You could also use a...

Can you provide some structures and a sample query? I believe that the db_datareader role should be able to query xml columns.

Good article David. I know that I probably don't put enough time into the writing process, even though I usually spend many hours over a couple of weeks writing...

Manie,

I'll add it to my list, although that is more like a book than a SSC article. Have you checked out Brad McGehee's free eBook on Profiler, http://www.sqlservercentral.com/articles/books/65797/? ...

Another week, another few hundred posts to read through. At least we found out Roy isn't as fat as Jabba the Hut and Barry isn't a lawyer.

I...

Okay, I was dark for about a week and I missed a ton. A troll, troll names (mine came out as "I Want to Spank You Troll"), world cup,...

I'm gonna be offline most, if not all of this week. Taking a vacation and for part of the time, I'll be somewhere with no cell coverage or broadband....

Tom Brown (6/8/2009)

---

I like the variety of stuff that comes up in this thread. There's always something interesting to look at in a bored moment.

I never did computers...

Thanks for providing the feedback. You ought to talk to the vendor about using @@Identity when using SCOPE_IDENTITY() or the OUTPUT clause will eliminate this problem.

Great. I'm glad that this seems to have worked. I hope the problem is solved.