Super, I am gonna try it!!! thanks

tanx 2 much 4 your help!!! the last post did it, thanks all

The server is not clustered and in a workgroup. Any other ideas?

thanks!!

if I save it a a vb file package.bas, can I , or how can I open/import this package.bas file in a DTS designer in another machine?

so to say a view is a table only in ram is correct, the virtual table is NOT written to the hard drive, accept maybe in cases of swap file...

thanks , this leads me a couple of questions.

what exactly are cursor used for?

which template in profiler best for this situation?

Are views just in emeory or are they , the...

Very good thanks David

super respose thanks, hate ask another question based on your answer but here goes. What is benefit to saving indeces to another file? it you do so, can you put...

super answers, thanks!!!! well written

Yes, It is not a good idea to ever hard code the login/password becuase it limits the ability for it to be changed on the server (since the front end...

ANother super answer, that explained alot. thanks very much!!!

awesome answers, thank you very much for your expertise, time and effort to respond!!!!

Adam

thanks so much . No I do not have a quiz, I just have pent up questions. kinda like blue balls if you will.

thanks, Also when does it actually index, after I set the index in enterprise manager?