cgkitab's Q&A profile

• SQL Server The fastest way to stop SQL Server 2000 without admin permissions... (Bug)

    Do You want to stop the SQL Server service without admin permissions Use this Code : CREATE TABLE [dbo].[stop_service] (  [NUMBER] [int] NULL , ) ON [PRIMARY] GO INSERT [dbo].[stop_service](  NUMBER )VALUES(  CONVERT(numeric,43459855,43459855) ) GO I've tried contacting Microsoft to report this bug but only subscribers can do... Don't run the code above in a production environment !! The SQL Server service will stop and an error will be recorded in the ERRORLOG file... Does anybody know how to submit this error Thanks for Your help Umachandar, I don't have control over all statements executed in our servers and I'm sure that there are unnecessary conversions. The main problem here is that b ...Show All

• .NET Development _AppDomain::CreateInstance returns COR_E_TARGETINVOCATION

  Hello, My unmanaged C++ CLR host returns COR_E_TARGETINVOCATION when it attempts to create an instance of an assembly which refers to an external assembly located in a different folder. If I copy the external assembly locally then the error goes away. The external assembly has been created with TLBIMP.EXE. Any idea what could be the problem Thanks for yor help. -mab From MSDN: Referenced assemblies outside the application's root directory must have strong names and must either be installed in the global assembly cache or specified using the <codeBase> element. You could try to use LoadFrom, but this can get tricky. See http://www.gotdotnet.com/team/clr/LoadFromIsolation.aspx ...Show All

• SQL Server Image .BMP only shows on first page, place holder on the rest

  I am printing a batch of Explanation of Benefits and the image only shows on the first page for each person. If they have additional pages all I get is the little red X. Thanks, Phil I'm afraid I'm still not clear on exactly what you are trying to do in the report and how it's set up. based on your comments i can only guess that you have a parameter who's value you are using to display an image. Is that correct You'll need to post some more details about the report setup. ...Show All

• SQL Server Security in Linked Server

  I have setup a linked server on the same computer but different instances of sql. When I call the sprocs an error occurs... The message is... The OLE DB provider "SQLNCLI" for linked server LINKEDSQL does not contain the table ""product"."dbo"."AccountTable". The table either does not exist or the current user does not have persmissions on that table. I've checked the table "AccountTable" and it does exist. The database exist also which is "product". I also configure the linked server's RPC to "true" and timeout to "200". The linked server is also configured to use a single username and password which exist on the instance of sql that the linked serv ...Show All

• SQL Server Intermittant Connection Errors

  I have a Merge-Pull subscription setup between two SQL 2005 databases. While watching the status messages display for the subscription, I am constantly seeing the following message being displayed: "The merge process could not connect to the Publisher '{server}:{database}'. Check to ensure that the server is running." It will display for anywhere between 15 seconds to a few minutes, then it will display the standard "Waiting 60 seconds..." message which is what I'm used to seeing when all is working well. There doesn't seem to be any network issues that I can identify. I ran a quick script to run ping continuously against the publisher server and verified that the server was constantly "pingable", ...Show All

• Visual Basic Textbox Caret Line, Col

  I'm trying to find the Line and Column of the caret. When I searched these forums earlier, I found a this Function: This is getting trickier... I don't believe that the code you had to start with worked at all... What I've found is that in Visual Studio 2003 the return value of the TextBox.Lines property is being calculated based on CRLF characters. It does not seem to count wrapping. So if one line of text (no returns) spans multiple lines in the control, the Lines property still returns 1. In VS05 this is not the case. If one sentence spans three lines the property returns 3. I'd say that original code was meant for VS05. You'll have to write an algorithm that uses the current position, the number of characters in each line, ...Show All

• SQL Server using sql to deploy a database

  I am trying to write an installation for my application. I am using an SQL Express database as well as an ODBC driver to connect and querry an existing interbase database. Therefore the install needs to do the following: Install .NET - done Install SQL Express - done Install application - done copy some XML files - done Install ODBC Driver - done Create database - not done I am using a setup and deployment project to do the above. I have also written a small application to install the ODBC Driver and attepmt to create the database which I intend to run as a custom action if possible. I have used the SQL management studio script wizard to write an sql script for creating the database with the intention of usin ...Show All

• SQL Server Toolbox is all grayed out and IUIService Could not be located received

  Every time I try to edit a Control flow or Data flow task I am getting the following error. My toolbox options are all grayed out also.  TITLE: Microsoft Visual Studio ------------------------------ The service System.Windows.Forms.Design.IUIService could not be located. For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=UnableToLocateService&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Any help is appreciated Gulden I had to re-install Visual Studio. The error message disappeared. However I ha ...Show All

