is4me2's Q&A profile

• SQL Server kick people logged on

  Hi, i have a job that restores a database every night. The job fails if someone is logged onto the database. Its a development database. I was wondering if there is a command that i can use to kick everyone off the database before the restore any help is appreciated. Hi We use the following: USE Master Go ALTER DATABASE <DBName> SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO ...Show All

• Visual Studio Team System Beta 3 Setup Error: Windows SharePoint Services is not configured as recommended by Team Foundation Server

  I am trying to install Team Foundation Server Beta 3 as single server installation and installed all required software components. However, during the installation, it gives me "Windows SharePoint Services is not configured as recommended by Team Foundation Server" error under "Recommened Components" dialog box. I exactly have followed an instruction specified in setup guide for Team Foundation Server Beta 3 for SharePoint services installation. ...Show All

• Visual Studio Team System CA1807: Either false positive or need code help

  The following code snippet raises fxCop warning 1807.  Either it is a false positive (as I know no way to force a switch statement to perform a case-insensitive compare) or there is a solution that I cannot seem to find... Here is the code: string outputType = query.OutputType.ToLower(CultureInfo.CurrentCulture); switch (outputType) {     case "excel":     ...     break;     cas ...Show All

• SQL Server an easy question....

  I have to connect to a SQL server 2000 database from a VB6 application that runs on a different PC.... PC name = FR_SERVER SQL server name = FR_SERVER file name = SQLlab_data.mdf database name=SQLlab thank you Degia Missing question: I tried different connectionStrings, but I get a lot of different errors.... ...Show All

• Visual Studio Tools for Office How to populate Word 2003 ComboBox / Dropdown list using VSTO C#

  Hi, I am creating dynamic OLE Control ComboBox in Word 2003 using VSTO C#. After creating ComboBox I want to populate it with some values. If I use VBA then I can populate using following codelines. Dim myarray(3) As String myarray(0) = "US" myarray(1) = "AUS" myarray(2) = "UK" ComboBox1.List = myarray But in VSTO when I use following code lines: object objClass = "Forms.ComboBox.1" ; ...Show All

• Software Development for Windows Vista 2 way Communication

  I am trying to build an application that uses workflow on a server and a client. I want to use WCF in the middle to handle messaging. I need to establish 2 way communication between the client and the server. I used the Expense Report sample as a bases but when I try to hook to an event on the service using remoting I get an error. Saying that the application is not flagged as serialized. Can any one help ...Show All

• SQL Server copy changed data only

  i have a databse on a server and i just created an image on the database. now i want to just copy the changed data in all tables withing the database not the whole database eveytime. Hi, what about making a differential backups each time That will only pull the changes to the full backup each time you backup. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• .NET Development New to web services, soap client not referenced.

  I'm running through a tutorial trying to get my head around web services: http://my.execpc.com/~gopalan/dotnet/webservices/webservice_server.html being the tutorial, now i've built the Service, and have coded the Client from the tutorial, only for Visual Studio to throw this error when i try and compile the console application: c:\Inetpub\wwwroot\ConsoleApplication2\bin\Debug\Service1.dll Referenced class 'Service1' has base class or interfa ...Show All

• Visual Basic Data UI Customization

  I am running VB 2005 standard edition. When I imported an SQL database into VB with the intention of creating a new user applicatio I found, first, that the Data Suorces window didn't appear; the error message was it was not a true type font and only true type fonts are supported. Further investigation revealed that the Data UI Customization window under Tool/Options didn't appear; the error message displayed is 'an error occurred loading this p ...Show All

• Visual Basic Having a newline in text box, but not newline in the text. How?

  Ok, here's the deal. This is for VB6. I have a mutiline text box and just one string to paste in it, through code. This single string is logically in 4 parts, but for the purpose of the program, the string is a single, long string, with no CR or LF. However, for the sake of user visuals, I'd like the string to be split on 4 lines in the text box, along these 4 logical sections. But say the user goes and does a select-all, or ctrl-A or in other w ...Show All

• Visual Studio string list of parameters

  I am trying to create a report where I pass in (from VB.NET) a string that contains a list of parameters. We have a SQL stored procedure being built based on what the user is clicking on, records are selected, and a string of the unique fields (ex. '(''123'', ''456'')') is listed and is outputted to a variable in VB.  What I am trying to do is only pull the records into the report where the VB variable is something like ('123', ' ...Show All

• Visual Studio Team System web deployment projects in drop location?

  When building a regular 2005 web with Team Build, I get what looks like the contents of the Binaries folder in the drop location i.e. '<BinariesRoot>\Debug\Mixed Platforms\_PublishedWebsites\<WebName>... When using web deployment projects I dont get either. As part of a larger build process the drop location is the area I target for msi generation for example, what do you think is the best way to get the output of all web deplo ...Show All

• .NET Development How do you insert and update the database using DataSet (for VS .NET 2005)

  Hi! I'm currently new to VB .NET (through VS .NET 2005). I am in need of assistance regarding how to insert and update the database using DataSet. I am using OleDb in my program. It doesn't produce a syntax error after being compiled and executed but the data is not stored in the database. Please help if you can as soon as possible. Even a sample source code will do, it would even be better to give some explanation too. Thanks a lot! ...Show All

• Windows Forms Format

  hi how can i format numbers in C# i have tried this but it did not work label1.Text=String.Format("350","#.##"); like in vb but it did not work how can i do it plz tell me Checkout the NumberFomatInfo class the above would&nbs ...Show All

• Windows Forms How do I make a spell check...?

  Hey, I searched for this, but none helped... I am using Visual Basic 2005 express, and I need a spell check, but I can't figure out how to do this, if someone finds/knows a program that will let you put the words in it and it will give me the VB2005 express code thats fine, but if you want to give me code...I would be fine getting a 3 word spell check so I can go from there...ummm..I dont really want to use the MS Word spell check, k ...Show All