fergar's Q&A profile

• SQL Server mining model with time

  i want create a model to predict what product i should Ads for customer at time. example: in summer, i should show the , drinks (coca, pepsi) , ice food, bikini, sandals, glasses. in winter, i should show shoes, coats, hot food.... i have some table: order(orderid, time,cusid...) product(productid,..) orderdetails(orderid, productid..) customers(cuisid,....) ...Show All

• SQL Server 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 down. If anyone has a resolution to the ActiveX question I'd love to know the answer. Thank you, Uncle Davy That would seem the logical choice. However, I tried permitting every activeX and it was still giving me the error! ...Show All

• Software Development for Windows Vista how to transfer params into Workflow.handleExternalEvent_Invoked method?

  i think you guys all have checked Microsoft's HOL for WF yet, and in Lab04, we got know that the state machine workflow, and i got an fuzzing problem that: how i can specify the 'sender' object into handleExternalEvent and more, how the 'e' of ExternalDataEventArgs be transferred info the handleExternalEvent_Invoked method in one word, what's the schema of that handExternalEvent_Invoke method i have stepped into the Debug mode using F5, and find that 'sender' Param in handleExternalEvent_Invoked method is null , but 'e' Param got his value and the runtime type is just 'OrderServices.OrderEventArgs' which we expected. i just got some clues througth that interface 'IOrderService' and its ascending class 'OrderService' th ...Show All

• Visual Basic question about references

  If I add a reference to my solution by right clicking on the references in the solution explorer and selecting add reference, what am I doing I understand what I did, but, what effect does this have on my application. I am assuming that this is where I can add my custom classes to the program. (or other classes that I have). Am I correct in this assumption. If not, can anyone please point me into the correct direction This allows you to utilize the Classes, method, enumerations, constants etc. that are defined in the assembly that you are making reference to. These could be user defined - if you create a class library or they may be system classes eg. System.dll ...Show All

• SQL Server get the list of catalog views in SQL Server 2005

  How to get the list of catalog views sys.* (sys.objects, sys.columns ....) in sql server 2005 select * from sys.objects where objectproperty(object_id, 'IsSystemTable') = 1 did not return the list as I've expected thanks You'll want to use sys.all_objects instead, which includes the system views:   select * from sys.all_objects where     type = 'v'     and is_ms_shipped = 1     and schema_name(schema_id) = 'sys' -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     <Mohamed B.@discussions.microsoft.com > wrote in message news:6a807b16-bcef-49c ...Show All

• SQL Server wmi error

  Am running a SQL Server 2005 Ent IA64, 2 node (active/active) cluster on Windows 2003 Server Ent with SP1 IA64. Everything working ok, but everytime I launch the SQL Server 2005 Management Studio, the following is logged in the Application Log: also all was ok until I ran the remote debugger wizard in visual sutdio. There were no errors prior to this. I did not select anything, open the wizard, click next and finish, I did not select anything. Event Type: Error Event Source: WinMgmt Event Category: None Event ID: 10 Date: 04.06.2006 Time: 07:32:04 User: N/A Description: Event filter with query "select * from __InstanceModificationEvent within 10 where TargetInstance isa 'Win32_Service'" could not be (re)activated in namespace &q ...Show All

• SQL Server LevelZeroOnly provider options in cross SQL Server 2000 linked server Error

  I need to create a linked server between 2 SQL Server and use the "LevelZeroOnly" provider option. However, when I set the option, I can see tables in SS Enterprise Manager but I can't send a select request to the remote server. I always get this error when I try to sent this request (LinkedSrv is my linked server): select * from LinkedSrv...SampleTable SqlDumpExceptionHandler: Process 53 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionWrite (WrapperWrite()). But this request does work : select * from openquery(LinkedSrv, 'select * from SampleTable') Thanks for any help to solve my problem. ...Show All

• Visual Studio Visual Studio 2005 Design Mode Question

  Hi There, I have lost the functionality in the Visual Studio 2005 design mode to use the arrow keys to "nudge" my form controls (e.g., textbox, etc.) around the workspace. I can still use my mouse to accomplish this, however it is not precise. Does anyone know how to re-enable these keys Thank you, Doug. Menu Tools => Options Node Environment => Keyboard Set the keyboard mapping scheme to (Default) if it is not yet set to (Default) Click on "Reset" ...Show All

