Kevin Rodgers's Q&A profile

• SQL Server Moving database from one Server to another

  I am sorry for such a basic question. But i have done a search and the answers dont seem to be relevant in my situation I have two servers with the same setup where the sql is installed in default C/programme and the db is in D/some folder So the file structure is the same Back in SQL 2000 days the transfer was so painless, where I made the DB offline and transferred the main db.mdf and log to the new server and i attached it to the new sql server in the new server. Now this process does not work. I have tried the old method and it says something like you should do it with Move or something. I transfer the back up and try and restore and it says that it is read only. Surely things should get easier with sql 2005 or sql ...Show All

• Visual Studio Express Editions open a file

  hi guys can someone please tell me how to open a text file in my application it is named .....contacts.txt it is stored in notepad.... and I find these help files absolutely useless... I want to click a label to open this file.....either by opening notepad. or to open in my form thanks cheyenne If My .Computer.FileSystem.FileExists( "d:\temp\test.txt" ) Then TextBox1.Text = My .Computer.FileSystem.ReadAllText( "d:\temp\test.txt" ) Else ' do something else End If ...Show All

• Visual C# Is it safe to remove a delegate inside its delegated method?

  This sounds a bit strange but it's a real world problem. Say I have an event Disposing and a method F() handles that event. obj.Disposing += new EventHandler(F); ... void F() { ... obj.Disposing -= new EventHandler(F); } Here's the problem, F() is going to remove itself from the invocation list of the Disposing event right at the time it's invoked. I don't find a statement for this in the spec. So could anybody tell whether this is designed to be safe or not guaranteed Thanks in advance. Can't be any possibility that he wrote this post wrongly And by the way I did not answer after his last answer... Also I can assume that he uses WinForms forums (Is there any rule that you cant assume anythi ...Show All

• .NET Development How doesThreadPool really work?

  Dear folks, I wonder how to use properly the pool multithread that Framework bring us with the 2.0 version. My goal is to reach three threads running at the same time (as a maximum) and when comes the four one whether are running the previous ones, do a sleep until find a place for that. My schema is the following: If icont > 3 Then If Thread.CurrentThread.IsAlive Then **** This is a four one T_GestorHILOS.QueueUserWorkItem( New WaitCallback( AddressOf PruebaVarios), objeto) ****I wonder about this suspension.. It affects the third or fourth Thread.CurrentThread.Join() icont = 1 End If ...Show All

• Visual Studio 2008 (Pre-release) Security permissions for xbap still failing?

  I have an xbap that makes calls to a class library I created. I've set the class lib to allow trusted callers. However, whenever I call a method in the classlib I still get a security exception: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. This happens at my method at MyLib.ColorFinder(BitmapSource bmSource, Int32Rect rect) All I am trying to do there is look at some colors in a BitmapSource. I'm not accessing any external data or network shares. Why doesn't this play nice in the sandbox All I am doing is using some properties of the BitmapSource to look at the pixels in ...Show All

• .NET Development Best method to insert the content of an XmlWriter into another XmlDocument?

  I have an XmlWriter stored as a MemoryStream. I would like to insert it into an existing XmlDocument. So far I have loaded the XmlWriter into its own XmlDocument and then imported the nodes into the existing XmlDocument. Is there a better way using XmlDocument of doing this Thanks, Tad p.s. I have used the CreateDocumentType (see below) in my code but it appears incredibly slow. Is there a faster method of creating the Document Type element When I tried it on my XmlWriter it raised an error. xmldoc.AppendChild(xmldoc.CreateDocumentType("svg","-//W3C//DTD SVG 1.1//EN","http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd",null)); Sergey, My goal is to generate an SVG ...Show All

• Visual Studio Express Editions VB 2005 - dataset copy

  Hi, I have a dataset and I'm using it to display information on a datagridView. When I want to filter this dataset to search for rows, I don't want to change what is displayed on the datagridView. To make a copy of this dataset seems to be the appropriate solution, but I have my doubts: I'm using the TableAdapter querys to fill my dataset (FillBy...); Can I create a new dataset for the same connection and the same tables for the same datasource (mdb file) ; Using the TableAdapter querys is indeed the easyest way to preform the querys I want, I cannot make a copy by code and still have TableAdapter querys, can I Can someone help Thanks, Pedro When your DataGridView.DataSource is ...Show All

• SQL Server Alternating Lines for multiple groups in a table region.

  I have created a report that has two groups. I want to have alternating colors on the inner group. When I use the following expression: =iif(RowNumber(nothing ) Mod 2, "Red" , "WhiteSmoke" ) it does not work and I do no get my alternating lines. If I replace 'nothing' with either the name of the grouping or the table region name, I still do not get the lines alternating. Can you suggest how I may be able to solve this problem. Thanks YOU have to specify the group name within the group to make use of the alternation within the group: =iif(RowNumber("YourGroupName" ) Mod 2, "Red" , "WhiteSmoke" ) HTH, Jens Suessmeyer. --- http://www.sq ...Show All

