Answer Questions

• enric vives Pass XML Data to use as Data Source?

  Hello, Is it possible to pass an XML document as a string parameter to a Reporting Services 2005 report and use this report as a data source for the report I know you can source from a web service, the problem is that the effort needed to convert what I have into a web service will be more than we would like to take on. Instead, I am trying to pass an XML structure as a string parameter to a report and then setting the Command Text like so: <Query><XmlData>Parameters!XmlData.Value</XmlData><ElementPath>MyRootElement</ElementPath></Query> TIA!!! It will run in the designer preview or a published report. However, the report designer query window/data tab does not have the ability to par ...Show All

• Reza Bemanian The request failed with HTTP status 401: Unauthorized.

  Other postings I know have asked about this error message, but none has quite been my particular experience. Using Visual Studio 2005 I have developed an aspx (.NET 2.0) web page, which has embedded in it, a Report Viewer object. Clicking a button calls the Reporting Services report and populates the Report Viewer object. This web-page works fine when run from Visual Studio. Once deployed to the Web Server however, the web page produces the 401 error message. I can also run the report fine, when running it directly from the Reporting Services Report Manager, so I know I have the proper permissions on RS itself - it fails only when I try calling the report from the ASP page. Any help greatly appreciated. Thanks, Mike. ...Show All

• Ys Display SQL Information in VB

  How can I display and retreive information from an SQL Express 2005 database in a Visual Basic Express 2005 application I know that I can drag and drop a node onto the form (to display a sort of spreadsheet), but the method I wish to approach is to display information in a text box. Start here to learn about all kinds of databinding goodness. Mike ...Show All

• Vladislav U. SSIS Logging to Flat File Destination

  Hi I am trying to use a conditional split task so that I can check for specific fields. If the value doesn't exist I am piping the records to a derived field task, where I add an error. I then try to send these records to a flat file destination so that I can keep track of them. However, when I execute the SSIS data flow task I get the following error [Log Invalid Records [5496]] Warning: The process cannot access the file because it is being used by another process. This file isn't being used by any other process as far as I can tell, and the only process using it is the SSIS task trying to write to it. If anyone has any ideas, then I would really really appreciate it Thanks Darrell Ja ...Show All

• RileyEsco Grid Computing for Sql Server 2005?

  Probably a bad way to start but wondering if Sql Server 2005 scales the way Grid computing does (ie several instances attached to same DB) by adding cheap hardware which is load balancing requests. Or is there only the option of adding more CPU's to the existing frame to scale the Sql Server 2005 DB We are migrtating to 2005 from 2000 and have several questions about maintaining a sql server 2000 failback DB that is kept in sync with the new 2005 DB after it goes production. I was hoping to be able to detach a 2000 database and re-attach it to 2000 but seems not to work or at least backup and restore the 2005 databases and recover into 2000 but don't see that option. At last resort using something like DataMirror to maintain a synced ...Show All

• guilhermecvm94558 Creating Additional Instances

  How do I create additional instances of any MSSQL 2005 service(specifically database and analysis) given that a default instance is present During the instance selection screen of the install, you can also click on the button to show currently installed instances to make sure that you don't pick the same instance name again. Thanks, Sam Lester (MSFT) You just need to run setup.exe again but this time do not install it as the default instance. In stead, you install it as a named instance. Under UI, you need to choose a different instance name. If you use a command line, the parameter INSTANCENAME=<NEW INSTANCE NAME> should be use. ...Show All

• Horea Soanca SQL Timeout through ADO but not from Query Analyser

  I have a strange problem running a stored proc in SQL 2000. The proc returns XML and I'm using ADO to call the proc and return the data as a stream. When I call the proc through ADO, it times out because it is taking 40 seconds to run and my command timeout is set to 30. I can increase this no problem but the strange thing is that when I run the same proc from within query analyser, it completes in under a second. I put profiler on it tracing the command start and finish events and it's definitely taking 40 seconds between start and finish. The proc is used with various input parameters and the timeout is only occurring for some combinations of inputs, but it always seems to take much longer than it does when run from query analyser. Can ...Show All

• Ravencraft Find Counties in area

  We have the need to determine surrounding counties of a particular county. For example how can I determine, if I entered a zip code for Contra Costa and the property is also right on the line of alameda that Alameda is a neighboring county of Contra Costa Could it be determined by the longitude and latitude of the zip code in comparison with the counties Hello, Although I'm sure a geospacial co-ordinate system could be used to determine this, most people think it overkill and just use a proximity table :) tCounty (CountyID int, CountyName varchar) tCountyAdjoined(CountyID int FK to tCounty.CountyID, AdjoiningCountyID int FK to tCounty.CountyID) So if Contra Costa was near Al ...Show All

