tarponboy11's Q&A profile

• SQL Server how to find the edition of SQL Server 2000/2005 through registry?

  Hey, I need to understand what version of SQL is running on some machine. How can I do it looking through the registry. I know you can do it for windows and exchange but I don't know how to do it for SQL 2000. I know in SQL 2005, it tells you the edition for SQL, but how do you do it in SQL 2000. Also, I'm pretty sure, you can look at the Product ID and tell if it's an enterprise edition or standard edition and so on, but I don't have the information. Windows and Exchange do it like that. Can someone provide me with such info Thank you in query analyzer type: SELECT @@VERSION or try HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion also see http://groups.google.com/grou ...Show All

• Software Development for Windows Vista Operating on Forms from within a workflow

  I am creating a windows application which hosts a sequnetial workflow. I want an activity of workflow to populate a list view on the calling form and then continue the workflow sequentially. I want to perform this operation simultaneously with the workflow execution. And I need to continue the execution of workflow after populating the list view.I am using AutoResetEvent objects WaitOne() method to get the notification that workflow is completed. The issue is without flagging the workflow completion the main thread cannot process the requisite operation. Can any one suggest a way to handle this issue This will be a great help. I would recommend using the CallExternalMethodActivity which is used to perform g ...Show All

• SQL Server lookup task running very slow when deal w/big tables

  I try to convert a Procedure that join 8 tables with INNER AND OUTER JOIN, my understanding is that the Lookup task is the one to use and I should break these joins into smaller block, it takes a long time to load when I do this, since each of these tables had 10-40mill. rows and I have 8 tables to go thru, currently this Stored Procedure took 3-4min to run, by converting this to 8 Lookup tasks, it ran for 20min. has anyone run into this issue before and know a work around for this. Thanks Yes, I am setting 500mb Cache size and select 3 integer and 2 varchar(50) fields only, I also try to re-arrange the lookup tables, but since all of them are big, it's limited what I can do by re-arranging them. The ...Show All

