Smartway's Q&A profile

• SQL Server Change an Access Database to SQL Server

  I designed a database that works well in Access and I want to get it to run in SQL Server. How do I learn how and what to do to change over to SQL Server Note also the link to further SQL Server tutorials included on the linked page under the Concepts section, for further tutorials: SQL Server Tools Tutorials ...Show All

• SQL Server Urgent help please!!!!! Error trying to uninstall RS sql 2k5

  Hello, One of our lovely NA's decided to remove IIS and the reinstall it while RS was installed before trying to uninstall RS. So RS broke. We then tried to uninstall RS to start over and get this error: The setup failed to read IIsMimeMap table. The error code is -2147024893 Anyone have a work around to get us to uninstall RS This way we can install IIS 6.0 from scratch and try to install RS afterwards. Thanks. Okay I recommend backing up your system before attempting this. There is a way to trick Windows into thinking an application is not installed, thus allowing you to install it fresh aga ...Show All

• Software Development for Windows Vista Why just HTML and JavaScript support for The Windows Sidebar Gadgets?

  I got really disappointed when I saw how Gadgets work and how to develop them. Gadgets are developed using HTML and JavaScript. You can find more information about how to develop Gadgets and how they work here http://microsoftgadgets.com/Sidebar/DevelopmentOverview.aspx . I remember watching a video from PDC 2005 about Windows Sidebar development right after the PDC event. I learned about the Windows Sidebar visions and one just got stuck on my mind. I forget things relative easy, I have to use the outlook calendar to remember daily basis thing, but somehow this vision just got “burned” into my mind. The vision was that Sidebar Gadget ...Show All

• SQL Server How to close all open "handles" to a SQL Server 2005 express DB?

  Hello all! I'm trying to create an application which makes a copy of the database file it is using on application start and can restore it at any time, if needed (little project about SQL injection, so I need the copy ;-) ). This works fine, but as soon as I make my first connection to the db (connection_object.open()) and close it again I can not access the file anymore, because it is "in use by another process". How can I release all handles from the database, so that I can replace the DB file with it's backup copy Thank you Kolja Ahm... cal me a noob, but I disposed it and set the variable to nu ...Show All

• Windows Forms Size of controls in design view

  I worked all morning in Visual Studio.NET. Everything was normal, just like every other day. I started a new project just before lunch. Just got started on the UI of a few pages, not much VB yet. When lunch came, I minimized all my windows and came back about an hour later. When I maximized Visual Studio, everything in the design view of my new pages was HUGE. I ran the application to view in browser, everything was half as big as in design view. Out of curiosity, I opened an old project that works perfectly and I know I developed it with the size of controls being the same in design view as in the browser. These pages were HUGE as well. I s ...Show All

• SQL Server Client-side Redirect problem

  Hi there. I have a database mirroring session running, and both principal and mirror are working fine. But when i unplug the network cable from principal server, creating a failover scenario, the client doesn’t get redirected to the mirror. I get an error saying: " A transport-level error has ocurred when received results from the server. The specified network name is no longer available."     connection = "Data Source=SISAD;Failover Partner=Projecto-SWS1;Initial Catalog=SIERE;Persist Security Info=True;User ID=sa;Password=testing;Connection Timeout=100" ; // this method is called many times by a thread, emu ...Show All

• Windows Forms linklabels in middle of a text

  Hello, I'm in need to grab news from a website, those news can have multiple links anywhere in the text and the link's name must be kept to still have a logic message displayed. I was wondering how to do it, and I couldn't figure out how. Thanks for any help / ideas you could provide. Indeed, but from what I know, the links  ...Show All

• Visual Studio Team System MSF books

  Hi, Does anyone know of release dates for books on MSF Agile Some books have been released recently that cover VSTS but I cant find anything on MSF. The only one I can find is planned for release in Feb 2007!!! http://www.amazon.co.uk/exec/obidos/ASIN/0321336445/qid=1130847491/sr=8-5/ref=sr_8_xs_ap_i5_xgl/202-4186540-2622229 Thanks, David Hi David,    That's my book! It will be out long before 2007 although I can't fully say when. We will putting whitepapers on our web site http://www.microsoft.com/msf that cover many of the topics in the book prior to the delivery of the book. Randy MSF ...Show All

• Visual Studio Express Editions Check if textbox is a Valid Integer from 0 to 10000.

  How can I check if a textbox contains a number that is a valid integer (just numbers) and that its a number from 0 to 10000 The way i did was in loops which would freeze the program for a few seconds. Any other ways first use int.tryparse to see if it's a number. Then check if that int is in the range you want. Or, use a masked text box to specify the input range you require ...Show All

• Windows Forms search dataset

  hi .net people! i have a dataset that contains a table named "MemberReport", this table contains all data from the Members Table of the database. what i want to do is to search, find and sort this table before it is placed to a datagrid. anyone thanks! You simply need to create a DataView of this table and set the RowFilter  ...Show All

• SQL Server Maximum SQL Query lenght

  Hi all! Does anybody know what is subject Thanks! This is batch size from ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/13e95046-0e76-4604-b561-d1a74dd824d7.htm ...Show All

• Visual Studio Unhandled exception on startup....leading to Registered JIT debugger is not available.

  I have a program that is failing (unhandled exception) & gives: Process id=0xa2c (2604), Thread id=0xa30 (2608) Trying to Debug gives: NotifyAlert.exe – No debugger found Registered JIT debugger is not available. An attempt to launch a Jit debugger with the following command resulted in an error code of 0x2 (2). Please check computer settings. Cordbg.exe !a 0xa2c I have seen these ids change, but aways get this error. From other MSDN responses, I have looked up the following: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\Current Version\AeDebug default - value not set auto - 0 ...Show All

• Visual Studio 2008 (Pre-release) when will the next ctp released

  hi , i am wondering when will the next ctp releasd, the last onw was in feb 2006 its been a long time. r u guys planning to release one this month. prasanth Craig answered similar question last week, please go through following info http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=374266&SiteID=1 ...Show All

• SQL Server To find all pairs in table that fits to given criteria.

  Task: To find all pairs in table that fits to given criteria. For example: I have a table with id's and weight of people. The task is to find all pairs of people (id's) that their weight in range of 0-5 kg. The result need to be without repetitions of data. id  weight 1   80 2   84 3   81 4   90 So results should be: 1 2 (or 2 1) 2 3 (or 3 2) 1 3 (or 1 3) but not both I'm using MS SQL Server 2000. Question: How to do it in SQL Thank you very much. I run query on the large( ) table (60000 rows) and as result I get strange output. This is a reson why I asked the prev. question.& ...Show All

• Visual Studio Express Editions Delegates & Event Handling

  Here is what I am trying to do.. I am designing a general accounting program and it is set up with a MDI parent form with child forms... The child forms show Data Entries.. I want to be able to subscribe to an event so that when it is called all the child windows that are open will refresh their view.. Here is what I have: public delegate void RefreshView (); public partial class MainForm : Form { public event RefreshView refreshView; private void invoicesToolStripMenuItem_Click( object sender, EventArgs e) { FormInvoices formInvoices = new FormInvoices (); formInvoices.Mdi ...Show All