No, I cannot. This is what I described in second part of my original post. If I try to create a new Analysis Services database in SSMS, I get an...

Thanks, Gail.

Thanks all for your replies, but something is not clear for me:

1. Andrew: how can I get IP Address of the data modual ? That IP address that I have...

Thanks a lot, Eddie.

I checked their web-site, this is exactly what I need.

dant12 (11/8/2009)

---

if your using SQL 2008 you can disable lock escalation on the problematic tables and enforce rowlocking on the table, that should solve the concurrency problem

if your using 2005...

Thanks all for your replies, I even didn't expect so many.

For now, I am using the 3rd method of James Leeper, a stored procedure. But disadvantage of this method...

Thanks, that's good solution, you moved insert ouside of transaction. This is what I needed.

From the article on Wikipedia I can conclude that my option A is certainly falls into type 2, but the option B does not look like type 1. Type 1...

It locks just #a, not entire tempdb

Thanks, Jeff, I used your hint WITH(INDEX(0)) and found that scan was slower in my particular query.

When I initially put my post, I did not mean to insist...

OK, but my question was to generate to separate files per table, I could not find it.

I mean from SSMS / database/tasks/generate scripts ?

Thanks, Mani. This is exactly what I needed. I found this place, but having now problems with connection to target server, I guess I need to create unified login accross...

Microsoft SQL Server 2005 - 9.00.4035.00 (X64)

Nov 24 2008 16:17:31

Copyright (c) 1988-2005 Microsoft Corporation

Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

How to script each table in a separate file ?