select * from sys.sysaltfiles will tell you where the files are located , if your looking for a dedicatde disk drive volume lable then the first char ( C ,...

Most likely this issue is caused by the applcaition not opening and closing connections to the DB , you can also check you conenction pool setting in IIS. Rarely this...

You can store package configurations in the database too

http://www.sqlservercentral.com/stairway/72399/

hehehe

Three palces you need to check :-

Dimension mapping

Perspective

Permissions on the measure group.

I wouldnt start adding service packs ( sql 2000 and still ahve serice packs you need to add??) to fix a issue your facing now. Applying service packs need to...

index id 0 is heap , just to get a better idea for future use. did u get this error after a power failure ?

Did you try running a checkdsk...

are you passing the locations as a named set , please provide the mdx query to understand what your querying and how

have ypou tried by passing the boostrap file and running the setup file directly

Install media folder SQLFULL_x64_ENU\x64\Setup\MASTERDATASERVICESLOC.MSI

and

MASTERDATASERVICES.MSI

I remember doing something very similar in SQL 2000 with xp_readmail ( FAQ email helper - customer emails inbox with subject line HELP and we query the DB for related...

Depends on the budget i'd say . there are plenty of tools out there but for the list mentioned by the OP I would simply use CMS and write...

I personally think smaller files are better than bigger files. If you have a lot of data that gets queried/modified frequently then it makes sense to spread it over many...

copy paste the content of @command into SSMS and then do a syntax check

I having been planning this for the last three months , this year its going to be Hadoop and Mongo DB for me.

I would like to pick up Powershell...

Happy new year guys. wish you all a rocking 2013.