Answer Questions

• Abara6 stored procedures compilation

  Dear all, Programmer had writen a stored procedure which gets executed on the page load of our website. if the page is refreshed 10 times the stored procdedure gets executed 10 time. Is there any way to stop the stored procedure compilation. Regards Mohd Sufian Let us know if you reach a resolution. I ran this script on a SQL Server 2005 SP1 instance and couldn't reproduce the problem. create database msdnTest go use msdnTest go create table t ( a int , b varchar ( 10 )) go Create Procedure xTest ( @xx varchar ( 10 )) AS SET NOCOUNT ON BEGIN Select * from t where b = @xx END SET NOCOUNT OFF go exec xTest 'x1' go S ...Show All

• Thena Login to ReportingServices fails with error

  Hello, after configuring my ReportServer, the login within the management studio fails with the error message: 'Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.' If I try to connet in IE with 'localhost/ReportServer', I get the message: 'Access to webconfig is denied' I've read several postings with this error in this forum, but not really found a solution ! I'm very frustrated now, could anybody give me a hint where and how to solve this problem Thank you in advance, Beate ...Show All

• Enes Kabacaoglu Current Lanaguage in connection?

  Hi. I have a SQL Server Analysis Services Connection in Reporting Services. But my problem is that I need to allways have the same language on dataset values. Since I have multiple languages in my olap it all depends on the language setting on the invidual computer what language the new dataset values will become. Since the developers have diffrent language settings the datasets can get really ugly. I would prefere to have english on dataset values under development. But only on the dataset becouse our reports support more then one language. I found a Current Language property under the connection setting that might be what I'm looking for But I get error message becouse from format no mather what format I try. I have tryed stuff lik ...Show All

• babyboomer OleDb Source Error - Connecting to Oracle 9i

  Hi, I have my datasource in Oracle9i and destination is Sql2005. I am connecting to Oracle 9i through OLEDb provider and when I connect to my DataSource using OLE DB Data Source, I get the following error: Warning at "guid code": Cannot retreive the column code page info from the oledb provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale Id will be used. Could anyone please help me trouble shoot this problem. Regards, Sudhakara.T.P. sudhakaratp@hotmail.com ...Show All

• DougInGeorgia mining association rules using SQL

  Hello everybody, I am interested in mining association rules field I have found some posted statements but I didn't undertand them. I need your help badly. Just tell from where should I start Thanks alot There is a tutorial using association rules for market basket analysis at http://msdn2.microsoft.com/en-us/library/ms345326.aspx This is a good place to start. ...Show All

• RussP Migrating Reports from one instance to another??

  Hello. Was wondering if anyone had any ideas about migrating a current report project from one location to another. Do we just have to take the project and deploy it on each and every separate computer And then if we do updates on the reports...is there a way to update them by just "updating something " on the central database (all are connected to one central database). I dont want to have to go out to every site and do the updates multiple times. Just really unclear about this whole process...hope it makes sense. Thanks!! I am not sure what a "central database" means in this context. In general, deploying reports from one catalog to another (e.g. to QA or Production) could be done i ...Show All

• Vlad Pitaru Launching DTA via "analyze in DTA" context option in SQL Editor failing

  TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to connect to an IPC Port: The system cannot find the file specified. (mscorlib) ------------------------------ BUTTONS: OK ------------------------------ 32bit/x86 standard edtion, build 2047 (sp1) well...i just tried it here at home and it worked SP1 is build 2047. I've only seen this error in a pre-release SP1 build (2045). Can you double check your build numbers -Paul Hello Maciek! Here comes more information: OS: Windows Server 2003 (Standard Edition) with SP1 SQL Server: SQL Server 2005 Standard Edition with SP1 (Version 9.00.2047.00) Platform: ...Show All

• susan_wolber RS 2005 hangs

  I am running rs 2005 and I created a test report but it hangs when I select it on the report manager. The weird thing is that I can run the report through the reportserver, but not on the report manager. Has anyone experienced this problem Thanks, Thanks Adam, I tried your suggestions and it still hangs...arrggghhh! This time I got it to spit out an error... Server Error in '/Reports' Application Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: Microsoft.Reporting.WebForms.ReportServerException: Execution '1lmrc555irsg4u ...Show All

