Good news, glad you got it resolved. Hope you'll continue to participate here.

Andy

This one is the best I've seen for all round coverage:

http://www1.fatbrain.com/asp/bookinfo/bookinfo.asp?theisbn=1861004486&vm=

Brian has a good book out (see the ad on our home page) and Steve Jones has one on certification...

Thanks for the follow up Jan - I'm sure future readers will appreciate it!

Andy

Thanks for all the comments so far! I have not tried Speed Ferret, but I do have a freeware add-in for VB that does much the same thing. David, I...

I think that you're using the ##table because of the scoping issues with exec(), right? I think you're having your locking issues because exec() does run in a different scope,...

That code gives me a headache. I think you're doing a lot of work just to make sure there are no gaps in the sequence. While I think your code...

Usually the best way to write to a file is with the file scripting object. Short sample:

set oFSO=createobject("scripting.filesystemobject")

Set oFile = fso.CreateTextFile("filename", False)

oFile.WriteLine "log something here"

Try http://www.msdn.microsoft.com/scripting for reference material.

Andy

...

One other comment - this is one of those situations where using a uniqueidentifier for your primarykey is awesome, since you can generate the key on the client, not need...

Michael,

So far none of us here at SQLServerCentral have much experience with Analysis - you're on your own for now! We're working on it, but it will take a while...

The easiest way is just move all the *.mdf files out of your data folder. Then reinstall and verify all is running. Then copy your *.mdf back (excluding master, model,...

If you're using ADO, take a look at the pessimistic locking options. Can be tricky and due to its nature won't scale as well as optimistic locking.

Having two users select...

I think you mean something like an order and the associated order details? Yes, you can do it all in once procedure, though its not pretty. You have to pass...

Please do not post a question more than once - I am removing your duplicate posts. Thanks.

Andy

Couple notes.

1) No reason to do the initial select, I doubt you would want it a resultset returned to you.

2) For the insert, does it work if you run it...

Been a while since I used SQL 7, but we did do a upgrade from 1 to 2g at one point and saw immediate improvment (lack of memory was generating...