Matty1stop's Q&A profile

• SQL Server Optins of trailing Database change in sql server

  Hi All, I am in need of some option using which i can trail the changes made to my database. Specially i want to track all the DDL and DMl changes. I know about the external tools provided by lumigent and some other companies to do this but i was just wondering if we have some option within sql server. I don't need extensive report as provided by lumigent. Just getting somethin on DDL and DML will help.  Even help on some work arounds to do same will be appreciated. TIA Prashant   Hi , Currently i am using "DDL triggers for the creation of database objects". Which is working perfectly fine for me. But creating trigger on each and every object in a database having more than 300 ...Show All

• Software Development for Windows Vista ActivityTrackingPoint / ActivityDataTrackingExtract

  I have created a very simple Tracking Profile for my workflow as attached below. I am trying to track on Public properties from my Activity, yet when I run an instance I get an error saying it is unable to find this property on the actualy Workflow instance. eg. it will say cannot find "SampleWorkflow.Property" when I expected it to look in the current activity for the properties, not at the Workflow instance level - Does this make sense to anyone else < xml version="1.0" encoding="utf-16" standalone="yes" > <TrackingProfile xmlns=" http://schemas.microsoft.com/winfx/2006/workflow/trackingprofile " version="1.0.0.0"> <TrackPoints> <ActivityTrack ...Show All

• Windows Forms Need to abort uninstall based on user input

  Hi, I am creating an MSI using Visual Studio 2005, setup wizard. the install and uninstall are done silently. One of the uninstall custom action is to stop a service (using a VB script, i basically open up a shell and execute a net stop), the service name is given as parameter of the silent uninstall, i want to be able to abort the uninstall if the service name is invalid or null. Any suggestions Thanks Dinesh it is not just stopping the service that is the key, there will be a bunch of custom actions thereafter. so i would not want any of them to run. one way would be to check for that parameter in each action and not perform them in the case where the service name is invalid, but what i was trying to ...Show All

• Visual C++ Where are wizards for ATL projects in VS2005?

  Hi all..... I have created a Windows Service using ATL. That wizard created several files, among them, the IDL file where I can place interfaces. Is there a wizard to add an interface in a fast and easy manner such as VC++ 6.0 ATL wizards. Thanks Jaime Hi Jamie, just right click your project and select Add->Class... You will find ATL class wizards. E.g. the ATL Simple Object which will create a coclass and interface. Form the Class View window you can open the context menu on the new interface and add methods or properties. -- SvenC ...Show All

• .NET Development SqlBulkCopy: the locale id '0' of the source column '<column name> ' and the locale id '1033' of the destination column '<colum

  Hi, I am using the sqlbulkcopy object to transfer large amount of data from one SQL server to Other. The code look like this.. SqlDataReader readerSrc = null ; SqlBulkCopy bulkCopy = new SqlBulkCopy (connDest); //Prepare Destination Table. SqlCommand cmdDelete = new SqlCommand ( "DELETE FROM " + destTableName, connDest); //Set the sqlcommand text SqlCommand cmdGet = new SqlCommand ( "SELECT * FROM " + srcTableName, connSrc); //Open source connection. connSrc.Open(); //Open destination connection. connDest.Open(); int delete = cmdDelete.ExecuteNonQuery(); //Get the data. readerSrc = cmdGet.ExecuteReader(); //begin transfering data to destination bulkCopy.DestinationTableName = destTableName; bulkCop ...Show All

• Windows Forms notify icon

  I have a form and a notify icon related. How can i minimize the form and only the notify icon to be dislpayed You can minimize the form by using this code:  this.WindowState = System.Windows.Forms.FormWindowState.Minimized; or if you don't want the form in your taskbar, you can use form.Hide(); ...Show All

