Alan Reed's Q&A profile

• SQL Server Determining is a database is a subscriber

  Hi, can anyone tell me if there is a way to determine with SMO or RMO if a database is a subscriber when using merge replication. If only have the Server and database at this point too!! I want to provide a small app that creates a merge publication but only if the database isn't a subscriber. Thanks for your help Graham You can check to see if certain replication system tables exist, and if they do exist, check to see if they are populated. One system table you can check for is sysmergearticles. However this doesn't guarantee you anything except that it is currently, or at one point in t ...Show All

• SQL Server How to programically call SSRS 2005 report then Save to file

  How from a VB.NET app can I programmically code a call to one of my existing SSRS 2005 reports and after that report is done running, tell it to also save as a pdf into another directory somewhere on our file server This will give you an overview: http://msdn.microsoft.com/sql/bi/reporting/default.aspx pull=/library/en-us/dnsql90/html/integratrsapp.asp Basically, what you will do is use VS.NET to create a web reference to the RS SOAP endpoint, this will then provide an class which you can use to render reports and then save them wherever you want. ...Show All

• Windows Forms Listview header

  hi please anyone tell me to change Header Color of System.Windows.Forms.Listview control Thanks Raju Here is a link to a code project article on Customizing the List view control, it has some information of moderfiying the header that might help. Customizing the header control in a listview http://www.codeproject.com/cs/miscctrl/customheader.asp ...Show All

• Windows Forms How do I use remoting effectively over an intranet?

  I'm a veteran C++/COM switching to C#/.Net.  I've written a WinForms application.  I'd like to be able to "remotely watch" what the user is doing on their machine, to aid in debugging, etc.  Ideally, I'd like to start an instance of the app on my machine, but have it "connect" to the running instance on the remote machine. I've  ...Show All

• SQL Server How do i execute commands inside a CLR SQL Server Trigger?

  Hello, the examples from MSDN like the following, don't run on my computer. A System.Data.SqlServer don't exist. No SQLCommand Type, no SQLContext.GetCommand Method and so on... Ist there something wrong with my installation or how do i execute commands inside a CLR SQL Server Trigger Regards, Markus Imports System Imports System.Data Imports System.Data.Sql Imports System.Data.SqlServer Imports System.Data.SqlTypes Imports System.Text.RegularExpressions Public Class EmailTrigger     Public Shared Sub EmailAudit()         Dim triggContext As SqlTriggerContext = _     & ...Show All

• Visual Studio Team System Team Build SKU Installation

  Hi, Should we install the Team Build SKU from TFSsetup login or Adminsitrator Login Regards Sahil Absolutely correct.  The account installing Team Build must have appropriate administrator privledges to make it work. Using the TFSSERVICE account for the Build service will reduce some of the extra permissions work (with TFS) you would have to do if you used a different account. marc ...Show All

• Visual Studio Express Editions Registration process reveals information about other users

  The registration process seems very insecure. Despite being connected to a secure server, after hitting continue I got another user's information including his/her postal code. This is definitely not good. If anyone from Microsoft is interested in more information you can contact me (or post here). I'd very much like to get more information as to what you're seeing.  We haven't seen anything like this before.  Please send more information to vsrghlp@microsoft.com and I'll investigate from there. ...Show All

• SQL Server Nested cursor

  Is there a better way to nest cursors in SQL Server (I'm using 2005). Due to the nature of the solution a set-based approach will not work. Essentially I have a list of People. Each Person has Multiple Properties, so at the moment I have something along the lines of ... Declare PersonCursor Open PersonCursor Fetch Next Person Cursor While FetchStatus <> -1 Declare PropertyCursor (for Select according to current values in PersonCursor) Open PropertyCursor Fetch Next PropertyCursor While @@FetchStatus <> -1 Process Each Property Fetch Next PropertyCursor End Close PropertyCursor Deallocate PropertyCursor End Clo ...Show All

• Visual Basic How can I get a Field From A Dataset

  I set a field on my grid as not visible and when I try to rowbind data I can not get that value using the e.row.cells(6).text - So - my question is how can I get that value without showing it on the grid or how can I get this field from the dataset as each record is binding.. here is the code I have: Private Sub BindGrid() Dim myDataSet As New DataSet myConnection.Open() strSQL = "SELECT * FROM CDO_Quality_Test WHERE CDO_ID = " & Session( "CDOID" ).ToString & " ORDER BY sub_test_pos" myDataAdapter = New SqlDataAdapter(strSQL, myConnection) myDataAdapter.Fill(myDataSet, "cdo_quality_test" ) dgTests.DataSource = ...Show All

• Visual Studio Team System AllowTeamServer configuration

  Hi, does anyone know when this value, either in the registry or in the tfsbuildservice.exe.config file, does this value get set Thanks in advance. Garnet. Hi Garnet This value is set when you first fire a build. The server value is set to the current server. Thanks -Khushboo ...Show All

• SQL Server Error when restoring database

  Hi guys! I wonder if this happened to you... I searched and found nothing related to this problem... When I try to restore a database in SQL Server Management Studio on a 2005 database engine I receive the message: Cannot show requested dialog. ------------------------------ ADDITIONAL INFORMATION: Could not load file or assembly 'SqlManagerUI, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Strong name validation failed. (Exception from HRESULT: 0x8013141A) (mscorlib) ------------------------------ Strong name validation failed. (Exception from HRESULT: 0x8013141A) Sometimes I receive th ...Show All

• Windows Forms Image Property

  It would seem that you can create a new bitmap with an ImageFormat of Icon as long as the icon exists in a file (i.e. myfile.ico). Why then can I not assign an Icon to a new bitmap  I know I can assign it by converting to bitmap, but that results in the ImageFormat being MemoryBitmap which totally destroys the Shadow area of the Ico ...Show All

• Visual C++ Debuggin issue

  Hi, I'm compiling an application with /Od and /Zi. When I omit the -DEBUG linker flag I get a crash in my application. When I add the -DEBUG flag it does not crash anymore. Any idea how to debug this Thanks, Manu I would look through the source where it seems to crash. Maybe you have some idea where it crashes The message from the crash might give you an indication. I would start looking for missed checks for valid pointers, initialisations in ASSERT() macros or other code that is run only in debug builds. This usually turns up as crashes in release builds while it works in debug build. To ...Show All

• Visual C# Can I send a parameter by reference in using waitcallback?

  Hi, I use waitcallback which is defined: public delegate void WaitCallBack(Object o); to callback a methed which is defined: public void method(ref Object o); The error occurs when compiling. Can I use waitcallback to delegate a method in which the parameter is sent by reference Thanks, Derek I see. I write a delegate object to substitute for waitcallback which meets my requirement. Thanks. ...Show All

• Visual Studio Express Editions Please Help With Code

  Hi I have a problem i am designing a software.I will like to connect my visual studio express project to a ms access database. The data that is entered in the form i will like it to appear in the database. How do I connect the database to my project, becuase i dont want to use the SQL Server database. The code for add a new record and updating and saving that record. Kind Regards Lea Hi Lea, There is a way to connect to you database using ADO.Net... It will look like sql server but it's not and as a matter of fact you will use SQL sysntax even when Jet is the dataprovider. Let's see if I can answer your question: ...Show All