-
- Making an MDX compatibile with OWC
by Anna Mallikarjunan
- 12 Replies
- Last post
by Anna Mallikarjunan
- How can I make this MDX work with OWC PivotTable (Using CommandText):
SELECT [Measures].[Project Count] ON COLUMNS, NONEMPTYCROSSJOIN([Selection Factor].[Factor].Children, [Selection Factor].[Factor Value].Children) ON ROWS FROM PROJECTCUBE WHERE NONEMPTY(INTERSECT(NONEMPTY([Project Profile].[Project ID].Children, ([Measures].[Selection Project Count],[Selection Factor].[Selection Factors]
-
- Calling a stored procedure and pass parameter one by one
by vidkshi
- 7 Replies
- Last post
by Jens K. Suessmeyer
- Hi,
I need to create a batch process which calls a stored procedure.
Here's the scenario.
I have 3 tables
Theater - TheaterId, TheaterName, Revenues,locationid, stateid State - StateId, StateName Location - LocationId, LocationName, StateId
There is a stored procedure spoc_updateTheater that accepts the state and location id and runs a set of sql statements against th
-
- Flat File Connection - Network Share - SQL Agent - HELP!
by IDT-SSIS
- 1 Replies
- Last post
by jwelch
- SQL Agent will not successfully execute my package as a job. Bids executes the package correctly as well as when I run the package manually (right click, run package) through SQL Server Management Studio. This is a permissions issue with the flat file any help will be much appreciated. Background Information: OS: SQL 2005 on Windows Server 2003 Flat File Connection: \\servername\folder\file.t
-
- How to apply table changes in my production database?
by James_Steven
- 4 Replies
- Last post
by James_Steven
- Here is the scenario:
- I have one production database and one test database.
- In the test database i have done a few changes on the structure - mostly adding new fields in the tables.
- Now i want to apply the table changes to my production database.
Does anyone have any suggestions on how i should do that
I mean, of course i could just manually check every field and updat
-
- SSIS Clustering Doubts
by AGuerreiro
- 1 Replies
- Last post
by Andy Leonard
- I have a SQL cluster 2005 with 2 nodes. I involved a ETL (DTS) on SSIS.
I used OLEDB to get a connection ORACLE and INFORMIX.
I used a user and password to authenticate.
When I publish the package, to the Integration Services.
I publish it to the MSDB so in case that we have a failover that the package is the same.
However in case of switching server (failover) the package that I pu
-
- Can't Install Integration Services on SQL 2005 (Windows Server 2003)
by BAC-ABDI
- 7 Replies
- Last post
by Janos Mitchell
- Hello - We have been unable to successfully install Integration Services with an instance of SQL 2005 running on a Windows Small Business Server 2003. Installation proceeds with no errors, but when you attempt to connect to the Integrations Services and browse to where it apparently exists, the SQL Server Managment Studio returns the following error:
TITLE: Connect to Server ---------------
-
- Crystal Report using SQL CE
by 30KM30
- 8 Replies
- Last post
by Paroro
- I've created an app that connects to a SQLCE database. I need to create Crystal Reports that connect to the database. There is no ODBC driver for SQLCE. How can I do this
Thanks,
Kathy
-
- SQL Backup programs
by jacsme
- 3 Replies
- Last post
by tosc
- Help Please!!!!
Anyone has an idea on how to call the back up and restore feature of SLQ server using Visual basic. Please help......Thanks
-
- Report Parameter Limitation
by TomasLeung
- 8 Replies
- Last post
by sluggy
- Hi all,
I create one report with one report parameter call ˇ°Report_Parameter_0ˇ±. I access this report though HTML Form. Ex
<FORM action= http://hodb04/reportserver /report/Report12 method="post">
<INPUT type="hidden" value="Render" name="rs:Command" ID="Hidden1">
<INPUT type="hidden" value="
-
- MSSQL_REPL55012: An unspecified error had occurred in the native SQL Server connection component.
by Jason567530
- 5 Replies
- Last post
by Raymond Mak
- Hello all. I am a student attempting to run the ' Creating a Mobile Application with SQL Server Compact Edition ' walkthrough on the MSDN site. Unfortunately I am running into a problem I can't seem to get through...
I am executing the following steps in the walk-through:
Create the publication snapshot
In SQL Server Management Studio, in Object Explorer, expand the
-
- Ampersand in Analysis Services Report Alert
by tom meyers
- 3 Replies
- Last post
by Mosha Pasumansky
- I have an alert in AS 2005 that will start a reporting services report. I want to pass the current member position in a hierarchy using a parameter:
settostr({[Dim].[MyHierarchy].currentmember}) .
That causes a URL like this:
http://hosting/reportserver/ %2fReport%20Project6/Report1&DimCurrentMember={[Dim].[MyHierarchy].[Lvl1].&[all].&[west].&[300]}&rs:Command=Render&a
-
- Execute SQL Task ¨C Output Parameter on Stored Procedure causes task to fail.
by Flamin
- 5 Replies
- Last post
by Abercrombie07
- I have a SQL Task that calls a stored procedure and returns an output parameter. The task fails with error "Value does not fall within the expected range." The Stored Procedure is defined as follows: Create Procedure [dbo].[TestOutputParms] @InParm INT ,  
-
- filter matrix in report designer
by AlucardHellSing
- 0 Replies
- Last post
by AlucardHellSing
- How do i filter the the details of a matrix into parts
Regards
Alu
-
- How is sql-server using the memory?
by PatrikC
- 5 Replies
- Last post
by PatrikC
- I often read about that the best is that the whole database could fit in RAM.
Lets say I have a dabase that is 1000gb. I have 20gb RAM.
Its quite obvious that it wont fit in the memory, but is this always the case
Say for example that in the database there is one table that is 990gb, and another table that is 10gb.
Nothing is written or read to the 990gb table, all the activit
-
- Create a Named Instance on top of a Default Instance
by Khookie
- 2 Replies
- Last post
by Khookie
- Hi I've never had to do this, but when I downloaded the Web Workflow Approvals Starter Kit, it requested that I install the database into a User Instance of .\SQLEXPRESS. Now the problem is, I've installed it onto a default instance, so I was wondering whether you can create a named instance on top of a default instance... and if so, how would you do that Cheers Chris
-
- excluding a package from the build process
by cosimog
- 1 Replies
- Last post
by Jamie Thomson
- There is some way to exclude a package from the build process of a SSIS project
Cosimo
-
- How do I pass a value in the next record to the current record?
by Acoustic1978
- 2 Replies
- Last post
by Acoustic1978
- Hey Forum,
Below is a solution for passing a previous value (Height) to the current record in a view using two related tables (Plant= ID PK and plantHeight = ID FK) However, I was wondering how I could also do the reverse, that is, pass a next value to the current record.
-
- SQL 2005 Express memory limits
by PierCC
- 5 Replies
- Last post
by Arnie Rowland
- Hi everybody,
I know that SQL2005 Express has 1 GB memory limitation.
Well, if my server has 2 GB RAM and I have other applications (without memory constraints) how does this relate to the SQL constraints
Can I still run SQL2005 Express if other applications exaust only 1 GigaByte of memory
Thank you in advance.
Pierluigi
-
- Complexx AutoIncrment colum
by Nilkanth
- 8 Replies
- Last post
by Nilkanth
- Hi,
I have a situation where I have to maintain auto incremental values based on values of other colum. Sample table is given below.
colA
colB
colC
1
1
1
1
1
2
1
1
3
1
1
4
1
2
1
1
2
2
1
2
3
2
1
1
2
1
2
2
1
3
Now in a
-
- Communications to the remote server instance failed before database mirroring was fully started
by Vl.K
- 14 Replies
- Last post
by Hans1982
- command in principal server
ALTER DATABASE database name
SET PARTNER = 'TCP://<mirror_server_name>:5022'
return:
Msg 1413, Level 16, State 1, Line 1
Communications to the remote server instance 'TCP://<mirror_server_neme>:5022' failed before database mirroring was fully started. The ALTER DATABASE command failed. Retry the command when the remote database is star
-
- SQL2005 EXCEPTION_ACCESS_VIOLATION began with install of SP2 9.0.3042
by Anonymous556487
- 10 Replies
- Last post
by Paresh Motiwala
- We began having issues with various connections and queries being able to run as soon as we installed SQL 2005 SP2. We installed all hotfixes up to 9.0.3159 however this continues.
-
- How to design reports using List control
by Manjunath&#92;
- 2 Replies
- Last post
by Manjunath\
- Hi,
I am new to SSRS.
I have created simple report using reporting services, In which i am using one List element and inside that 8 text boxes and a table, in which 4 texboxes is used as lable and remain 4 textbos is value from dataset and t able displays details as below for each unquie call number with table header marked in red color. When i click preview i get below report( Report
-
- #Table not found error using Stored Procedure for DataSet
by aquinn_21
- 14 Replies
- Last post
by aquinn_21
- Hi all
I have a procedure where I am inserting some elements into #Table and then finally get the datset I need.
Now when I am using this procedure as dataset to my report, it throws up the following error:
Invalid object Name "#TEMP2".
The data that I retrieve is similar to the data that I get from this query in the post by Manivannan.D.Sekaran
-
- Report Parameters and Jump To Report
by Ross B.
- 1 Replies
- Last post
by Ross B.
- Greetings,
I have two reports, Report A and Report B.
Report A has two parameters defined as "Prompted", meaning the report input area is available for the user.
Report A parameters ---> StartDate, EndDate
When Report B invokes Report A using the Jump To Report Functionality and passing Report B's StartDate and EndDate parameters, Report A seems to think the parameters are implied a
-
- Question: How to run with mutliple configuration files.
by Keo_74
- 9 Replies
- Last post
by Phil Brammer
- Hello, Here is the scenario. I'm using SSIS and SQL 2005 I have two dtsx packages. Lets call them TESTA.dtsx and TESTB.dtsx. I've enabled using XML package configurations on both. TestB.dtsx pulls some data from a table and writes it to a flat file. TestA.dtsx calls TestB.dtsx. For the test I changed the TestB fileoutput connection string to save to a different location. When I run TestA.DTSX usi