Pete Nelson's Q&A profile

• SQL Server The database is not published. Execute the procedure in a database that is published for replication.

  Hi, I am trying to create a publication on sql server 2005 database , i got the follwong error:   TITLE: New Publication Wizard ------------------------------ SQL Server could not create publication 'testreplication'. ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The 'mydb' database is not published for merge replication. Unable to execute procedure. The database is not published. Execute the procedure in a database that is published for replication. Changed database context to 'mydb'. (Microsoft SQL Server, Error: 21147) For help, click: http://go.microso ...Show All

• SQL Server Confusion over SQL 2005 Standard CPU Support

  I'm a little confused over the maximum CPU count supported by SQL 2005 Standard Edition (this particular edition supports four CPUs). Does the figure refer to four physical CPUs regardless of whether they are dual-cored or hyperthreaded, or does the figure refer to the number of logical CPUs available to the OS Let me cut to the chase - if I purchase a server containing four dual-core CPUs and install SQL Server 2005 Standard, will SQL Server see the eight CPUs and utilise a maximum of four of these, or will it be able to use all eight (because there are actually only four physical CPUs) Thanks, Chris. It's per processor regardless of the number of cores. See the link below. Doug http://download.microsoft.com/dow ...Show All

• Windows Forms Bill said it is a good question!

  How can I disable a combobox, while show it as normal instead of being gray Thanks in advance. hi there, The problem is when you set selectedIndex = -1, the combobox text will become null. I want the text unchangeable. Thanks. ...Show All

• Windows Forms Newsticker in c# windows program

  Does anyone know how I can make that, or know where I can look for ideas I have a slideshow program that shows movie trailers, room reservations etc, and would have wanted a horizonal "line" below the slide that have a moving text for short, quick annoucments. For the rest of us, here's a custom control that implements a news ticker. Add a new class to your project, then paste this code: using System; using System.Text; using System.Drawing; using System.ComponentModel; using System.Windows.Forms; class NewsTicker : Panel { private Timer mScroller; // Scroll timer private int mOffset; // Offset of scrolled text private string mText; // Text to scroll private Size mPixels; ...Show All

• SQL Server Capturing Previous Value

  When updating the value of a field in a table, is it possible to capture -- either for insertion in another table or as a variable -- the previous value of the field Thus, if a field value is 'Value1' and a user updates it to 'Value2' is there some way to hold 'Value1' as a variable Lynn Trapp I didn't doubt your awareness of db design Lynn :) I was just attempting to prevent any off-the-wall or abstract approaches from entering the thread. I understand your situation and a single field will work, but I am still confused on why you can't update simultaneously Is one system remote (unable to establish a join ) Is one a testing server and another a production server Do you want to validate ...Show All

• Visual C# term for c#

  Does anyone know the term below when a property is non-virtual and contains only a small amount of code, the execution environment may replace calls to accessors with the actual code of the accessor. Thank you for help. You are referring to a process known as inlining . What it says is that the accessors (i.e. get and set) of a property with very little code will be inlined in your code. In a nutshell, say you have the following (rather silly) property: private string m_myproperty; public string MyProperty { get { if ((m_myproperty != null) && (m_myproperty.Length > 3)) return m_myproperty.Substring (0, 3); else return ""; } } and somewhere in your c ...Show All

• Visual C# open pdf document...

  Hi... How i can open a pdf document on a button click event... My pdf document is there in my C# project folder. Thank & Adavance... Vinay System.Diagnostics namespace has a process class to do this in a simple way assuming that you have a default reader (ex: Acrobat Reader) for PDF Files. using System.Diagnostics; Process.Start(“Path_of_PDFFile”) Note: Path_of_PDFFile in C# should contain two backslashes for example C:\\PDFFiles\\TestPDF.pdf. ...Show All

• Visual Basic Can anyone recreate this small bug?

  New windows form Add a Menustrip and a couple of items Add a Toolstrip and a dropdown button with a couple of items Set the shortcut property of a menu item to CTRL + SHIFT + F9 Set the shortcut property of a different menu item to, e.g., CTRL + F9 Set the shortcut property of a toolstrip dropdownmenu item to CTRL + SHIFT + F9 Set the shortcut property of a different toolstrip dropdownmenu item to, e.g., CTRL + F9 Create two simple subs and have one handle both the C+S+F9 click events and the other handle the C+F9 click events Run the form. On my install, CTRL + F9 works, but C+S+F9 does not. However, if you remove the shortcut key from one of the menu items (so there is only one C+S+F9 shortcut on the form) t ...Show All

