Answer Questions

• scottj1234 SQL Server 2005 Sep CTP setup failed.

  Setup attempted on a clean install of Windows XP SP2. The log file Summary.txt contains: Microsoft SQL Server 2005 CTP 9.00.1314.06 ============================== OS Version      : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time            : Wed Sep 21 22:04:53 2005    MachineName : Could not find a package to install on the installa ...Show All

• Sces Can I create subscriptions programatically?

  Is that possible if so please point me in the right direction.    I was looking at the example on the MSDN, and on the link provided above, I was trying to reference system.web.services.protols, but it was not found. I am trying to set up a dynamic subscription application so that users can run a certain report with certain parameters on a monthly basis, or off peak hours, and have the report emailed/placed on a network driv ...Show All

• steve hayles Report Paramaters and WildCards

  I've created a report parameter which i've had to concatenate and modify because of the way in which the information is entered into the database - consequently I need my query parameter (in my database query) to only match the beginning of of each report parameter.  For instance - my parameters (in my drop down list) state "Pentium 4 CPU" whereas within the database this entry is stored as "Pentium 4 CPU 2.23GHz" or "Pentium ...Show All

• JoQron AdventureWorks db for 101 Samples

  I'm not sure if this should be asked here.  If it's the wrong place, let me know and I'll correct. I've just downloaded 101 Samples for Visual Studio 2005 .  But the data access samples require AdventureWorks database which is not included in the C# sample.  Who know where I can get this database   It is a SQL 2005 database, I think. Thanks! Hi blackpuppy, You'll need the June CTP version of SQL Server Express, whi ...Show All

• WileyWes SQL to XML

  I am currently creating an sql script that will write to file, creating an xml file in the process. I have almost accomplished this but have some training blank spaces that mean the file does not work in the application I am calling the xml file to. The sql code is this :- DECLARE @FileName varchar ( 50 ), @bcpCommand varchar ( 2000 ), @xmlPrefix varchar ( 500 ), @xmlPostfix varchar ( 500 ) SET @FileName = REPLACE ...Show All

• Aman B sp_change_users_login

  Is there a function like sp_change_users_login that will work with Windows NT Accounts No, there is no such function, because there is little need for it. If you recreate the Windows logins, they will automatically be mapped correctly to the corresponding database users. For recreating the Windows logins, you could look into sp_help_revlogin ( http://support.microsoft.com/kb/246133/ , http://blogs.msdn.com/lcr ...Show All

• michealdm Authentication Problem x64

  Win 2003 Server x64, .Net 2.0 x64 Reporting Services 2005. RS Database is a remote SQL 2005 on the same Domain in the same room. I can only get the report manager to authenticate local users; it will not authenticate Domain users. If I set up a local user and add a New Role Assignment all works OK. I have no problem adding a Domain user to a New Role Assignment, it allows this, but it will not authenticate the user. Adding the Domain user t ...Show All

• webguru72 SQL Express Beta to SQL Express Current Version

  I have a database which was created in a beta release of SQL Server Express. It was also create when I had the .Net Framework 2.0 Beta installed. Since then, I have installed .Net Framework 2.0 (Current Release) because that is what was required for MS SQL Server Management Studio Express. When I try to connect to the DB now it says Cannot connect to server. I also have the mdf/ldf files. When I try to attach them on another computer ru ...Show All

• van Kooten Retrieving DefaultConstraint property of a Table column is too slow

  Hi, I have an application that prints the Table details using SMO.  I specify all the columns that I need to print in a call to SetDefaultInitFields as shown below:      oSQLServer.SetDefaultInitFields(GetType(Column), New String() { _          "Computed", _           "DataType", _         &n ...Show All

• EHerb Report Viewer Issue in Visual Studio 2005 Beta 2. for Microsoft Reporting Services

  Hi I am trying to display  Microsoft Reporting Service Reports from windows application. I have application window with Report viewer control. I have  assigned valid path and URI from Server report properties in report viewer control. When I try to display the reports Error is " "The attempt to connect to the report server failed. Check your connection information and that the report server is compaitble version. The request failed w ...Show All

• sharif_m SQL Server 2005 and RDO compatibility

  Are there any known issues with using RDO with SQL Server 2005 My company is in the process of updating our SQL Server 7 database to SQL Server 2005. Most of our applications are several years old and written using RDO to access the database. I have since started the daunting task of updating all the applications to ADO, but it's only about a quarter of the way done. We need to update the database ASAP, but we cannot wait until all the ...Show All

• SDante Changing data types of a variable in an expression

  Greetings once again SQL friends, Sorry to bug you with my silly questions but this little problem has been driving me crazy for the last hour or so! I am attempting to change the data type of a variable in an expression but I keep getting an error saying that the expression can not be evaluated. The syntax I am using is as follows : (dt_str) @[User::MAX_OFFER_PRICE_ID] My variable MAX_OFFER_PRICE_ID is type int32 and I am attempt ...Show All

• SAP_TECHIE There is already an open DataReader error when scripting a view

  SQL Server Management Studio: When I try to script a view by right clicking on the view and select Script View / as CREATE TO I get the following error: Exception has been thrown by the target of an invocation. (mscorlib) There is already an open DataReader associated with this Command which must be closed first. (System.Data). This must be a bug Charles http://lab.msdn.microsoft.com/productfeedback/ This looks like a bug can you ...Show All

• G. Karthikeyan Should this be an error rather than a warning?

  If you have a package that uses an environment variable for an indirect configuration and the environment variable is not present when the package runs you get the following warning: The configuration environment variable was not found.  The environment variable was: "Seer.ConnectionManager.CUECommonReference". This occurs when a package specifies an environment variable for a configuration setting but it cannot be found. Check the confi ...Show All

• Gerald Gibson How Does one Save a Stored Procedure

  In Microsoft SQL Server Management Studio Express you can right click on "Stored Procedures" under a database in the object explorer and the resulting Context Menu offers a selection called "New Stored Procedure". If you select  "New Stored Procedure", a Stored Procedure Template Document is added for editing.  It has the suffix ".sql";  I can save this document to the file system after I edit it, but  I cannot f ...Show All