Can any of you who have started or evaluated usage of SQL Server
reporting services please share your experiences.
How come there is still no thread on microsoft.public.sqlserver.* on
Reporting services will it be implemented at some stage.

I have downloaded the new realese of SQL Server Reporting Services
(the real release, not the Beta 2) and gets the following error
whenever I try to build, deploy or preview a report. I even got it
when I try to shut down the Microsoft .Net IDE. Does anyone have a

I am trying to defrag my Hard-disk drive. Windows 2000 Server does not
defrag my drice compoletely as major portion is occupied by my SQL database
whose size is around 2GB. The Defrag program on completion says that it
cannot defrag the SQL Database files.

I want to use Linear Regression functions -- example :LinRegSlope -- .in my
calculations.
Found that it's part of Analysis services.
Is there anyway I can get these fuctions in Standard edition of SQL

my operational database is sql server 2000 and i want to
build data warehouse , can i use that database to crate
star schema or i must crate new table to fit fact and
dimension table

when I try to call DSO methos NextAnalysisStep (PercentageBenefit As Double,
AccumulatedSize As Double, AggregationsCount As Long) of object
Partition.Analyzer, I get error Type Mismatch.
I would like to create cube partition each month and design aggregations

1)Can end users build reports and deploy them easyly?
2)In the final version, will be there all the components
requirements to install it?

Im looking for a book that will get me started creating a Datawarehouse on a
SQL 2000 server.  It will need to cover all areas since im new to this
field.  Im very familiar with ER modelling and OLTP database design but have
never ventured into Datawarehousing.

When Does SQL Reporting Services will be Released

I have numerous logs like this one...using the sql
serverstring function(with Charindex) or any other
function, can someone help me and tell me how do i pull
out the 1st value after the symbol '&' (symbol ampersand)?

Is there any way in SQL Server to use Standard deviation as an aggregate
function.
STDDEV  -- Is a numeric expression. Aggregate functions and subqueries are
not permitted

how to model changes (I've read R.Kimball) in dimensions and (more
important) how to implement them in OLAP e.g. MS AS ?
I read some papers from scientists but they are not based on commercial
solutions - I don't know how to show changes in MOLAP and how to solve

On a quarterly basis I need to refresh a 20 GB database copy with production
data.   To Do this what's the best method.
1.  Back up the production database and restore with a different name.  If I
restore it on to the same server and during the operational hours, what are

Anybody know a way to make a varchar field not allow duplicates besides
making it a primary key?

All,
When I try to process my new cube, I receive the following
messages:
Unable to count the members of 'LineOfBusinessLevel4'