• SQL Server Weird timeout in CLR stored procedures that use FtpWebRequest / Response....

  Hi all, This is a problem for that I lost a weekend to reach to this conclusions: Here is the scenario: I need a file downloaded from a FTP server on my SQL 2005 DB Server to process it in several ways. This file is tens of MBs (let's say 50MB). I set up a CLR stored procedure to bring it locally on the machine. Inside this procedure, call it getFtpFile, I use the FtpWebRequest to issue the commands I need to the FTP server (get the file size and download the file). For reading and writing I use a StreamReader sr and a StreamWriter. sw I read the remote file in block with: sr.ReadBlock(buf, 0, blockSizeBytes); Everything work file until the last block that, most probably will not be of size blockSizeBytes, but smaller. So, what happens is ...Show All

• SQL Server Issues with privileges

  I am having trouble with providing the minimum security to a user. After issuing the following: GRANT EXECUTE ON SCHEMA :: DBO TO skillsnetuser ; I test the permissions with exec as login = 'skillsnetuser' exec prcElmtList 1 , 1 , 102268 revert ; and receive this message Msg 229, Level 14, State 5, Line 2 SELECT permission denied on object 'Org', database 'SNAccess_Dev', schema 'dbo'. The principal that owns the dbo schema is dbo and is the principle for all procedures and tables in that schema. What can I do to shed some light on what is causing this access problem My first guess is that ownership chaining is broken for some reason. Can you p ...Show All

• Gadgets xmlHttpRequest on Vista Home

  I have utilized xmlhttp on many occasions to power ajax enabled projects and have never had a problem with it until now. The following javascript code is debugged and runs flawlessly in IE7, but does not work when installed as a gadget. Is there something in here that gadgets do not support but IE7 does function GetXmlHttpObject(handler) { var objXmlHttp=null; var strName="Microsoft.XMLHTTP"; try { objXmlHttp=new ActiveXObject(strName); objXmlHttp.onreadystatechange=handler; return objXmlHttp; } catch(e) { alert("Error. Scripting for ActiveX might be disabled"); return; } } function showDisplay() { var url=" http://www.ourwebsite.com/phpscript.php variable=one"; xmlHttp=GetXmlH ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Simple Mesh Move...

  I'm working with DX9 in vb.net. I have looked all over for a simple way to move a mesh, not the camera, in a scene. I will have multiple meshes. I'm loading the mesh this way: Any quick solutions fellow developers Thanks to all! model = createMesh(Application.StartupPath & "\tomtom.x", True, True, Application.StartupPath) Function createMesh(ByVal fileSrc As String, ByVal materialOn As Boolean, ByVal textureOn As Boolean, ByVal TexPath As String) As oggX 'create an oggX structure from file defining file path, if use material and texture and texture path With createMesh 'create a mesh Dim materials() As ExtendedMaterial .mesh = Mesh.FromFile(fileSrc, MeshFlags.Managed, device, materials) 'memo ...Show All

• Visual Studio Team System Deleted AD resource causes publishing error

  We had a user leave the company who had tasks assigned in Team System. The next time we published the Project we got a publishing error and had to reassign all the tasks to an active resource. Project Server is able to gracefully recover from this type of event...Team System should also. Doug, Thanks for the feedback. Were you expecting all tasks for that user to be automatically assigned to Active Consider the scenario where you want to know what tasks were assigned to the user who left the company and then load balance them across other users. Wouldn't it be easier to accomplish this with the current design Instead, if we automatically assigned all these tasks to Active, you'd have to manually updat ...Show All

• SQL Server error with datetime datatype

  Hi Guys, I'm having problem in loading textfile into the database. One of the columns in the textfile has a datetime datatype. Here is a sample of the text file. All the other columns are string except for the datetime: "5/4/2006" "1","1","ITEM","5/4/2006","10:05:04","11110",10004,"Regular Half Chicken",1,130.00,0,0 Error is shown below. Error: 0xC0202009 at Data Flow Task, OLE DB Destination [154]: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification". Error: 0xC020901C a ...Show All

• Software Development for Windows Vista About Windows SDK's Installation's Issue

  Hi, Today I tried to setup 'MicrosoftR WindowsR Software Development Kit for Windows Vista and .NET Framework 3.0 Runtime Components', but it fails. The operating system is Win2003 Enterprise with SP1. The date published of .NET Framework 3.0,which was already setupped into the computer, is 11/21/2006. The computer was also setupped about .NET Framework 2.0, .NET Framework Compact Framework 2.0, .ENT Compact Framework 1.0 SP3 Developer and so on. How can I solve this issue Thanks. The installation log file's content is: 15:35:02 2006年12月10日: ------------------------------------------------------------------------------------------------- 15:35:02 2006年12月10日: [SDKSetup:Info] Begin 15:35:02 2006年12月10日: [SDKSetup:Info] S ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Game State Class - Sharing Information

  I'm using the default XNA game template for the time being, as I'm not intimate with C# yet. I'm trying to set up a game state stack, using a class derived from the game class. The GameState class has UpdateMe and DrawMe functions that basically call protected methods Update and Draw in the Game part of the inherited class. I also have a gameState handler class that has a stack of GameState objects that it keeps track of, etc. If I use this encapsulated method of game states, how do I share information between game states. For instance, if I have a menu screen that shows character info, how do I share the character's stats between the main game state and the menu state. I figured using static class members was a bit crude, but I'm unsure o ...Show All

• Visual Studio Team System 500:Internal server Error

  On recording an application which passes an encrypted value as an query string parameter and playing back the application I am getting an 500 internal server error.How can this error be resolved.There is no such error displayed on running the application from the web browser but this error occurs only when I record and play back the script. Thanks, tester ...Show All