Answer Questions

• Yodine How to orginize MDX Scripting development? Best practices are wanted!

  Hi MDX Gurus, Could you please give me a properly advice. I make a lot of MDX scripting development. Today I made script changes in BI Studio, then deploy cube (changes) to the server, then test it with MDX queries from Sql Management studio. Both tools take some hundreds MB RAM and aren't quite fleetly. Do anybody have some hints to better shape this process Darren Gosbell wrote some great code for being able to deploy the calc script from Visual Studio: http://www.codeplex.com/bidshelper/Wiki/View.aspx title=Deploy%20MDX%20Script&referringTitle=Home It's VERY fast and VERY lightweight. No cube processing involved. It uses the Alter statement under the covers. ...Show All

• ErnieIII Logging Query Messages From ExecuteSQL Task

  The ExecuteSQL task makes it easy to capture the resultset of a query or stored proc in a variable. But what about the messages that would normally appear in the Messages tab when running queries in Management Studio or Query Analyzer There must be a way to display and log rowcounts and other messages that a query normally produces.   Various package/task logging configrations haven't helped. I've read discussions about logging rowcounts in data flow tasks, but what about capturing messages in ExecuteSQL and other control flow tasks that run T-SQL   I only have enough time to dabble in this technology so I may be missing something obvious or approaching this incorrectly. Any sug ...Show All

• Simone1 Varchar colum can be uniqe without beiny PK?

  Question is simple. How to make a varchar(250) column uniqe without being Primary Key. And another little advice i need. Think about a commersial website. Which one will be more efficient while connecting other tables with tblUser. Using UserID(uniqueidentifier) or UserName(varchar(250)). And is there any problem with the uniqueidentifiers performance Waiting for your advices and thanks for them... Happy Coding... Thanks for advice. I think , i'll continue with uniqueidentifier. But still i couldn't understand how to make the varchar(250) column uniqe And i also use sql 2005. Thank you Nitin Khurana... Happy Coding... a colum ...Show All

• mognog Report Server problem

  I am using SQL Server 2000 reporting services.I created a report in VS.net 2003.Report is showing in preview pane properly.But when i press start it gives a messege "No Reprot Server was found at http://localhost/ReprotServer". Is reprot server required for the reprot.whats other alternative to show the report on web browser Hi, Wich Service Pack does your SQL Server has In able to run Reporting Services on SQL Server 2000, you must at least have SP3 installed. Also, the reporting server must be installed separately. Although, it is licensed with your existing SQL Server. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• paso Expression to get the last word of the fields

  Hi, How do i get the last word of a field in an expression Thanks You'd probably be better off trying this in a script component. As an aside, I didn't know how to do this prior to you asking your question. Using Google was a big help, by the way. Search for "vb.net regular expressions" and go from there. I don't guarantee that this is the best way to solve your problem, but it works with my test data. You might also want to be sure that your field is trimmed before coming into this script component. MosheDeutsch wrote: I am aware of all the string functions available in the expression editor, how would I last word of a field using the functions available Tha ...Show All

• j2associates Disable a task in the current package programmatically?

  Hi, I have a package comprising a number of Data Flow Task steps, to import various tables of data from some Access databases into SQL Server. The name of some of these Access databases will change depending on the date, e.g. last year's data is currently in a database called "2005data.mdb". At year end this will be superseded by "2006data.mdb". The Access databases are within a 3rd party system so I have no control over the file names. I have a Script Task that checks the current date, and changes the name of an Access database in the connection string to reflect last year's date. But to complicate matters, last year's file might not exist. So the Script Task checks whether the file name exists. If not, I woul ...Show All

• Thomas2054 creating multiple tables?

  Hello, I need to create around 1500 similar tables. Does anyone know how to create them all at once instead of one-by-one thanks Hi I'm having some trouble, I made this query: declare @SQL nvarchar ( 1000 ) declare @i int SELECT @i = 0 , @SQL = WHILE @i <= 32228 begin set @SQL = 'CREATE TABLE' + tbl_i_quotes + ( QuoteDate nchar ( 20 ), QuoteTime nchar ( 20 ), BidPrice float , AskPrice float , BidSize float , AskSize float ) exec sp_executesql @SQL set @i = @i + 1 end and i got this as an error message: Msg 156, Level 15, State 1, Line 7 Incorrect syntax near the keyword 'WHILE'. Msg 102, ...Show All

