AdventureWorksDW for Analysis services

Any body has a link for downloading that DB ? (Other than codeplex.com please !)

The one i have downloaded from codeplex produce errors related to missing (Data1.cab) File.

Any links ?

I've been VERY frustrated with Codex as well.

The best solution I've found is to go back to the SQL Server installation disk and reinstall the samples. If you installed these earlier, there is a script that will rebuild and load the Adventure Works DW relational database. (You will need to modify the data file path in the script.) You will then need to assemble the OLAP database using the provided solution.

B.

Advantages/Disadvantages of SQL 2005 Reporting Vs Crystal Report 1

Hi:
Can someone show me a link where I can get the Advantages/Disadvantages of
SQL 2005 Reporting Vs Crystal Report 10 ?
Thanks in advance.
--
Thanks,
SDRoyTry this:
http://www.crystalreportsbook.com/SSRSandCR_ExecSummary.asp
"SDRoy" wrote:
> Hi:
> Can someone show me a link where I can get the Advantages/Disadvantages of
> SQL 2005 Reporting Vs Crystal Report 10 ?
> Thanks in advance.
> --
> Thanks,
> SDRoy|||I just perused it and two things. One is that it was written prior to SQL
Server 2005 coming out. And, two, the licensing is incomplete. Apples to
Apples I have never heard that Crystal Reports is cheaper. The licensing
costs mentioned are per CPU for SQL Server which you might or might not have
to do. From what I have seen when we looked at Crystal Reports licensing
there is no way that you will get away with the $7,500 license fee that the
author compares to the Enterprise per processor license for SQL Server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John G." <John G.@.discussions.microsoft.com> wrote in message
news:9AF11023-0A1E-4CE8-87DC-81B7F583A2D0@.microsoft.com...
> Try this:
> http://www.crystalreportsbook.com/SSRSandCR_ExecSummary.asp
> "SDRoy" wrote:
>> Hi:
>> Can someone show me a link where I can get the Advantages/Disadvantages
>> of
>> SQL 2005 Reporting Vs Crystal Report 10 ?
>> Thanks in advance.
>> --
>> Thanks,
>> SDRoy

Advantages of Database Diagram

What is the advantages/disadvantages of using Database Diagram and link all the tables in MS SQL Server Management Studio versus letting the application check and link the different tables at run time? Currently, I do not have all my tables linked in a Database Diagram. I do everything at run time in my application code behind. What are the best practices? Which is easier or perhaps more secure?

I always used the diagram tool in SQL2000 - not only is it a great resource for new DBA's and developers, it adds constraints that you might otherwise forget. It's a great simple way to ensure you don't end up with missing links in your data.

|||

Many thanks for the response. Is constraint the biggest advantage of using diagram? By the way, can I use MS SQL Server Management Studio 2005 to diagram a database tables on SQL Server 2000?

|||

Lack of referential integrity can lead to very hard to trace faults. Where relationships exist, it is far better to define then at the database level as the relationship is then always enforced.

You can have more than one diagram. It is not necessary to have diagrams to define foreign key relationships, it is just a bit easier that way.

|||

Thanks for the responses.

sql

ADSI - SQL Server - Link to ADAM Help

Help!
I've seen a few others with this problem, but have not found a
solution anywhere:
I'm trying to link AD/AM to SQL Server through ADSI for querying in
SQL.
Environment:
Windows Server 2003 **Not in an AD domain
SQL Server 2000 (running under 'administrator' user account)
ADAM (Added "servername\administrator" and several adam users to the
"Readers" role)
Steps taken:
1. Add Linked Server-
sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces',
'ADSDSOObject', 'adsdatasource'
2. Multiple Attempts at Linked Server Login-
exec sp_addlinkedsrvlogin 'ADSI', false, 'MACHINENAME\administrator',
'MACHINENAME\administrator', 'password'
exec sp_addlinkedsrvlogin 'ADSI', false, 'MACHINENAME\administrator',
'cn=username,cn=users,cn=app,dc=company,
dc=com', 'password'
3. Multiple Attempts to Query through SQL Query Analyzer-
SELECT * FROM OpenQuery(ADSI,
'<LDAP://localhost:389/cn=app,DC=company,DC=com>;subtree')
SELECT * FROM OpenQuery(ADSI,
'<LDAP://localhost:389/cn=app,DC=company,DC=com/cn=users>;subtree')
-- All of the above result in the following error message: OLE DB
provider 'ADSDSOObject' reported an error. The provider indicates that
the user did not have the permission to perform the operation.
OLE DB error trace [OLE/DB Provider 'ADSDSOObject'
ICommandPrepare::Prepare returned 0x80040e09: The provider indicates
that the user did not have the permission to perform the operation.].
Now, this query did result in a different error message:
SELECT * FROM OpenQuery(ADAMConn, 'SELECT * FROM
''LDAP://localhost:389/ cn=app,DC=company,DC=com'' WHERE
objectCategory = ''Person''')
--Message: OLE/DB Provider 'ADSDSOObject' ICommandPrepare::Prepare
returned 0x80040e09: The provider indicates that the user did not
have the permission to perform the operation.
Can someone help'!!Having same issue...LOTS of people with problem...but no solution posted.