Answer Questions

• sarrafi Stuck between "Failed to generate user instance" and "An attempt to attach...failed"

  I wrote an application using Visual Studio 2005 beta 2 which uses a SQL Express .mdf file, included in the project, for the database.  After installing Visual Studio 2005 RC and the SQL Express that comes with it (I followed all of the uninstall instructions first) I can no longer add a SQL Express database to any of my projects, nor can I open the SQL Express database in my original project.  When I try either of these tasks, I get th ...Show All

• JCtfs Can't instantiate a ISQLDMOApplication object from a 64-bit C++ executable

  When my 64-bit (AMD64) program executes: vslReturnCode = CoCreateInstance(CLSID_SQLDMOApplication, NULL, CLSCTX_INPROC_SERVER, IID_ISQLDMOApplication, (LPVOID *)&vsopSQLDMOApplication); A nasty MessageBox is displayed (even though I've executed SetErrorMode(0x8007)) stating: Runtime Error! Program: G:\DMOTest.exe R6034 An application has ...Show All

• Suite RSConfig Doesn't Resolve External Image Issue

  I ran RSConfig -e with the user name and password specified to access external images stored at http://<servername>/images/image1.jpg I still cannot access the picture in Preview or on the server (401 Unauthorized) when I explicity type the URL to access the picture at. Eventually I will pass the URL from the database, but for now I just want it to work with a test picture I put in the folder. Anyone experience the same issue and hav ...Show All

• nathan koterba Avg, Min & Max of two date fields in a Table

  i have a table T_EPISODE that has two fields referral date (D_REF) and assessment date (A_DATE) i need to get the average, min & max time between the referral and assessment dates where the assessment date falls within a given period (dteFromDate & dteToDate) and where assessment date is not null but im a little bit stuck on how to do it. i know about the MIN & MAX functions but they only work one field at a time. do i need to d ...Show All

• Jerry Eldridge Printing Issue

  I have to print a report like X + Y = Z Where X, Y are database fields + and = are string literals and Z is a calculated field I am using a table control with five columns for X, +,Y,= and Z Trouble is how do i print "=" in column four since = is reserved character Is there a way to print = in a cloumn Thanks Thanks !!! It Worked. ...Show All

• Shabba Perform an experssion in desing mode

  Hi all, SSIS, I would like to perform/validate an experssion in design mode. In particular, i would like to see the value of the varibles before running the whole package. I tried several time in Command Windows or Immedite Window unsuccessfully. Do those windows can only be used in running mode Or how can I do that in other way Thanks That's mean I must create varibles in Control flow or date fl ...Show All

• Martin Dietz Huge Log File

  Hi, I have a log file that is 18.4 GB in size. I beleve the reason is because that DB stores images in the records in the image columns. What is a logfile Is mine too large Does the size of the logfile affect performance If so how do I make it smaller Any help would be appriceated. Thanks, A .net developer without a DBA. It is true that the log file won't automatically reduce in size. As for using simple recover ...Show All

• mconnag User and Pass for SQL Express 2005

  How to do this I think that is easy but i can find nothing. I dont want Integr ated Security option.... Greetings I'm not sure what problem your encountering. By default SQL Server Express is installed with Windows Authentication only. Do you want to change this to Mixed Mode which allows both Windows Authentication and SQL Authentication This is documented in SQL Server 2005 Books Online which you can download from http://www.microso ...Show All

• 10e Trigger Problem

  I Have problem in creating after insert trigger. Actually my requirement is when i try to insert a record in transactions, trigger should get td_value from control table and update the same value in the transactions tablee, then increment the id_value by 1. I wrote trigger as below, but it is giving error in update transaction set..... statement can some on help in this regards. create trigger update_transID on transactions after insert as de ...Show All

• Phil Ekins InfoPath and native web services

  I am working on a generally applicable ETL framework using SSIS for a large Swedish insurance company. The configuration is driven by XML stored in the database and I thought InfoPath would be an exellent graphical user interface to that data. As I couldn't find any way to directly access the typed XML columns I gave the native web services a try, but it seems InfoPath doesn't like the WSDL. In the WSDL are two webmethods mapped to two stored ...Show All

• Michael B. Price Data mapping to column 'CustomerID' was already found in the data. Make sure that no two schema definitions map to the s

  I am getting the following error message when I try to load XML data from a file: Data mapping to column 'CustomerID' was already found in the data. Make sure that no two schema definitions map to the same column. Here is my Schema: <xsd:element name="CustomerList" sql:relation="Customer">   <xsd:complexType>   <xsd:sequence> <xsd:element name="Customer" sql:is-constant="1" maxOccurs="unbounded">   & ...Show All

• Marcus1976 Partition Scheme

  Hello everybody, how can I verify a partition scheme in SQL Server 2005 (June edition) SELECT p .* FROM sys.partitions p , sys.objects o WHERE o . name = 'mytable' AND o . object_id = p . object_id GO this always returns only one partition thank you Eckard BTW, there is some confusion about terminology.   A partition != a partition scheme.  The query above looks at a tab ...Show All

• Neotick Show/Hide column according to parameter value

  Hi, I have a report that is showing international sales. I want to display the currency column (or not) according to a parameter value. I have set the visibility/Hidden value to: = Not Parameters!OriginatingCurrency.Value Should work I thought so. when I try and view it, I get the error: "The table "table2" has 'OriginalCurreny' as a toggle item. Toggle items must be text boxes that share the same scope as the hidden item or are in ...Show All

• DonovanH SQL 2005 Time Sensitive Question

  I have a problem installing sp 1 for sql 2005 express. How can I check if I have sql server or the sql 2005 express edtion and if it is a beta or not. I want ot install the SP1 OF SQL 2005 When I go to the add/remove program section I see sql 2005 edition and not sql 2005 express edition, very confusing because it indicates to look for sql 2005 express edition in the add/remove program and remove it. I don't even know if I have a beta release or ...Show All

• MFaucett sp_changedbowner bug?

  in studio sqlserver 2005 beta 2 press button new query, use adventureworks entry text: sp_changedbowner 'sa' press execute - result ok entry text: create procedure anyproc .... go  sp_changedbowner 'sa' script  ending  only if press stop button entry text: sp_changedbowner 'sa' script  ending  only if press stop button   I am unable to repro this on build 1307. ...Show All