• suresh babu krishnappa sd-sql (scalable distributed database system SDDS)

  Is there any practical implementation of SDDS, I have read few research papers about it and according to them SQL Server 05 can support it using Linked Servers .. Any one did any work on it You would have to provide a little more information about what, exactly, you mean by a scalable distributed database. If you are talking linked servers, this has been available since SQL Server 7.0. But, I wouldn't exactly classify extensive use of linked servers as "scalable" unless you do some VERY heavy lifting in your application code. The SDDS feature has been enhanced in SQL 2005 version as it is compared to previous versions, if you can tell your requirement we can suggest the relevant configuration. ...Show All

• Steve from adzac OLAP server or SQL Analysis Service

  Hi I am new to SQL Server and not quite understand the difference between OLAP server or SQL Analysis Service. Are they referring to the same thing An user asked me to confirm that the OLAP server is active on a server running SQL Server 2005, what do I need to check. The Analysis service is up and running, does it mean it is OK Please advise. Thanks. OLAP (Online Analytical Processing) is a generic term for the process of analyzing stored data. SQL Server Analysis Services is a product which performs the Analytical Processing for you. If Analysis Services is up and running then you're OK. Thank You Allen ...Show All

• Skippy1313 New transaction cannot enlist in the specified transaction coordinator.

  I receive above error during a COM+ component call between web and db servers. Web Server: Windows 2003 SP1 Database Server: Clustered, SQL Server 2005 SP1, Windows 2003 SP1 I setup SQL and MSDTC clustered resources per instructions. I set "Enable Network DTC" on . I set "No authenticated required" on both servers' DTC settings. I set "NT Authority\NertworkService" on both servers' DTC settings. Using the SQL Profiler utility I can see that DTC connects but cannot execute the stored procedure. Consistently fails with error: "New transaction cannot enlist in the specified transaction coordinator." This very same server/component worked flawlessly against a Windows 2000, SQL ...Show All

• dusda Change URL

  Can any body help me i need to chanage my URL when select my TPM and TPK i have two option in my Filter 1.TPM 2.TPK i writen some custome code here but its not working i know some thing wrong in that its my Code here:- Public Function access( ByVal parameter As Object ) As String IF parameter Is "TPM" Then Response.Write("<script language=""Javascript"">window.open (' //localhost/Reportserver/Pages/ReportViewer.aspx %2fTPM%2fAFM1&rs:Command=Render&rc:Toolbar=true&RUNDATE =" & Parameters!TPM.Value & ' ,'mywindow','location=1,status=1,resizable=yes,scrollbars=1,width=400,height=400');</script>") ...Show All

• RaviKanthReddy Create a cube- only of linked objects ?

  How do you create a new cube, that only exists of linked objects. As i see it, you can only create a cube by selecting source, fact table etc. - and then afterwards add linked objects to the cube.... Hmm seems like the easiest way is to create a cube, is to select at fact and dimension - finish and the delete those again. Then you have e "blank" cube and can add the linked objects.... ...Show All

• AlexBB Create a PDF file directly to disk?

  Hello all, I use Reporting Services and an aspx page to create a PDF file. I need to save the file directly to a disk file with a name, without asking the user if he want to open or to save it. I'm using the folowing command: Response.WriteFile("http://" & System.Environment.MachineName & "/ReportServer %2fReportsApp%2fRptFSUnicoR&rs%3aCommand=Render&rs%3aFormat=PDF&MyID=" & IDFun, True ) Any idea how I do that Regards Hi Chris, Thank you for your answer. I'm afraid I will have to think in another solution. As Report is generated from Reporting Services I thought I could have another parameter to force the "save" at the time I render the Report. Best r ...Show All

• keithy02 Error 1203

  I am running a script on a schedule and I get this error quite often: Unspecified error occurred on SQL Server. Connection may have been terminated by the server. [SQLSTATE HY000] (Error 0) Process ID ## attempted to unlock a resource it does not own: OBJECT: ## . Retry the transaction, because this error may be caused by a timing condition. If the problem persists, contact the database administrator. [SQLSTATE HY000] (Error 1203) If I keep rerunning the transaction, it will eventually succeed. I am running SQL Server 2005 with SP1 installed. Does anyone know what this means and what would cause it to fail sometimes and succeed other times Thanks It does not appear to be any sort of corruption. ...Show All

• Joos RS2005 Date parameter - JScript error

  I have a RS2005 report that was deployed to a ReportServer and has been running for over 1 month. I personally have not run this report in the past month, however, today when I tried to run it I got an error trying to select a date parameter. I can't paste samples of the windows displayed, so I'll do my best to explain. When I click on the report, it goes to the View window and displays 2 date parameter fields. When I click the icon next to one of the parameter fields, I get an error window that says A Runtime Error has occurred. Do you wish to Debug Line: 383 Error: 'resultfield.id' is null or not an object I click Yes and get a VS Just-in-Time Debugger window, where I choose New instance of VS 20 ...Show All