RLovelett's Q&A profile

• SQL Server SQL 2005 how to change @conflict_retention for articles already published

  Hello,     I have some articles already published and would like to change some of the articles default @conflict_retention of 14 days to 45 days. How can I accomplish this via t-sql Thanks.   John     @conflict_retention is publication level setting. You can change it through sp_changepublication or sp_changemergepublication. But you can not change only fo ...Show All

• SQL Server IS_Member

  Hi, IS_Member function Indicates whether the current user is a member of the specified Microsoft Windows group or Microsoft SQL Server database role. If I want to test this for different user other than the current user, How I can do this Thanks You can use SETUSER   Here is a small example --Create Dilbert user EXEC sp_addlogin 'Dilbert', 'food', 'pubs' EXEC sp_adduser 'Dilbert' --This is my login ...Show All

• Windows Forms User Control (text box), Null values, Formatting

  I am trying to create a textbox control which will handle null values (see 1 below) and  retain the ability to be formatted using Binding.Format (see 2 and 3 below). My User Control is in Number 1 below. When I use the 'Shadows Proper ...Show All

• Visual Studio Express Editions My Prpgram Throwing an Exception

  My program builds without any errors, however, when I run my program I get an OleDbException. Why is this taking place. Does anyone have an explanation as to what is happening here. Any suggestions as to how to fix this problem. Exception Displayed: Could not find file 'C:\Documents and Settings\Richard\My Documents\Visual Studio2005\Projects\HomeInventory\HomeInventory\bin\Debug\HomeInventory.mdb. ...Show All

• Visual Basic Full-Screen Display Mode in VB.NET Console App?

  Anyone know how to do this in VB.NET Thanks in advance. Adrian Mannella Anyone know how to do this in VB.NET Thanks in advance. Adrian ...Show All

• Visual C# Running C# with Crystal

  Hi, I need to run a C# application that use crystal reports, but it says that Assemblies is missing Do I need to install something in the server, I have copied the crystal dlls but it does not open the report...   Thanks Bruno hi the re, If you are using vs.net, crystal reports component is included in the package of vs.net. Please essure that you include the crystal reports during installation.  If y ...Show All

• Visual Studio Express Editions ListView sorting question

  Hi I have a ListView control called HSlist on a form which has 3 columns. The adding data seems to work OK, but the sorting is weird to say the least. Initially, I thought that the list would be sorted on the contents in the first column, so I added to the ListView with the Item containing the data that I wanted the list to be sorted on (numerical). Then I found that the list was being sorted on the second column (strings), so I swapped th ...Show All

• Visual Studio Team System SQL Server SP1 and hotfixes

  VSTS requires several hotfixes to be applied (i.e. KB 912373). Since I cannot find KB912373 anywhere in the known world (certainly not in the ISO of the 180 day trial), can I simply install SQL Server SP1 instead If not, could someome please tell me, where the hell can I find KB912383. Luis Miguel Huapaya Hi Luis, Where did you see you needed that hotfix The hotfixes that are needed are on the iso in the ...Show All

• Windows Forms WebBrowser control hangs on Window.Close()

  At first, I enjoyed the new webbrowser control but then I noticed that the args provided by the events NewWindow3 and BeforeNavigate of the axWebBrowser had not been implemented in the new control. Arg. Good news, the guys from Microsoft gave us the a workaround recently in C# and said they will publish a sample soon on MSDN. In the mean time, here is some VB.net code inspired from Microsoft's C# that will give you 2 new events an ...Show All

• SQL Server is this possible in SSIS?

  I got a OLE DB source pointing to 1 table and 1 flat file destination. currently this is how i export data from 1 table to 1 flat file. To make things easier, I was wondering whether i can have only 1 OLE DB source pointing to few tables pointing to few file destinations so I dun need to create 1 SIS project for each table data exporting. anyone can help me Unfortunately not because ...Show All

• Visual Studio Tools for Office Selection.PasteExcelTable not working correctly the first time it is called

  Hi, There are specific circumstances under which Selection.PasteExcelTable does not behave as expected the first time it is called. The following are the steps to reproduce it. In a Word Template project, add the following code private void ThisDocument_Startup(object sender, System.EventArgs e) { UserControl1 userControl = new UserControl1(); userControl.button1.Click += new EventHandler(userControl_Click); this.ActionsPane.Contr ...Show All

• SQL Server Is it possible to have sqlcmd connect to local sqlexpress without a parameter?

  (SQL Server Express 2005) sqlcmd will connect to the local SQLExpress server just fine if I give the -S parameter: SQLCMD -S .\SQLExpress but is there any way to have it default to that so I can just say: SQLCMD Thanks, dwh You can do something like: 1) Create an Alias thorough Computer Management | SQL Server Configuration Manager | SQL Native Client Configuration         &nb ...Show All

• Visual Studio Express Editions Set Reference Question

  I would like to use XMLHTTP command in my VBE project.  I have added Microsoft XML 6.0 in the Reference selection, however my project still gives a "XMLHTTP" undefined warning. Is there a specific Reference that I need to download and set up in the project in order to define the command XMLHTTP code: Private Sub Button2_Click(ByVal sender As System.Object, ByVa ...Show All

• Smart Device Development Can't ActiveSync my Device after Cradling my Emulator

  I'm a SmartPhone owner and developer. As such, I have occasion to cradle my Emulator and my actual Device (Audiovox SmartPhone) with the same ActiveSync (v4.1.0). I'm finding that after cradling the emulator (as a Guest) I can no longer Sync my SmartPhone. I can cradle the SmartPhone and I can Explore it via ActiveSync, but I get this very vague message when it tries to sync: Synchronization error The only way I ca ...Show All

• Visual Studio Tools for Office "Reload" listobject after UnList()

  Hello, I'm trying to make an excel application where the user binds a dataset to a listObject. Then I'm doing a UnList() on the listObject so the data looks like an traditional spreadsheet. Then I whant the user to be able to bind another dataset to the listObject, but this can not be done after running UnList(). How can I instansiate a new listObject, or how can I solve this matter     Best Regards Carl ...Show All