• SQL Server Performance Point - Unable to create a data source

  I m unable to create a data source from the scorecard builder of performance point server. Whatever options i try it gives me the error "Database connection failed. Please CONTACT YOUR ADMINISTRATOR" But I m the builtin administrator and I cannot find out whatsoever with this error message. Can anyone please help me with this TIA I m able to connect using the SQLServer management studio. The mode of authentication it says is standard. I tried also the option of giving connection string but in vain. I get the same error. ...Show All

• Visual Studio Tools for Office Save custom Outlook property to Exchange server (current user/folder?)

  I am writing an Outlook 2003 add-in in C# / VSTO SE using VS .NET 2005. How/where do I save custom configuration type information to the Exchange server from an option page My thought was to store the information on a folder (MAPIFolder) or the current user (Recipient), but I don't see anything equivelant to UserProperties on those objects. I have been able to store the stuff locally (through settings), but I would like to store some information from my Outlook property page that I can then access from a CDOEX app running on the Exchange server. Thanks The best solution would be to store it as a hidden item, but for that you'll need a low-level API, such as Extended MAPI or CDO 1.21, neither of whic ...Show All

• Visual C++ Internet file downloader : resume facility

  Hello, Am trying to create an internet file downloader. I am using the WinINet APIs. My question is how do i allow the user to pause the downloading and let it continue, from where he left, the next time he starts the s/w Is there a way where i can tell the FTP server, the position in file, from where to start the transfer For such issues, please use the newsgroups at http://msdn.microsoft.com/newsgroups . For the scope of these forums, please take a look at http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=19445&SiteID=1 OTP Thanks, Ayman Shoukry VC++ Team ...Show All

• Visual C# Postback in Asp.Net and C#

  Hi, I have set the .DefaultButton property to my form button (by name), and it works for the first time i press the enter key (meaning it does not submit the form), but for the second on forward (key pressing) it does seem to submit the form, how do i fix this, Thanks Rob ASP.NET questions are off topic here, please ask at www.asp.net . I know people have answered, but the questions are still off topic here. ...Show All

• Visual Basic Hiding the cursor when not on a form

  I have tried the following for hiding the cursor from the desktop: showcursor(false) or system.windows.forms.cursor.hide() both of these only hide the cursor while it is over the form that I am developing. I would like to know if there is a way to hide a the cursor while you are not on the form. Thanks, Tim the clip rectangle won't work for this application as I am using some oversized button because of the touch screen. Someone mention a low level code work around for this. Does this truely exisit I know that when when shutting down the system the mouse pointer goes away, so there must be away to do this. ...Show All

• SQL Server Package not picking up latest Config File changes

  Hi, I've created a solution with 5 packages in. I've scripted a config file for each package where I would be able to change the source file connection and the database servers (source and destination). On the first package, I am able to change the config attributes and the affects are picked up, but the rest of the packages do no pick up the changes. For example, if the source file is "C:\Files\source.txt" and this is changed to "C:\Files\source123.txt" (Just to make sure it fails) it wont pick up the new changes and still uses "C:\Files\source.txt". Also, I tried changing the name of config file itself and the package still ran as if nothing had changed. It's as if it's not recognising the config fi ...Show All

• SQL Server Failed to update database because the database is read-only.

  I am building a Windows Forms application in VS 2005, using C# and SQL Server 2005 Express as the backend. When I try to accessd data from the db, it works with no problems. When I try to insert/update/delete, I get the following error message Failed to update database "DBNAME" because the database is read-only. I am using a connection string with the following syntax: "Data Source=.\SQLEXPRESS;AttachDbFilename=c:\PATH_TO_DB\db.mdf;Database=MyDB;Integrated Security=False;User Instance=False;User ID=USR;Password=PWD;" I have made sure that the permissions on the DB are set (in Windows) so that all users can modify. The user that is logging in to the DB has status set to DBOWNER. I have ...Show All