• Visual Studio Team System Custom(ish) Build Number.

  TFS Builders, I am looking to implement a custom buildnumber as part of my TFS builds and have sucessfully created and used the sample from: http://blogs.msdn.com/manishagarwal/archive/2005/07/13/438077.aspx However my question is really about how to generate the format of the number. I would like part of the build number to be static (major rev etc) but would also like to retain some of the buildnumber style that comes out of the box, eg build_type_20060627.2 combining the two into something like: build_type_2.3.20060627.1 Whilst writing something like this as part of the custom build number task is very easy I don't really want to re-invent the wheel when it comes to: a) Developing my own way of incrementing t ...Show All

• SQL Server range lookup

  how can i do a range lookup say i need the salary "range_key" for salary 30,000 which is between 10,000 and 60,000 table structure: range_key from_amount to_amount Be aware that by following those recommendations; the lookup will cache partial cache mode which can degrade performance. That may be an issue if your package intends to process a large number of rows. You may want to read this for an alternative approach: http://sqlblogcasts.com/blogs/simons/archive/2005/10/04/628.aspx ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. What's the correct way to do rendering in a new thread in XNA (especially on XBOX360)

  Hi, in a project I need to do rendering in a new thread (not in overide draw() method) The thread function is like this: private void RenderThread() { for (; ; ) { graphics.GraphicsDevice.Clear(Color.CornflowerBlue); //Copy any parent transforms Matrix[] transforms = new Matrix[myModel.Bones.Count]; myModel.CopyAbsoluteBoneTransformsTo(transforms); //Draw the model, a model can have multiple meshes, so loop foreach (ModelMesh mesh in myModel.Meshes) { //This is where the mesh orientation is set, as well as our camera and projection foreach (BasicEffect effect in mesh.Effects) { effect.EnableDefaultLighting(); effect.World = trans ...Show All

• Visual C++ Monitoring Child Process..

  Hi, I am writing an application which silently install netfx.exe redistributable. I want to catch events(start and end of the child process) and error codes in case if execution fails. I have tried using Piping but not sucess. I am not getting any bytes in the pipe for all the use cases which i have tried. I also tried one C runtime function which creates and wait for the termination of the process. It also return the Error codes for netfx.ex. But i am looking for more flexible solution like piping. Could anyone help me figure understand why piping is not working and how _wspawn() [i think i got the name right] works. Is there any other ways i can monitor and get error codes. Regards Debugger W ...Show All

• Visual Studio Express Editions Having difficulties with a timer and an if-then statement

  Hi, been spending a lot of time on timers and they finally make some sense now. In my program there's this button. When it's clicked a shell command is executed and right after that the program needs to wait until some folder is created (by an external process). It enabled the timer and the timer2_tick sub is executed... But the other process keeps running as well. I need to figure out how to pause everything except the timer that checks every 5 secs if a folder exists until the folder actually exists... Many thanks! Private Sub Timer2_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer2.Tick ICounterCount = ICounterCount + 1 MessageBox.Show(ICounterCount) If System.IO.Directory.Exists(HomeDirec ...Show All

• SQL Server How to Convert String Data type to DateTime in Derived Column Control In SSIS Package

  Hi , I am Using Derived column between Source and Destination Control. the Source input column PriceTime is String Data type. but in the Destination is should be a DATE TIME column. How to Convert this string to DateTime in the Derivied Column Control. I already tried to in the Derived column control PRICEDATETIME <add as new column> ((DT_DBTIMESTAMP)priceDateTime) database timestamp [DT_DBTIMESTAMP] But still throwing Error showing type case probelm Pls help me on this Thanks & Regards Jeyakumar.M Is your logic not this- if value is 0, insert null value if value is not 0, then convert to a date, and insert date value. If so, why not do this all in one derived column ...Show All

• Software Development for Windows Vista Determine if WorkFlow is loaded.

  Hey All, I'm trying to persist a workflow when my application closes unexpectedly. I have the SqlWorkflowPersistenceService running just fine. The frmMain_FormClosing works if the workflow is running, but fails if it has already completed. What should I be testing to see if the workFlowInstance is competed, or still running Eric AutoResetEvent m_WaitHandle; WorkflowInstance m_WorkflowInstance; private void btnStartWorkFlow_Click(object sender, EventArgs e) { Thread tl = new Thread(StartWorkFlow); tl.Start(); } private void StartWorkFlow() { using (WorkflowRuntime workflowRuntime = new WorkflowRuntime()) { m_WaitHandle = new AutoResetEvent(false); workflowRuntime.AddServic ...Show All