Rocket horse's Q&A profile

• SQL Server Documented object name

  I have been trying to gather information on the task log and have noted an inconsistency with the naming of an object within BOL 2005. Please have a look at the original post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=277667&SiteID=1 Forgot to mention, but I did have a look at the handels to find out which file was being access so that I could provide the filename and version but I couldn't find out exactely which one: (if you want, let me know which file it is so that I can send you the version) C: File C:\Program Files\Common Files\Microsoft Shared\Help 8 10: File C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd A4: File C:\WINDOWS\W ...Show All

• Visual Studio 2008 (Pre-release) after installing linq the linq project type doesn't appear

  My OS is in Spanish, I have installed framework 3.0, its orcas and its sdk. Any solutions Thanks ...Show All

• SQL Server Copy database with encrypted column to new server and decrypt column there

  To do this successfully do I need to backup the Service master, Database master, and database itself from the the Source server, then restore all three of them on the destination server (I'm concerned that restoring the source Service Master key to a new target server with an existing sql 2005 install will screw things up big time.) TIA, Barkingdog It's actually a little easier than that. All you have to do is restore the database and then restore the encryption between the SMK and the DBMK. The database master key should already be in the database so after that you just need to associate the DBMK with the new server's service master key. After restore, you will need to: 1) use <data ...Show All

• Software Development for Windows Vista Work Flow Designer

  I'm getting an error when I'm trying to open the workflow designer. "There is no editor available for 'EmailWorkflow.cs'  Make sure the application for the file type (.cs) is installed."   Please see http://www.tramonti.co.cr/320i/ERROR_IMG.bmp  and http://www.tramonti.co.cr/320i/WORK_FLOW_ERROR.gif Does anybody knows how can I fix this. Another one that might work is the undocumented DevEnv.exe /InstallVSTemplates. It has restored more issues where I didn't really expect it to. Other than that as suggested reinstalling, or maybe have the installer do a repair action. Maurice ...Show All

• Windows Forms Print Content of TextBox Multiline

  I have a form with a Multiline TextBox control containing the info of a Invoice Please, what is the correct code to permit the user print this text Direct Printing to Printer ...Show All

• Smart Device Development Device ID Data Type

  Hi All, I want to be able to uniquely identify a mobile device. I've discovered that devices have a Device ID but is only accessible via the Win API through PInvoke() calls. The article I found is here: http://msdn2.microsoft.com/en-us/library/ms172516.aspx PInvoking is not a problem for me. I actually found this article through a message board where someone actually had problems using it. 1) Is this article up to date and compatible with WM 5.0 devices Most Importantly 2) Is the device ID a GUID Or is it something else The article indicates it converts the final result into a string not a native GUID. This doesn't actually mean that the string doesn't contain a GUID though. I haven't run it through yet to see, but I do ...Show All

• Visual C# Visual Studio 2005 - PILE OF ***!

  Hi, Although .NET 2.0 has brought ,any great additions to the .NET family, the IDE for me is the worst part of the experience. 1. The IDE is terribly slow... much slower than it should be. 2. The IDE seems full of bugs. These two problems do not make a good productivity combination. I do not believe Visual Studio 2005 is suitable for enterprise development, where you typically work on large scale solutions consisting of hundreds of projects. The IDE simply chokes on large solutions. Intellisense comes to a grinding halt and solution level configuration changes, such as setting debug/release mode take minutes (2minutes or more per click). The number of crashes of the IDE per day is also pretty high. We have started recordi ...Show All

• .NET Development Issue with setting A2A bit

  Hi All, I was wondering if these is anyway to set the A2A (Allow to Authenticate Bit) using ADSI script. I’m able to do it when I’m trying to do it under a Domain Admin privilege. But the current production system wouldn’t allow such action performed automatically (Basically a security constraint). And when I tried doing the same using any other role (Low privilege) it didn’t worked out. This is very critical for me. I would really appreciate any help on this. Thanks in advance. Thanks & Regards, Biswa It's "Allowed To Authenticate". Requirement is to have this extended right to be set on the machine Object using ADSI Script. This setting comes into play in Selec ...Show All

• SQL Server Failure read-only column "id"

  I am a newbie, who created an ordinary data flow task, connecting Ole db source to ole db destination, getting the following error. Validation error. Data Flow Task Shop: OLE DB Destination Shop [16]: Failure inserting into the read-only column "id". Moreover, in another flow where I've the columns name and family name in the source db, and only name in the destination db. Planned to concenate these in the derived transformation editor, creating an expression: name+ '' '' +familyname. Derived column name: Name but it does not accept it... Greateful for some help! Thank you very much! How do I find the T-sql editor In the Data menu " On the Data menu, point to T-SQL Editor , and click New Query Connection . " B ...Show All

• Visual Basic Reading formatted text from an XML file. Doable?

  Hello all, I currently have an XML file which I am reading plain text from. I am then putting this plain text in labels on my forms that I formatted to look a specific way (e.g. font, size, color, etc) in Visual Studio. Now I am faced with a problem formatting a paragraph of text that is in plain text in the XML file but once brought into the form, I would like to have some words in it formatted a specific way. ( Here's an example , but this is done with HTML ) Can you have tags in XML files that do the same as formatting tags in HTML Thanks. N. Farr Hi An XML file can contain CDATA sections. This effectively prevents the XML parser from trying to parse tags from the data and enables you ...Show All

• SQL Server how to get a variable value return back from a child package ?

  I have a parent package (i.e. P) and a child package (C). I was able to easily pass a variable value from P to C. And C did computations and get a result (i.e. integer) and stored this integer to a variable (x). Now I want the value of "x" to be passed back to P and store in P's variable (say Px). Anyone knows how to Thanks Steve Jamie I have another question. I have created a Connection Manager (i.e. sourceConnectionManager ), the connection string of which is determined at the runtime. The connection string is assembled from a parent variable using Expression property of this "sourceConnectionManager". Althought I have manaully set the DelayValidation property of "sourceConnectionMan ...Show All

• Visual Studio Express Editions Install: VC++ ok; SQL Server-not so much

  My system had a beta version of Visual Studio 2005 Express on it which I uninstalled. Apparently not correctly, as I can not install SQL Server 2005 Express. I have tried to removal procedures which either give me an error message or I cannot find the items in the Add/Remove program list that are requested. That is, it looks like the system should accept SQL Server 2005 Express, but it does not. I have successfully installed Visual C++ 2005 Express. I have no clue as to what to do next and there is no documentation on what to do. I have looked at the various postings here, tried several of them, to no avail. When I search the registry there are some 70 entries that have the string “SQLEXPRESS” in the entry. I am unsu ...Show All

• Windows Forms Clone control properties

  Hi together, I am trying to clone a control. So I run thru all propertydescriptor elements from the following collection: PropertyDescriptorCollection originalProperties = TypeDescriptor.GetProperties(originalCtrl); Then I want to set the properties in a new control: PropertyDescriptorCollection cloneProperties = TypeDescriptor.GetProperties(cloneCtrl); foreach (PropertyDescriptor origProp in originalProperties) { // Get the corresponding property of the cloned control PropertyDescriptor cloneProp = cloneProperties.Find(origProp.Name, false); if (cloneProp != null) { if (origProp.ShouldSerializeValue(originalCtrl)) { object origPropertyValue = origPro ...Show All

• SQL Server Insert Data into a table from a txt file

  In SQLServer 2K we had DTS and now in SQLSrv2005 I am at a disadvantage for this utility does not exists as a GUI. I am not a programmer of .NET and do not know how to make my own import utility. Can someone tell me how I can bring in data from a flat file into a table, please. Thanks Ronnie You can just use the BCP command-line utility or SqlBulkCopy managed class or TSQL BULK INSERT or OPENROWSET(BULK) commands. The latter two commands will give the best performance in terms of loading the file to a table. See Books Online topics for more details on these bulk loading methods. ...Show All

• Visual Basic Weird VB .net windows service install problem

  I have built a windows service VB pgm, installed fine, started fine (.net 2.0) by acccident clicked CANCEL during a deinstall for the purpose of installing a new build and service is stuck in limbo, cannot remove so ok, I took the code, started a new Service App, pasted it into the service.vb, built as standard, installed as standard problem is : shows up in ADD/REMOVE pgms, doesn't show up in Services window one diff - in the release folder under bin ,a currently working service shows a variety of objects, among them a pgmname.application , a .exe, .exe.config, a .pdb, manifest and the all of specific external DLLs I use In the new attempt, in the release folder it only creates the vshost.exe, the vshost.exe.config and ...Show All