• Visual Studio Express Editions open a file in listview control

  Hello all, Part of an application that I'm working on uses a treeview/listview control. My goal is pretty simple, I think... I've created an application that parses HTML files. It allows the user to edit these parsed fields and save their changes over the existing file. I realize that I could use the filebrowser dialog, or simply enter the path of file, but I need the user to be able to select a file in the listview control and have that file load in a textbox. Again, user selects (clicks) a file in the listview. By clicking the file it automatically opens in the textbox. I have no clue as to how to accomplish this seemingly simple task. Any help would be very much appreciated! Thanks, Mike ...Show All

• SQL Server Distributed transaction problem

  I'm having problems with distributed transactions. I know this has been descussed a lot before, but i haven't been able to solve my problems anyway. So, what do I try to do I try to recieve data from one server (source) to a destination server with an integration services package using a transaction. The source server is a Windows 2003 server running SQL 2000. The destination server is a SQL 2005 Cluster on Windows 2003 Server. Both machines has MSDTC running and allowing both inbound and outbound transactions. I have run DTCPing and DTCTester successfully in both directions. A bit simplified, my SSIS package looks like this. Execute SQL Task (Delete old data on the destination server) Data Flow Task Get data from sour ...Show All

• SQL Server problem in executing package in production environment

  hi all! This is my problem. My package executes fine when i set the connection string with the same database where i execute the query. If i execute with another database connection stirng if fails bacause while executing the pacakge it trys to access the same connection string at design mode. when i try to execute through cmd prompt by setting \conn <new database connection string> it fails. Is package configuration is the only solution. how can i change conn string depending on different server Any help would be appreciated. Thanks, Jas i am currently trying to set the variable with the /set and give connection string as /conn but when i do it another environment and change the c ...Show All

• Connected Services Framework Login failed for user 'TEST\administrator'. [CLIENT: <local machine>]

  Hi Friends, I am getting the below error while installing CSF DevLite edition on Following is the breif Info Server Is : Win2003 SQL SERVER 2005 Installed on Same PC Domain Name is : Test User : Administrator he is a build in Admin, PLEASE HELP ME!!!! Thanking in advance. EVENT LOG 1: Login failed for user 'TEST\administrator'. [CLIENT: <local machine>] EVENT LOG 2: The description for Event ID ( 11609 ) in Source ( MsiInstaller ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following ...Show All

• Software Development for Windows Vista Migrating to Beta 2.0

  hai Iam trying to use SQLTracking service present in workflow foundation..... In Beta 1.2 i used this service to track my workflow...i tried the same in beta 2.0 but the database is getting updated only after the workflow gets completed...due to this iam not able to track the current status of an activity while it is executing,but in Beta 1.2 i was able to do it.... need help as soon as possible Regards Ashok Kumar ...Show All

• Windows Forms how to print a dataGridView

  Hi I want to print a dataGridView but when i try msdn's code(which is below) gridview is in normal size but records are very small and not in the gridview. How can i print dataGridView with records as seen in form private void printDocument1_PrintPage( object sender, PrintPageEventArgs e) { PaintEventArgs myPaintArgs = new PaintEventArgs (e.Graphics, new System.Drawing. Rectangle ( new System.Drawing. Point (0, 0), dataGridView1.ClientSize)); this .InvokePaint(dataGridView1, myPaintArgs); } private void bYazdir_Click( object sender, EventArgs e) { printDocument1.Print(); } thanks friends but, when i try to use Uglydragon79's solution, if data is lo ...Show All

• SQL Server How to Manage Errors with one file

  Hi, I am pretty new in SSIS 2005, and I have some problems... I want to add logging and error management in my package. I found how to made logging. But for errors managing i have some difficulties. In my package I have only a flat file source and an ole db destination. I want add errors management for both of them. So I create a connection manager for errors on a file. For both element i add redirect row for all available error type and then i add 2 flat file destination. I branch red arrows of flat file source and ole db destination to the flat file destination. When i run packge i have an error which indicate me that file error is already take by another process... I don't understand why. And i don't want to create on file for ...Show All