Answer Questions

• 808 XML Config files

  I am new to SSIS. I created a XML configuration file for my package. I found lots of data on how to do this but I can't find anything on how to get the values back out. I am trying to get them out in a Script file. Any help and maybe examples would be appreciated. Okay maybe I miss understood I thought you stored the values you want to use in the config file and the then you could use variables in your code to store them. I haven;t used c ...Show All

• Larry4321 Multi-Connection / Single Table Insert Scaling / Performance?

  Hello all ... This one has me a bit confused. I'd really appreciate any and all suggestions. This may be pilot error on my part... My requirement is to have multiple programatic database applications, each on a separate database connection insert data into a single table as fast as possible. My hope is that I'll see some scaling of rows-per-second inserted by adding additional processes, connections and simultaneous inserts. I'm not abl ...Show All

• jmwatte How Can I automatic create all that Objects in assembly in simple way ??

  Hi   I use SQL code snippet to attach the CLR assembly (dll) to the SQL Server Express   CREATE ASSEMBLY [DatabaseAndImages] AUTHORIZATION [dbo] FROM 'C:\CLR_File.dll' WITH PERMISSION _SET = SAFE   That file content CRL Codes for 10 Stored Procedures & 3 UDT & 5 Functions & 6 Triggers As you can see it's content large amount of DB objects !!   My Question is ...Show All

• Aditi A.Kirkole Associating Report Viewer (without UI) with Data Set

  Hello all - I am looking to use the ReportViewer Control to automatically print out some client based reports. I started with the "Print a report from a console app" sample from http://www.gotreportviewer.com/ . I have managed to convert an existing server based report from an RDL to an RDLC, and added it to my Console Project with VB.NET. In addition, I created a new Data Set within this project that returns the data from the or ...Show All

• Paarul Possibly similar issue with launching Report Builder from client PC's

  Hi, I got a working installation of reporting services 2005 up and running, Im able to create models and launch the Report Builder on the machine on which the server is installed, however if I try and run it from another machine on the network I get an error and Im able to view the following exception. Following errors were detected during this operation.  * [04 Jul 2005 10:39:34 +01:00] System.Deployment.Application.DeploymentDownload ...Show All

• daveimme Sending message with Sql Server 2005

  I have a need to asynchronously send a short message to an application over tcp/ip after the user makes a selection from a web browser. We are developing a reservation system where the availability to users in close physical proximity is indicated by lights at a kiosk. We want the user to be able to make a reservation from a web browser over the internet, (which checks the sql server db for availibility), and when ...Show All

• Phil Ekins How do I to submit a "Report Parameter" when doing a snapshot

  Hi, I need to pre produce (sanpshot) reports and the following line of code works perfectly and the snapshot and its accompaning subscriptions are duly created. RServ.UpdateReportExecutionSnapshot("/InfraTest1/StoresList") However I also need to supply runtime parameters to the report (not just the defaults). How do I do this ...Show All

• tcsss "Cannot open user default database"

  [2005 Developer Edition] In Management Studio I changed my default database to a user db. I subsequently unselected that db as the default leaving me with no default db (I think - it's been awhile and I may not have this exactly right). But regardless, I can no longer Connect to Server using Management Studio (Windows authentication) - I get Cannot open user default database. Login failed. Login failed for user 'DANA\Administrator'. (Microsof ...Show All

• Allen_DSI How to page it when use subreport ?

  I use a subreport in main report, while the subreport's data is more than one page they show in one page always! Why doesn't it be paged e.g. The subreport has 10000 records , they will show in one page. ...Show All

• David Chan SqlServer2005 can support merge replication with SqlCe2.0??

  Hi guys, Correct me if I'm wrong. That's wat I was doing.. Try to perform a merge replication between the 2. But the following errors are wat I've got during the syncronization: Error Code: 80004005 Message : Run Minor Err.: 28557 Source : Microsoft SQL Server 2000 Windows CE Edition Err. Par. : ssce:database;password=mypassword;data source=Program Files\helloWorld\database.sdf; Error Code: 80040E14 Message : The OLE DB Execute method failed. ...Show All

• Zealousman QueryLog to a file

  Hi I am trying to generate a query log to log to a file but the file never gets created. Just to confirm. Is just setting the server parameter Log \ Query Log \ QueryLogFileName sufficient given that the other parameters are at their defaults Thanks Thanks Edward that did the trick. Make sure you give your QueryLog file an extention .trc You might need to restart Analysis Server after you change "QueryLogFileName" ...Show All

• George Bolsch Error Opening Report in Report Builder

  I try to open an existing report definition like "Bug Rates" (or any other ones for that matter) and always recieve an error with this: "Server data sources do not match RDL". Has anyone experienced this or know of a way to fix this I too get this error. These are not reports that have been created in Report Builder by us, but are part of the MSF Agile process template with Team Foundation Server. A range of sta ...Show All

• Namfon Update status from one DB to another with same table schemas

  I have 2 tables (master and masterbackup), trying to update and replace the status in one with the other based on master.number match UPDATE master m set m.status = (SELECT status from masterbackup where number = m.number ) FROM mastermasterbackup If you want to use the standard syntax because this needs to run on multiple platforms, you will have to make a few changes (untested, but this should be close): UPDATE master set master. ...Show All

• None007 Problems Installing SQL Server when CTP was previously installed

  If you are having problems installing SQL Server, including Express Edition, and you previously installed one of the Community Technology Preview (CTP) releases, then read on... Please provide feedback if any of these steps are confusing. -------------------------------- Note that if the user already has .NET Framework on their machine, they're going to have to go back to an earlier version, do the SQL Uninstall, then go forward to ...Show All

• RWendi Publication Configuration Error

  Hey Everyone, I am trying to setup publishing on SQL Server 2000 Enterprise. I will be subscribing from a SQL Mobile 2005 database so I have installed the SQL Server 2000 SP3a Replication Components, .NET Framework 2.0, and the SQL Server 2005 Mobile Edition Server Tools. I was able to go through the 2005 Mobile Web Synchronization Wizard with no problems. However, when I try to run the Configure Publishing and Distribution Wizard, I get ...Show All