Nancy,

Were you able to figure out how to refresh the cube metadata from within Excel so new dimensions/attributes/measures show, without having to recreate the Excel files? I have the...

Put brackets around it like this:

ALTER DATABASE Claims

ADD FILE

( NAME = Claims_dat2,

  FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL$SQLSERVER2000\Data\Claims2.mdf',

  SIZE = 5GB,

 MAXSIZE = 10GB,

 FILEGROWTH = 1 GB)

TO FILEGROUP

The problem is with your file system, the maximum file size on a FAT32 formatted partition is 4GB.

Check this out:  http://www.experts-exchange.com/Operating_Systems/MSDOS/Q_20343072.html

My suggestion is to add additional files (less than 4GB...

Sheba,

What OS are you running and what file system is your local drive, NTFS or FAT32?

Jarret

This may solve what you are trying to do.  Set up 2 datasets, one as you would normally for a report, and another that will get your department value (I...

This page has a pretty good explantion:

http://www.datamodel.org/NormalizationRules.html

Hope this helps.

Jarret

It won't print correctly if you output to grids, which is why I mentioned it.  If your string spans multiple lines (like the case with my code), when displaying the results...

I doubt I would go as far as using a temp table and a cursor for this.  You can do the same without either.

If you send your results to text or...

Thanks for your response Phill.

I've found one difference (so far) between the two setups.  I setup a new subscription for the report and in the 'Subscription Processing Options' section, I...

This will list the table and extended property for any table with the word 'lookup' in the extended property.

select o.name as Table_name,

 p.value as Extended_Property

from sysobjects o

 inner join sysproperties p on o.id...

Tim,

Yes there is a way.  In Query Analyzer, select Options from the Tools menu.  In the 'Connection Properties' tab, you will see a 'Set implicit_transactions' checkbox.  If you check this...

You could use the RPC:Completed and SQL:BatchCompleted events, the RPC:Completed event will give you the values for the parameters.  Your trace is growing rapidly because you are capturing every statement...

The correct answer is absolutely correct and all of you who are upset, if you would read this topic, you will see why.  The only thing that is wrong is...

I agree with Stephen Bailey, it's just used as an alias and only works under certain conditions.

You can see this if you give Tab_A an alias, you will get a...

I tried this example and got the expected results.

First example, as it was shown in the question, a 2 resulted.  Second test, I swapped the entry of the 1 &...