mitasid's Q&A profile

• SQL Server 'sys.sp_dbcmptlevel' can only be executed at the ad hoc level

  hi i want to change the Compatibility level of the database(currently in use),autocommit is ON as EXEC sp_dbcmptlevel DM, 90 (OK in SQL-server 2005, no error) Now when execute this command in my application(build using Centura) throws error as   Microsoft SQL Server:15432[Microsoft][ODBC SQL Server Driver][SQL Server]Stored procedure 'sys.sp_dbcmptlevel' can only be executed at the ad hoc level.  I check the docs, what i find this Error comes only if u try to execute this in other procedure or uncommited Transation. there is no such thing i already checked that then What this error mean any hint Gurpreet S. Gill         The problem is this part of ...Show All

• SQL Server ADO find method too slow, how should I do this

  I need an efficient way to get the absolute position of a record in a query matching a specific key value. The Find method is a serial search, too slow for big data sets. I am using both SQL Server Express and Jet 4 via ADO. One example of why I need this ..... I have a list control with a subset of a table (controlled by where clause in query). I want to save the current state of the list control and later restore it when the app restarts. I want to preserve and restore the current line selection in the list control. So, I save the key value for the current line, upon restart use the find method to locate the key, and set the list control current record index to the current absolute position. This is too slow for big data sets since the f ...Show All

• SQL Server Database Mirroring Setup Document.

  Hi: I am looking for a Step-by-Step document for setting up and configuring of database mirroring if one is available. I have gone through BOL and found some related documentation but want to see if a step-by-step document is available. If so can any one please direct me to the resource. Thank you AK Please look at the How-to section in the BOL. http://msdn2.microsoft.com/en-us/library/ms175059.aspx ...Show All

• SQL Server Packages error or hang in SQL Agent but not in BI IDE

  Hi , I have an issues that worries me alot. I have SSIS packages scheduled in SQL Agent and they sometime error out or hang in Agent but never when i run them in BI IDE (Visual studio). There are two particular packages that always hang, alway in Agent but when i run them in BI IDE, they run just fine. Im was running them under in Agent under type= Sql server intergration services and also tried running under type = Operating System (CmdExec). Both types have the same problem. The packages hang. The log files dont say much, because the packages hang, no logging is doing so i dont get any infomation to determin what is going on. Can someone please help me ou. is there any way i can do that without storing the packages in the db be ...Show All

• Visual Studio Team System Pass in parameter to TeamBuild

  I know that TFSBuild.rsp can be used to pass in msbuild parameters to the command line when a TeamBuild is fired, but is there any way to do this on the command line directly e.g. in my TFSBuild.rsp file I have: /p:SkipClean=true;SkipInitializeWorkspace=true;ForceGet=false this will carry out an incremental build,, but I dont always want to do it so I'd rather pass these in on the command line when using TFSBuild.exe to start a build. Is it possible We did face the same issue. But we created a file called "c:\Project1\build.option" in the build server <Propertygroup> <SkipClean>true</SkipClean> <SkipInitializeWorkspace>true</SkipInitializeWorkspace> <Fo ...Show All

• Visual C++ DLL without CRT

  Is it possible to create a dll without it's copy of the CRT, so that it would use one from the context of the calling process Not sure if we're on the same wavelength here. If you statically link the CRT to both the DLL and the EXE, you can't share the code. Each will have their own copy of, for example, the new operator. You'll have big problems if the memory is allocated in the DLL and freed in the EXE (and vice-versa). Creating a DLL that doesn't use the CRT at all is next to impossible, especially with the latest security enhancements. It will *not* use the CRT in the EXE, it wouldn't know how to find the entrypoints. Switching to the DLL version of the CRT will more than likely solve your memory problems. ...Show All

• Visual Studio Tools for Office Getting default Mso labels

  Hi, I'm sure that during developing with VSTO 2005 SE I saw somewhere functions like "getMsoLabel" and "getMsoImage"...but I can't find them anywhere now... anybody knows about them I need to get string of built-in control / group / tab... in order to handle localized versions of office... and I hope a little this functionc could do that work.. Thanks Have it! It's in Application.CommandBars. There are some difficulties in Outlook, because it is splitted to Explorers and Inspectors, but I will manage it somehow..   Thanks, Cindy.. ...Show All