• Visual Studio Express Editions Backing up registration possible?

  I just wonder if it would be possible to backup my current registration I had to reinstall my computer already twice since I got VB 2005 Express Edition and booth times I had to re-register the product. My Registration Code did not work (on the same computer). It does not really make sense to re-register in cases like that! Isn't there a way to keep my old registration Maybe the export of a registry key would make that possible Well, I guess MS wouldn't make it that easy, would they Nope, I had to restore my system and reinstalled VB 2005 Express. Then I tried to use the same serial# I received on first registration. Sounds like I will 'consume' a lot of serial numbers then because of I reinst ...Show All

• SQL Server Issues with SMO Transfer

  I am trying to come up with a way to copy a database from one server to another. I have been running tests using the Transfer method from SMO. I can make it work in some cases and not in others. Currently I am trying to copy a database and am getting an error in a script to create a View. This View is the first one in the list of views from the source database. The problem appears to be that this View refers to another view that has yet to be created in the new database. Is there a way to handle this kind of dependency or is this a limitation to the Transfer method. I was hoping to avoid having to do that. The odd thing about this issue is when we create our database from scripts generated from DB Ghost and then attempt the transfer ...Show All

• Visual C# Unable to debug C# solutions

  I'm using Visual Studio 2005 Pro. This problem is repeatable with archived code on backup discs as well as new solutions. When I attempt to run my apps in Debug Configuration with breakpoints, I get the message: the following module was built either with optimizations enabled or without debug information. D:\Programming\Solutions\******... To debug this module, change its project build configuration to Debug Mode. To suppress this message, disable the 'Warn if no user code on launch' debugger option. Here's a screenshot . This is done with a brand new solution. File > New > Project > C# > Windows/Windows Application > Ok > Build > Run. [update] as par this thread , I've tried restoring factor default settings.  ...Show All

• Visual Studio Team System Checking in VS.Net 2003 solution

  I am using .Net 2003 with the TFS source control provider. I don't know if they behaviour I am noticing is specific to 2003 and the source control provider or if it happens in 2005 as well. When I have multiple changes in several projects within my solution and I then want to check-in all the changes I do so by checking in at the solution level. What happens is that I get prompted to check in changes for each individual project. The net result is that I have several changesets created (one for each project). Obviously this is not ideal. Is this a problem with the provider or does this happen in 2005 Any ideas what I can do to get around it Will checking in with Team Explorer work (I prefer to check-in via Visual studio because I am never q ...Show All

• Visual C++ openning a ms word document and reading its contents

  Hello I want to read a ms word document into my MFC program. how can I do that when I search openning a word document, "word automation" examples and informations come. however, I simply need to read a word document's content. s there a way to do it simply if so, how I will be very thankful for any reply! Note: there may be any topic about this problem, but I could not find it and it is very urgent! thanks... hello For such questions there is a better place that you can get better served and more valuable response, I'd recommend you to post it in one of newsgroup listed here: http://msdn.microsoft.com/newsgroups/topic.aspx url=/MSDN-FILES/028/201/008/topic.xml See als ...Show All

• SQL Server ODBC lookup

  Hi, I have to do a lookup in a table that I can only access through ODBC. However it seems the lookup component only allows an OLE DB connection manager. Is there any way to do an ODBC lookup thanks in advance ... Not that I have seen.  You have 2 other options though: 1. Use a script component and write code (connect and pull the table in memory in the preexecute, use lookups to the table in memory in the ProcessInputRow section).  2. Add a DataReader source and sort + join with the join operator.  Which one is best to use depends on your situation.  Neither of them is ideal - option 1 in my experience is usually the fasted but obviously more work to deve ...Show All

• Audio and Video Development An interesting survey: HD-DVD vs. Blu-Ray

  A survey from http://www.dvdtown.com/announcement/hddvdsurveybyipsos/3665/ 1. In response to the question “Which statement best describes how likely you would be to buy an HD DVD player,” respondents were over seven times more likely to buy an HD DVD player vs. a Blu-Ray player when all studios support both formats. a. 57% would definitely or probably buy an HD DVD player vs. 8% for Blu-Ray. b. 25% would definitely buy HD DVD vs. 2% for Blu-Ray. 2. Purchase interest in HD DVD remains three times higher than Blu-Ray -- even without HD DVD studio support from Disney and Fox. a. 56% of respondents would definitely or probably buy an HD DVD player vs. 18% for Blu-Ray. b. 20% would definitely buy HD DVD vs. 6% for Blu-Ray. ...Show All