• SQL Server Duplicates

  Hi! Grateful for some help as a newbie... I have a OLE db SQL command: SELECT DISTINCT convert (char(8),date,112) as day,...etc Resulting in error "Violation of PRIMARY KEY constraint 'PK_Dim_Date "... so Column Day in Dim_date contains duplicates. I suppose i need a delete in Lookup or how would I eliminate duplicates in Dim DELETE day from dim_date where day in(Select day from date ... This sounds like a transact-sql question, not an SSIS question. But, what is the primary key of the table Dim_date ...Show All

• Visual C# Same KEY & IV for TripleDES Encryption as well as Decryption in 2 different Win Services.

  Hi, I want to encrypt as well as decrypt a file using TripleDES. My problem is that I am autogenerating the KEY & IV while encrypting the files. As per my project requirement, I have to keep both Encryption & Decryption parts in two differents windows services. Can any one please guide me how to supply same KEY & IV for both I am using the following coding for encryption & decryption: //.......................... private static void EncryptData(String inName, String outName, byte [] tdesKey, byte [] tdesIV) { //Create the file streams to handle the input and output files. FileStream fin = new FileStream(inName, FileMode.Open, FileAccess.Read); FileStream fout = new FileStream(outName, ...Show All

• .NET Development Using C# to copy data from one database backend to another

  I am new to C# and I am trying to write an application that will copy data from one database and create a new table and insert the data into this new table. The SQL statement I want to use is something like "Create Table Blah as Select * from OtherTable" or Select * into Blah from OtherTable" I am dealing with 2 different database programs. I want to retrieve the results of a query another database program (Teradata) and copy it directly into SQL Server and create the table on the fly. I am assuming that using a SqlDataAdapter would be the best way. The data that I will be pulling from Teradata is a static so I could use a SqlDataReader if that would work better. Does anyone have any suggestions Thanks. ...Show All

• SQL Server <Host System.Messaging in CLR>

  Hi All, i am trying to host the system.messaging.dll in SQL Server. I get the usual warnings about not being fully trusted. I am prepared for MS not supporting. But, when i execute my trigger (which writes to message queue), the trigger fails with an exception of 'That assembly does not allow partially trusted callers'. So. is there no way for me to write to MSMQ using triggers Do i have to rethink my strategy imports System.Messaging Dim msmq As MessageQueue = MessageQueue.Create( ".\TestQueue" , False ) msmq.Send( "Test" ) Thanks for the help Just some consideration: 1. Have you checked both against public queues hosted by active directory and by private o ...Show All

• Architecture Why would I ever use ServicedComponents for in-service data access?

  If this question belongs in another forum, please let me know where. Otherwise ... I've designed some data access objects that hit SQL Server 2005. They're to be used inside service boundaries in high-volume situations where scalability is an issue, so they'll execute on a separate server from business logic. Now I have to decide how to host them. I'm an experienced architect and developer (or I like to think so, anyway), but my .NET experience is modest, so I've been reading up. Based on my research, one conclusion I've arrived at is that at least for SQL Server 2005, it doesn't make sense any more to use ServicedComponents for data access. Yet so many of the examples of how to create high-volume data access components use Enterpris ...Show All

• SQL Server Post SP2 : Instance cannot be configured for Sharepoint Integration?

  After upgrading to SP2 straight from from SP1, I get the message that my current reporting server instance cannot be configured for Sharepoint Integration when I click on the Sharepoint integration tab.  Also, I do not get the option of choosing Sharepoint integration if I try to create a new database in the Database Setup tab.  I've read that the new Reporting Services Configuration Manager is not compatible with an older instance of Reporting Services, and realize that might be the problem.  But I haven't found how to get around it!  Do I need to uninstall SSRS and start over   I'd really like to switch to Sharepoint integration, if at all possible. Another funny thing:  I thought I might try re-installi ...Show All

• Visual Basic c# to vb

  What is the vb code for this public enum NotifyIconBalloonIconFlags : int { NIIF_NONE = 0x00000000, NIIF_INFO = 0x00000001, NIIF_WARNING = 0x00000002, NIIF_ERROR = 0x00000003, NIIF_NOSOUND = 0x00000010 } This does'nt work Public Enum NotifyIconBalloonIconFlags NIIF_NONE = 0x00000000 NIIF_WARNING = 0x00000002 NIIF_ERROR = 0x00000003 NIIF_NOSOUND = 0x00000010 End Enum Remco You'll have lots of problems like this if you use an on-line converter. Our Instant VB C# to VB conveter produces the following (after putting the problem code in a method) - note the use of the hidden <event>Event ...Show All

• Visual FoxPro how could i permanently delete a record deleted in a form?

  Good day to everybody in this forum is there a way we could issue a command "pack" in an open table in a form . My table is at dataenvironment, naturally it will open automatically when the form shows. i use primary key in the account code which is automatically increment when a new record is added, But if i delete the last record, and add a new one it gives an error, so i have to close my form and issue a pack to that table at another form created for packing,validating database, & reindexing tables. But it seems to be time consuming, i have to close the form then back again to my work. Thank you very much in advance for any help regarding this matter. Pack should be reserved to maintenance routines. Rethink your desi ...Show All

• .NET Development Append at the end of an existing xml file?

  I got an XML file, and I want add new data to its end, how I'm able to do that I use appendChild and save to do all my nodes creation and saving.Using .NET 2003 If the XML file is a well-formed XML document then to add data to its end you need to read in the XML document, for instance with System.Xml.XmlDocument, then create and insert the new elements and call the Save method of the XmlDocument instance e.g. XmlDocument xmlDocument = new XmlDocument(); string xmlFileName = @"file.xml"; xmlDocument.Load(xmlFileName); // now add data e.g. XmlElement data = xmlDocument.CreateElement("data"); data.InnerText = "Kibology for all"; xmlDocument.DocumentElement.Ap ...Show All

• Visual C# Using a class as a parameter

  Hi there! I have to pass a class (not an instance) as a parameter to a method, and I have no idea if I can do that -- tried various things and it doesn't work. It should behave like this: I have a BaseClass. Another ChildClass inherits it. The ChildClass has a method (or Property), static or not, that returns a class. The BaseClass has quite a few methods where this class is needed (to invoke static methods on it), so the BaseClass invokes the "GetClassINeed", which returns the static class and then uses it. The reason I need it is that I have about 30 of those ChildClasses, and they all need those methods defined in BaseClass. I don't want to add them in all of them if not needed. Also, to create instances of that Cla ...Show All

• Visual Basic How do i insert several records into SQLserver (2005)?

  Hi, Im new to VB.NET 2005 and i want to insert several records into a SQLServer database. The first record is ok, but the next will crash. Heres my code: Dim iCnt As Integer Dim cmd As New SqlClient.SqlCommand Dim con As New SqlClient.SqlConnection cmd.Connection = con con.ConnectionString = "[MY CONN STRING]" Try con.Open() For iCnt = 0 To 9 cmd.CommandText = "INSERT INTO Prod (Field1, Field2, Field3) " _ & "VALUES (@Field1,@Field2,@Field3)" cmd.Parameters.Add("@Field1", SqlDbType.NVarChar, 10).Value = "Test " & iCnt cmd.Parameters.Add("@Field2", SqlDbType.NVarChar, 20).Value = "Another test " & iCnt cmd.Parameters.Add(& ...Show All

• Visual Studio 2008 (Pre-release) Release date for WPF/E

  In an interview with Mike Harsh ( http://channel9.msdn.com/showpost.aspx postid=193367 ), he says that there will be an alpha/beta release of WPF/E for us to play around with this summer. Any updates on the date of this release There was recently some new info regarding WPF/E posted here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=924260&SiteID=1&mode=1 ...Show All