• SQL Server table design question

  I am probably posting this question in the wrong area. If so, please let me know where to post this question. currently I have three tables and I will create more if needed to accomplish my task. My challenge is that I do not know how to start creating the relationships. ENTITY .ENTITY_KEY .ENTITY_NAME .ENTITY_TYPE ("P" PERSON OR "O" ORGANIZATION) ENTITY_FOR .ENTITY_FOR_KEY .ENTITY_KEY .CONTACT_KEY .ORIGINATION (CLIENT OR IN-HOUSE) .ORIGINATION_DATE CONTACT .CONTACT_KEY .CONTACT_TYPE (PROVIDER OR CONTACT PERSON) .FNAME .LNAME I am trying to keep a normlize design. Here is what I am trying to accomplish. An entity can be a person or an organization. This entity can have multiple person members. This entity c ...Show All

• Visual Studio 2008 (Pre-release) Scroll ListView to the top (reset)

  I'd like to scroll a ListView to the top (set the position of the scrollbar to zero). Why: Say I've got a ListView containing 10000 items. Now I want to clear the very same ListView and fill it with 100 Items. If the user scrolled down to the bottom of the ListView, only the last of the 100 items will be shown, and paging does not work very well for a few PgUps since the Scrollbar size still is set for 10000 items. So I'd like to reset the ListView to position zero when I refill it. I tried to if (MyListview.Items.Count>0) My Listview.ScrollIntoView(MyListview.Items[0]); but it did not help, scroll position still was down :( thanks, Sam I dont know of any other way to ge ...Show All

• Smart Device Development Virtual PC/Windows CE Emulator "A driver is installed that causes stability problems with your system. This driver will be

  I am using Visual studio 2005. I am developing Windows Mobile 5.0 smartphone application. After necessary installation when My system starts I get the following error Virtual PC/Windows CE Emulator A driver is installed that causes stability problems with your system. This driver will be disabled. Please contact the driver manufacturer for an update that is compatible with this version of Windows . Contact Information: Web Site: http://go.microsoft.com/fwlink/ LinkId=26320 Resolution is to alter boot.ini But I think This will lead to unstable the system. Could There be any other resolution [Like Patch or something else] for this problem I have the following line in my boot.ini multi(0 ...Show All

• .NET Development Looping Through Some Files

  I want to loop through all of the ".ent" files in a folder. I know I need to use the "foreach" statement, but I can't get it to work. string[] files = Directory.GetFiles(directoryPath,"*.ent", SearchOption. SearchOption.AllDirectories); // Directory and All Child Directories.. foreach(string file in files) { /////// Code Here.... } string[] files = Directory.GetFiles(directoryPath,"*.ent", SearchOption. SearchOption.TopDirectoryOnly); // Only the Specified Directory foreach(string file in files) { /////// Code Here.... } I hope this will help. Best Regards, Rizwan ...Show All

• Visual Studio 2008 (Pre-release) Object[] parameter become null

  Might be a silly question but i do need some ideas. I have a object class Track which mark as [DataContract] , everything is fine when all the OperationContract are operate with Track object. things went wrong when i pass Track[] as parameter and it becomes null at the other end. is that i need to do something with the Track[] if so, how thanks a lot you'll need add [ServiceKnownType(typeof(Track))] or maybe even [ServiceKnownType(typeof(Track[]))] on top of your operationContract becaues if your operation contract takes object, serializer won't expect track[] and would think that's some new parameter added by V2 client and just ignored it. ...Show All

• SQL Server Could not load file or assembly 'Microsoft.Data.Odbc...

  I have developed an application in C#, and it uses both a SQL server database, and as part of its operation it opens up a Foxpro database. I am using Odbc to connect to the fox pro database and everything wortks just fine on my devleopment machine. However when I deploy my application I am getting the following error text when ever I create the form that does the Odbc work. ************** Exception Text ************** System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Data.Odbc, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.Data.Odbc, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c56193 ...Show All

• Windows Forms How do I animate a button click from code?

  This code preforms the button2 operation with button2.PerformClick(), but the user has no indication that button 2 has been clicked. How do I get button2 to go down and back up public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button2_Click(object sender, EventArgs e) { Console.WriteLine("button 2 was clicked."); } private void button1_Click(object sender, EventArgs e) { button2.PerformClick(); } } Thank you B14 public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button2_Click(object sender, EventArgs e) { Console ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Load a Mesh

  I get this error when I try to load my Mesh: Error 17 Node has more than one BoneContent child. Unable to determine which one is the skeleton root. C:\TorqueX\xna\test\MeshLoader\MeshLoader\3D Models\Elvira_1P_L01_01.X MeshLoader Is this something that I can fix with code or something that the 3D team need to fix Here is the draw function: protected override void Draw( GameTime gameTime) { 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) { ...Show All