Answer Questions

• regina SqlServer SMO StoredProcedureParameter Bug?

  I'm creating a Windows Forms application which auto-generates my stored procedures for me. Based upon a column's DataType property I'm creating instances of StoredProcedureParameter as below: if (column.InPrimaryKey) { StringBuilder parameterBuilder = new StringBuilder ( "@" ); parameterBuilder.Append(column.Name); sp.Parameters.Add( new StoredProcedureParameter (sp, parameterBuilder.ToString(), column.DataType)); ...Show All

• Maarten ter Mors Error installing SQL Server 2005 Express Manager

  Hello everyone, My name is Pete and I'm new to this forum.  Today, I installed Microsoft .Net Framework 2.0 and SQL Server 2005 Express June CTP.  The following error pops up when I attempt to install SQL Server 2005 Express Manager: "The installer encountered an unexpected error installing this package.  This may indicate a problem with this package.  The error code is 2755" I've downloaded this package several times and r ...Show All

• JM-Taz Where to look for Extended Stored Procedure DLL Wizard in VS 2005

  Hi MSDN says that we can use DDL wizard of C++ . Can someone show me where exactly this is ..Because when I open new project and look in the templates I do not find the one with this name...... Regards Imtiaz See http://msdn2.microsoft.com/ahd3f5bb(en-US,VS.80).aspx . AFAIK, you should be able to find it in the same location as VS2003. The wizard must be a function of what version of VS you have. I h ...Show All

• Rodrigo Gagliardi import Access report with subForm

  Hi! I've seen on this page http://msdn2.microsoft.com/en-US/library/ms157205(SQL.90).aspx that SubForm are supported with ReportServer. My problem is what did i need to do to be able to import my SubForm in ReportServer. When i'm importing from access it seems that only reports are imported. So if subform are supported i suppose there is a way to import the subform too. Thanks ! ...Show All

• MarlonM Un-detected deadlocks?

  Hi, I seem to have a problem that might be caused by undetected deadlocks on my system which is causing regular minute-long freezes. The way to resolve the problem is to reboot the SQL Server box, but this is inconvenient as it is a production system, and I was wondering whether any forum users might have any insight into this problem Details below: We have a main and a standby SQL Server 2000 enterprise edition installation (service pack ...Show All

• crmpicco Inserting a Control Record into a Flat Text File through SSIS

  I am working on an SSIS project where I create two flat files for submission to a data contractor. This contractor requires a control record be the first line in the file. I create the control record based on the table information being exported. What I would like to know is, is it possible to utilize the Header Section of the Flat File Destination Editor to insert the control record And, as it is dynamic, what kind of coding must I do in or ...Show All

• ahossain SQLiMail - Database Mail

  Hi I am trying to send a mail using database mail. I have enabled it using Surface Area Config for Features and and set up a default public profile usind Management studio. When executing USE AdventureWorks go DECLARE @QueryResult varchar ( 100 ) SET @QueryResult = 'Number of contacts: ' + CONVERT ( varchar ,( SELECT COUNT (*) FROM Person . Contact )) EXECUTE sendimail_sp @profile_name = 'SQLS ...Show All

• Joel Bennett using WriteNotifyEventHandler with tracefiles

  I've a fined tuned trace running that outputs the result to a tracefile. Currently I'm using the TraceTable class to read back the trace, which works fine. However I'm trying to use the WriteNotify event to react when this file changes, but it never appears to fire. I'm using the beta2 of SQL 2005, does this work in it Would anyone having a working example if it does Thanks, Cathal Cathal, First of all, I ass ...Show All

• ahives Reading compressed files - problem with x00

  I am trying to read a 36 byte files that contains compressed data. I create my Flat File data source and SSIS reads it fine UNTIL it hits a x00 in the file. Then it stops reading and I can't get any data after it. There is data after the x00. Here the entire hex string: C7 C7 CF 6A 00 00 05 02 3D 03 21 01 E0 02 00 00 00 00 00 00 00 00 3D 3C 1E FD 02 C8 00 00 00 AE 41 E3 28 7C To test, I changed the two x00 in bytes 5 and 6 to x01 and SSIS rea ...Show All

• SunsOfFun Meta Data Services SQL 2000 "msdb database could not be opened"

  Hello anyone / everyone, If you are having trouble accessing Meta Data Services on W2k3 and SQL 2000 and get the error that the "msdb database could not be opened" I found that hot fix 912812 on the operating system is the culprit. Remove it and Meta Data goes back to working, although I am being asked to approve the ActiveX control every time the page refreshes. Hope this helps somebody, to took me long enough to track it do ...Show All

• Lord_Anubis Attribute relationships

  I am having trouble understanding SQL Server 2005 Analysis Services dimension terminology. In AS 2000, you defined relationships with hierarchies...just drag and drop levels. In AS 2005, you drag and drop hierarhy relationships, but you can also define attribute relationships. What is the difference between defining a dimension like: Hierarchy Level 0 Level 1 Level 2 Level 3 Generated Attribute 23 Level 0 Level 1 Level 2 Level 3 VS. ...Show All

• Frank Laszlo sql statement from webform with dynamic join, how?

  In my application the user can enter form textfields and check checkboxes to dynamically generate the SQL SELECT. Most searched values com from one table but some come from other tables with a 1:n relation. So, if needed INNER JOIN them by writing the FROM statement in a variable, that I use in the query. Like this: " INNER JOIN tCmsElementCustomProdspecArtikelZusatzStoff ON tCmsElementCustomProdspecArtikel.artikel_ID = tCmsElementCustomProdspec ...Show All

• GaryD9 How to view Cube in WEB Browser(IE) like Pivot tables of Excel

  hi,Please! Help me.How to view Cube in WEB Browser(IE) like Pivot tables of Excel.  Your help is highly appreciated. Thanks, Siva.But How to write code to call cube which i designed with sql server 2005 Analysis Services.Thanks in advanceSatyananda You can use the Save As Web page functionality from Excel and publish the web page on your web server. You can also embed OWC Pivot table within your html page, setup appropriate c ...Show All

• nick_nyc Access Permissions on server scoped objects for login

  We are having problems with the response times from UPS WorldShip after switching from SQL Server 2000 to 2005. I think that the problem can be fixed from the database end by setting the permissions correctly for the user/role/schema that is being used by WorldShip to connect to the server but, I'm not sure how to do it. The Setup Client UPS WorldShip 8.0 running on XP Pro SP2 Connecting via Sql Native Client via SQL Server Login Connec ...Show All

• oreXero System.Windows.Form assembly is needed on script component task?

  That affects only interface design... so that it doesn't exists at all in a SSIS. What is it for Let me know your view on this or any clarification. Not sure - what do you mean it is needed for script task Darren, you're right. At least for that. I'd say it is compulsory, since you cannot remove it. Why that is I am not sure, probably a limitation of VSA, the slightly quirky host environment used. It is usefull for ...Show All