• Jim Altrichter Conversation that dont end.

  Hi There Message ordering is of utmost importance in our application. As i found in testing the only way to ensure message ordering is if they are in the same conversation.If you send multiple messages in different conversations there is no garantee which will be processed first. Therefore i will be creating conversations that last "forever", that is using a single conversation. I plan on doing a BEGIN DIALOG CONVERSATION when an inititator site is setup and writing the conversation handle guid to a table. I will them simply SEND ON SONVERSATION using the guid, i will never issue a end conversation from target or initiator. Is this theory solid, ie: is there a better way or best practice to do this I know tha ...Show All

• MJRP Sql server 2005 Stored procedures

  I used sql server 2000 before but now I installed sql server 2005. I created some stored procedures in mssql 2000 but I want to modify them. I studied http://msdn2.microsoft.com/en-us/library/ms345356.aspx   but when I expand Stored Procedures, right-click the procedure to modify, and then click Modify, It opens a sql file type and when I save it, it asks to save this file some where else and the main stored procedure remains unchanged. I have the same problem with making a new stored procedure it creates a file but it isn’t added under the Stored Procedures tree like my old stored procedures. How can I create new stored procedure and modify it   Hi, its a difference wheter you "Save" which a ...Show All

• aybe How do I schedule JOB in sql 2005

  Can anyone please help me for scheduling JOB in sql 2005. Thanks in advance. Raviraj OK. Could you please guide me to proceed further Thanks. Nice idea! You can't, there is no Agent. You will have to find a third party program. you could emulate the agent by writing a batch script that calls some sql commands using sqlcmd , then use windows "scheduled tasks" to give it a daily job... though scheduled tasks isnt super reliable IMO it can pretty much get the job done Hi, SQL Express doesnt have agent. I'll suggest you to upgrade to higher versions either workgroups or std. Thanks Yes in ...Show All

• Ruhina Default params in E-Mail delivered reports (IE7 Error)

  Hi all, [Reporting Services 2005] I have reports delivered by email subscription. My "date from - to" parameters are set to "default" as "=Today()" and "=Now()". Report is delivered fine but I have problems with "link" to that report (attached to email). RS don't add my default parameter values to this link so every time user click this link, report is generated with new "date from" and "date to" and I want to generate exact the same report (same parameters) as in the email. Is there a way to send default parameter values as static values in email delivered report link Thanks Maciej I fixed that problem by creating tex ...Show All

• Ramakrishna_Rao Merge Replication Replicate Master and related tables

  hi all, Could we configure a merge replication such as replicate the master table and its all related tables (relation deep could be 1.) We dont want to manually find master table relations and configure replication for the related tables. please help for that configuration kinds No, replication wizard will not find and define all the FK dependencies for you, you have to do this yourself. In repl UI, there is capability to create a dynamic filter on the parent table and then automatically generate the join filters based on PK-FK, do try it out in the publication wizard. No but why would you want to Thanks StatisticsIO.com and Greg Y for yo ...Show All

• Yassi deployment options

  Hello all, I am considering the different options for package deployment on the server. Until now, I have found several different ways to deploy packages to the server (File System): Using the Import option from the Management Studio (only one by one) Using the Deployment Utility (Needs building the whole project. Opens all the packages in debugging mode, cannot deploy to different folders) Using the dtutil by constructing a command line for each package deployment. (complicated) Simply copying the files from the local project folder to the "Program Files\Microsoft SQL Server\90\DTS\Packages" folder on the server. Does anyone have any other suggestions for deployment The 4 th seems to ...Show All

• tokie Source: "Microsoft OLE DB Service Components" Hresult: 0x80070005 Description: "Access is denied."

  Hi, we configurated 3 2005 servers (dev ,test, prod ) to run SSIS using shell as following we set proxy account 'OURDOMAIN\dtsrun_dev' to start shell and created procedure to call dtexec create procedure [dbo] . [execute_SSIS] @ssis_name_and_params varchar ( 8000 ) WITH EXECUTE AS 'OURDOMAIN\dtsrun_dev' as declare @ssis_to_execute varchar ( 8000 ), @retcode int set @ssis_to_execute = 'dtexec /sq ' + @ssis_name_and_params + ' /ser ' + @@servername + ' /Rep E;W' exec @retcode = xp_cmdshell @ssis_to_execute ; if @retcode <> 0 begin Raiserror ( 'SYSADM DTSCALLERROR' , 16 , 1 ) RETURN @retcode end It work fine on dev and prod server (whe ...Show All