Hi,
We have a Report built using Reporting Services on the base of the OLAP Cube.
we are trying to deploy it on Intranet and everytime we receive the Error message on connection. The Report can be run and viewed from VB.Net application and we can deploy on Intranet any reports built by Reporting Services on the base of the SQL tables.
We using connection string which works without error from application :
Provider=MSOLAP.2;Integrated Security=SSPI;Persist Security Info=False;Data Source=<ServerName>;Initial Catalog=<DataSource>;Client Cache Size=25;Auto Synch Period=10000
Any Ideas?
-----Original Message-----
From: Edwards Ed
[mailto:mssqldba-ezmlmshield-x3867833.[Email address protected]
Sent: 27 October 2005 15:33
To: LazyDBA Discussion
Subject: RE: SQL Server 2005 System Tables
Mike,
Thanks!
-----Original Message-----
From: Michael_Beadles
[mailto:mssqldba-ezmlmshield-x73406692.[Email address protected]
Sent: Thursday, October 27, 2005 10:20 AM
To: LazyDBA Discussion
Subject: Re: SQL Server 2005 System Tables
Some examples from that free Microsoft eCourse(SQL 2005 Monitoring and
Management) I downloaded ...
Catalog Views
List Databases
This code lists the databases on the server.
Note that this view returns the same results regardless of current database
context.
USE AdventureWorksSELECT * FROM sys.databases
List Tables
This code lists the tables in the current database.
USE AdventureWorksSELECT * FROM sys.tables
List Columns from all Database Tables
This code lists the columns from all the tables in the current database.
USE AdventureWorksSELECT * FROM sys.columns
List Columns in a Single Table
This code lists the columns in the Person.Contact table.
USE AdventureWorksSELECT * FROM sys.columns
WHERE [object_id] = (SELECT [object_id] FROM sys.tables ST
JOIN sys.schemas SS
ON ST.schema_id = SS.schema_id
WHERE ST.name='Contact' AND SS.name = 'Person')
List Registered Assemblies
This code lists the registered assemblies in the database.
USE AdventureWorksSELECT * FROM sys.assemblies
List Registered Database Events
This code lists the registered events in the database.
USE AdventureWorksSELECT * FROM sys.events
List Server Configuration Options
This code lists the server configuration options. Note that this view
returns the same results regardless of current database context.
USE AdventureWorksSELECT * FROM sys.configurations
Dynamic Management Views
List Table Partitions
This code lists the table partitions in the database.
USE AdventureWorksSELECT * FROM sys.dm_db_partition_stats
Transaction Locks
USE AdventureWorks
-- list the transaction locks currently held in the database
SELECT * FROM sys.dm_tran_locks
-- execute a query without releasing locks and then list the locks.
-- Note that there are many more locks than previously listed
BEGIN TRANSELECT * FROM Person.Contact WITH (HOLDLOCK)SELECT * FROM
sys.dm_tran_locks
-- commit the transaction, thus releasing the locks.
-- Note that the list of locks has returned to the original value.
COMMIT TRANSELECT * FROM sys.dm_tran_locks
458752
7
1
0
6
âEUR¦
524288
8
0
1
11
âEUR¦
"Edwards Ed "
<mssqldba-ezmlmsh
ield-x13199611.x1 To
[Email Address Removed] "LazyDBA Discussion"
.com> <[Email address protected]
cc
10/27/2005 05:52
AM Subject
SQL Server 2005 System Tables
To All,
Is it true that the system tables no longer exist in SQL Server 2005 but
these same system tables are listed under "Views". If so, what are their
qualifiers (EX. dbo)?
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
The information within this e-mail is confidential and intended solely for the use of the recipient(s). If you are not the intended recipient then please notify Natalia Brett via email at Natalia.[Email address protected] or by telephone on +44(0)1244 319912. Then delete the email from your system. Please do not read, copy, print, forward, disclose, or use the information contained within this email. Note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Aktiv Kapital. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
Aktiv Kapital (UK) Ltd
Merchants House
Hamilton Place
Chester
CH12BE
UK
www.AktivKapital.co.uk
MS Sql Server LazyDBA home page