Answer Questions

• richbrc vwd 2005 with sql 2005 express database.

  Hi, I have vwd website on my home machine and I need to find hosting. My first Q is: Is there any difference between the file structure of an SQL Server 2005 Express database file and the file structure of a full version SQL Server 2005 database file Most of the hosters say they will not host Express. I can't tell whether they are referring to the server software or the file itself I know that they host SQL 2005 databases. And I think the ...Show All

• CrowleyM Can I run the DTS Migration Wizard from a command line in a non-interactive mode?

  I have several DTS packages to migrate and would like to script the migration process rather than interactively migrating one DTS package at a time. Can this be scripted and if so how There is currently no support for scripting this process. Thanks. ...Show All

• zkarolyi Data Access Differences in SQL Server 2005

  Hello, We have a large set of applications that we developed and build for use with Borland InterBase (5.x-7.x). We have moved/migrated off of Borland InterBase to MS SQL Server 2005. We are find some situations where InterBase was an more elegant solution and finding it difficult to find the right way to change our applications to achieve the same result. In InterBase, our Database Transactions allowed our user to make changes to the DB ...Show All

• SnowLover AquireConnection error message

  There are two data flow task areas. The one does not have any problems running thru the phases, validation, pre and post execution. When it's time for the second data flow task to run thru the phases the following message is received at approximately 89% of the Pre-Execute phase: "The AcquireConnection call to the connection manager "xx" failed with error code 0xC0202009." Then it continues to go thru the post execute and cle ...Show All

• manojgarg Programmatically changing parameters in RS2005

  Hi all, I had a series of reports in RS2000 set up a certain way to overcome particular deficiencies with the way that RS2000 operated. Basically, I had one report that would change (in essence become a brand new report - layout, etc.) based on the parameters that were passed to it. Clicking on various hyperlinks in the report would call the same report with new parameters to get different perspectives. I found this to be more advantageous th ...Show All

• MikeAlister Reporting Services 2005 Report Builder

  Does anyone know if RS 2005 report builder will work on databases other than SQL Server 2005 In other words, say I have SQL Server 2005 running Reporting Service 2005 and want to allow the end users to build their own ad-hoc reports against a SQL Server 2000 application database...  would this be possible Thanks, -Kirk Yes, Report Builder will work against both SQL Server (2000 and 2005) and Analysis Services 2005. We are working on ...Show All

• uhsxa what version of ODBC does sqlserver/.net use?

  Hi Guys, Does anyone know the version of ODBC that is used in .NET 1.1. with SqlServer 8 Is it 3 I can't find much information on this. Thanks! http://msdn.microsoft.com/data/sqlnative/default.aspx 3.x complaint. Thanks ...Show All

• themuuj Multi Value Parameters

  Hi, Thanks for the reply...I think I should have been a little more clearer. I can specify the multi paramaters, but I want to be able to select certain values from that parameter like in the pic. E.G. I have a dropdown with City's in, but I dont want to select one, which is what I can only do at the moment, I want to be able to put a tick in the tickbox next to it to select more than one Does this make sense ...Show All

• Yatharth Gupta SQL Express with W98

  Dear friends I have a question, SQLExpress are function with W98, because i had install SQLExpress in W2000 server, but the users with W98 can't connect the DB, this show a error, y tried connect by ODBC but i can't, what is the problem. Thank you I have two servers, the first when users authentication is W2000 and the other when RS installed is W2003, W2003 is part the domain of W2000 and when users login in their computer, th ...Show All

• Shyam Sundar Can't uninstall or reinstall nonfunctioning sql server

  In previous post in the Getting Started section, I discussed problems trying to run queries on multiple databases: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=299240#299240&SiteID=1 Nobody could help with the problem. I eventually got a query to run after several attempts at deleting and recreating databases. Then, I was hit with the following error message: Class does not support aggregation (or class object is remote) (E ...Show All

• AngeLsLuv SQL Trigger for Audit Trails

  I have a trigger on my Table ( MyTable ). The Trigger saves any changes to mytable . The AuditTrails table has this columns: ID, TableName,PrimaryKey, OLDvalue, NewValue,UserID,DateCreated. Now, how can i pass the application's UserID ( Not the SQL Server User ) and save it to the AuditTrails table In my .NET Application, if someone delete a record from myTable how can i possibly get the userid of that person using my Audit ...Show All

• java1974 Calling a Web Service with data from a SQL Server table one row at a time

  Hello I am trying to call a Web Servie within a SSIS package. I want to pull a row at a time from a SQL Server 2005 table and pass this data values onto the web service. Any help is highly appreciated! Kind Regards Gayatri Hi Donald During the course of the day I managed to Create a web service proxy for my web service and reference it in the script task. But when I run the SSIS Package I get the following erro ...Show All

• phradecky SQL Express Family CTP Now Available

  I’m happy to announce the release to public CTP of the following SQL Express Family products: SQL Server 2005 Express Editions SP1 SQL Server 2005 Express Edition with Advanced Services SQL Server 2005 Express Edition Toolkit SQL Server 2005 Management Studio Express (included as part of Express Advanced & Express Toolkit) You can download and install these CTPs from the CTP download page . Here is a brief description of each p ...Show All

• Tibor den Ouden MDB to SDF

  Hello, everyone. I am a new developer of .NET CF. Currently, I have a project that needs transferring tables from a existing Access database to SQL Server 2005 Mobile database. Does anybody know how to do it Thanks in advance.     We are really sorry that we could not help you much in this regard. But we would surely take this as feedback and work on this seriously. Thanks, Laxmi Na ...Show All

• Spyros Many-To-Many Self-Join

  I hope somebody can help me with a rather complicated problem I am having involving triggers and foreign keys. I am working on a database that manages projects in terms of Tasks and the other Tasks (I call them "Pretasks") that must be completed before the Task in question can be completed. Any Task can be a Pretask for one or more other Tasks, and any Task can have any number of Pretasks, which calls for a many-to-many self-join on ...Show All