You must define the group under the Security > Logins.  Right click and browse to the name of the group you wish to add.  Leave Windows authentication checked.  You have...

Thanks Phill.  I will have a look at this article and see how I go.

Hi Phill,

There will be almost 100 different files each with a different file name containing about 80 rows each.

How can I pass through the name of the file as a...

The file is created by a thrid party app.  The name of the file is <MachineName>_<UserName>  So I suppose I could use this, but I didn't want to use a...

I just remembered something else that may help you.  I know if you install Office XP on your machine after installing Analysis Manager, when you go to Analysis Manager you...

If you want to connect with Analysis manager not only do you have to be a

member of the OLAP administrators group you then have to give permissions to

the c:/program files/microsoft...

You could use any of the methods you suggested.  They will all work.  I find it easiest to backup/restore when I move stuff from Dev to Test to Prod, but...

In our environment which is multiple databases, multiple servers for Test/Dev/Prod I find it easier to do a backup and restore.  We don't copy databases over on a routine basis...

I use sp_helpdb because this gives you detail on data and log files as well as the overall database and you don't have to already be in the database you...

I don't understand your point about email notification. All I get is "such and such has replied to a topic on SQLServerCentral.com that you requested notification to. Regarding the...

Hi jxflagg,

I had a previous boss who insisted that NAS was "the next generation of SAN" Yes, you cannot believe how horrible it was to work under someone so...

Hi Allen,

Thanks for the suggestions. Execution plans are exactly the same. I wasn't initially forcing a recompile on each stored proc, but during testing when I was beginning...

That's right. ALTER DATABASE will only change the data in new columns. If you don't want to rebuild your server the only way to do it would be...

You may be better off storing the file location of the image in the database and getting your application to go to this file location rather than storing the actual...

I agree with Gabor (Nyulg). Becuase of your backup issues I would go with option #3 and build a distributed partitioned view across the databases, to allow users access...