• rebeccat hosting SSIS packages where?

  After i create a SSIS package, where can i put it or store it in the SQL SERVER 2005 so that i can execute it later on I got an error "An OLE DB error 0x80004005 (unable to complete login process due to delay in opening server connection) occurred while enumerating packages. A SQL statement was issued and failed." The below is my config: Package location : SQL server Server : Computer Name USERNAME: < sql server login > PASSWORD: <sql server pass> package path: <I cannot select!! I got the above error> He informing the poster that he can use the deployment utility to deploy his packages, and it will show him the ...Show All

• Steven McCarty Problem deploying reports

  Hi, I have an application that involves 3 components one of which is Reports. My system's configuration: SQL 2000 - Default instance SQL 2005 - Named instance (Instance1). I provide the user with an option of selecting the SQL Server instance. If the user chooses Instance1, then I need to deply the reports in SQL 2005. The exceptions encountered during installation are logged in the Event log. When I do the installation for the in a machine, I always get the following error in the event log: Could not connect to the Report Server Database http://<MachineName>/ReportingServices.asmx . I tried giving the rs.exe options from commandline. I got an error like: Error in DetermineReportUrlSecurity(). I don't have the exact error ...Show All

• SP2 Purchase "SQL Server Management Studio" full version?

  We still run SQL Server 2000. We need access to the full version of "SQL Server Management Studio" in order to use the Red-Gate SQL Refactoring tool, without buying the full SQL Server 2005 system. (The Express version of Studio does not work with the Red-Gate tool.) Can anyone advise if it is possible to get/buy (and if so, where) the full "SQL Server Management Studio" version I can't see any links to it on the MS site. TIA Barry As indicated above, the Developer Edition should work for your purposes -as long as it is ONLY used in the development environment. However, if you 'touch' a production server with SSMS, you are out of license compliance. Visual Studio 20 ...Show All

• F. Gsell T-SQL

  I would much rather use VB 6.0 than VB.net for T-SQL and SQL Server 2000 rather than SQL Server 2005 backend and Crystal Reports 8. Any Comments on this. Why stop there why not go to COBOL, JCL and CICS Seriously does MS still support VB6 what will you do if there is a problem SQL 2005 has so much more to offer than 2000 that I don't see any benefit coding any new stuff in 2000. Why would you still code in VB6 which is not really OOP has bad error handling (much like SQL 2000) You have to upgrade your skills, what if you get laid off in 1 year How will you find a new job with those skills Think about the future. Denis the SQL Menace http://sqlservercode.blogspot.com/ ...Show All

• Agent00 SourceSharePath

  This is a property of the DatabaseFile collection editor of a copy db wizard created SSIS package. I can't find reference to this anywhere. Any ideas what it is or why it's needed It's pretty well hidden... Open up an SSIS project Open up a wizard-created DB copy SSIS package Highlight the Copy Objects task On the Properties, click on Database Details That should get you to DatabaseInfo Collection Editor Right-hand side, Misc pane, Database Files (Collection) has a '...' dialog pop-up On that dialog screen is where you'll see SourceSharePath I can't even find where you are looking... Can you provide further details My mistake, it's "Transfer Objects" an ...Show All

• Ritesh Tijoriwala Package Synchronization?

  What is the best strategy for maintaining package execution synchronization when using the SSIS API For example, I have discovered that it is quite possible to fire off several intances of the same package simultaneously. Is a best practice perhaps to put the db in single user mode prior to kicking off the package and if so, how would you limit subsequent ASP.NET connectons, for example TIA, Rick You can create Agent Job with your package. The Agent ensures only one instance of a particular Job is executed at the same time. Of course, it will be your responsibility to make sure the package is only executed via Agent (from ASP.NET - use sp_start_job SQL stored proc). Assert.True wrote: What is the best strat ...Show All

• Kunk How can I format the Date in the SQL Table using a SQL query

  Hi I have a SQL table that contains date in this format :- 2006-07-02 16:20:01.000 2006-07-02 16:21:00.000 2006-07-02 16:21:01.000 2006-07-02 16:22:00.000 2006-07-02 16:22:02.000 2006-07-02 16:23:00.000   The date above contains seconds that I dont want, how can I remove those seconds so that the output looks like :- 2006-07-02 16:20:00.000 2006-07-02 16:21:00.000 2006-07-02 16:21:00.000 2006-07-02 16:22:00.000 2006-07-02 16:22:00.000 2006-07-02 16:23:00.000   Your help will be highly appreciated. Rod Colledge wrote: That will change the data. If you only want to change the display, then try this ; select replace(convert(varchar(20), columnName, 102), '.', '-') + ' ' + left(convert(v ...Show All