sorry to show up my ameteurism in this field, but what is the ops guide and where is it located?

i have searched around the server for settings and cant find a data directory setting anywhere there, so it may be in the registry, but i aint touching that with...

i dont know what date or time should be there though! there is a ? sign, and i dont know what date time that represents in sql server 2000

ive done no optimization as of yet. where do you find the AS 2000 guides? they are not in my version of BOL. I was looking on the web, and...

thank you very much! this done the trick!

i have done this ages ago,and this is what gave me my current knowledge of encryption. i can encrypt columns and set them to be viewable by only certain logins,...

i just saw what was wrong. below the cursor code i had two functions, and as soon as the cursor finished, it just went straight onto the functions, that provided...

perfect!!! thanks a mil. you just made my life a little bit easier!

yep, that sorted it. i ran  "sp_help_operator" on on the source database, found the operators that were there, and added them to the new database using the data...

hi, i altered the command as instructed, but getting the same error .

thats why i love this forum!! everyone is so observant and thorough ( except me!) thanks Lowell! Id never notice that in a million years

thanks Carl. best suggestion ever!! should have known myself, but was looking for a complicated solution. couldnt see the forrest through the trees!

is this possible with SMO? where can i find a bit more info on this? ive checked BOL, and had a look on the web but its all a bit...

vs2005 pro comes with dev  version of sql server 2005. thats what il get i think. thanks all

the user is just a service account. analysis servces service is running under a service account and that is the account it uses to connect to the db. i reset...