Steve Allen's Q&A profile

• SQL Server Download database to local and use

  I have SQL database hosted by my ISP. Every now and again we log on and create new tables using user XXX1. After getting a backup of the database, I have restored it on my local machine. When running the application on local, I get an error because there is a new user in database called XXX1. I would like to change the user from XXX1 to dbo on my local machine for all tables, stored procedures and views. How do I do this easily Thanks in advance! Dave Hi, http://groups.google.de/group/microsoft.public.sqlserver.programming/browse_frm/thread/f1625d70fb765701 HTH, Jens Suessmeyer. --- http: ...Show All

• Visual Basic Remote Computer

  I am now doing my final project for Cybercafe. May i know that how can i shutdown, restart, or log off the user/customer pc after payment by using admin pc. How to remotely shutdown a pc or remotely run a .bat file Before that have a fren send me the syntax below, but i stil canot remote shutdown other pc. Can any one tell me the way how to remore shutdown Syntax SHUTDOWN [ logoff_option ] [/m \\ Computer ] [ options ] logoff_option: /i Display the GUI (must be the first option) /l Log off. This cannot be used with /m or /d option /s Shutdown /r Shutdown and Restart /a Abort a system shutdown. ...Show All

• Visual Studio Team System Specify Messagebox options

  Hi Added the messagebox options i.e messageboxoptions.rightalign (assuming that if my application was to be used in an rtl environment then the text would be right aligned), so even though rtl is set to No and the language is set to default (which I can only assume is either US English or UK English), so why are all my messages boxes titles now right aligned Have I missed something here Duncan If you specify right-aligned, the message box will display that way. What you need to do is dynamically determine whether the current UI is right-aligned and modify your message box options. As David notes, a ...Show All

• Visual Studio Express Editions stupid newbie needs help with serial port communication

  Hi, I hope someone can help me... I'm trying to use visual basic 2005 to recieve data from an ooPic device which is transmitting an incremental value via the serial port... the code used to do this is described here: *********** Do variable = variable + 1 serial.string = str$(variable) Loop *********** I'm using this so i can try see if i can recieve this data using visual basic 2005 to display the value in a window when a button is clicked. I have no clue where to begin. I managed to be able to send data to the ooPic using the code below: ****************** Private Sub Send_string_Click( ByVal sender As ...Show All

• Visual Studio 2008 (Pre-release) Async query execution in Linq

  Are there plans to provide support for async query execution - perhaps something like IAsyncResult result = q.BeginToList(OnQueryCompleted, state) This would be useful when you know the query is going to take some time. I suppose an issue is what extension methods to support - I expect some scenarios could find async versions of many query extension methods handy - IAsyncResult result = myBigDataset.BeginAverage(OnQueryCompleted, state) This could get quite unwieldy, particularly by the time we start dropping our own extension methods into scope - invoking Intellisense on an IEnumerable variable is going to start producing a p ...Show All

• Visual Studio Express Editions VB Express Beta 2 BindingNavigatorDeleteItem creates unhandled exception

  Forgive me if I'm missing something obvious but I'm new to this. I have a simple database with 2 tables, and a Foreign Key constraint between the parent and child tables, such that changes/deletions are not permitted in the parent table if the child table has related rows. I have a form displaying a DataGridView containing the parent table. This all works fine in that a DataGridView.DataError is raised causing a System.Data.InvalidConstraintException, which I can deal with using an event handler for the DatagridView.DataError. However, deleting an invalid row by pressing the BindingNavigatorDeleteItem button crashes with the message "Invalid ...Show All

• SQL Server Larger than expected 'User Connection' Alert from named instances of SQL Server 2005

  We have a none production server with several instances of SQL Server 2005, which are monitored for the number of 'User Connections' via a standard alert within SQL based on the performance counter for that instance. Now the number of User Connections is grossly exaggerated on each of the named instances (not the default). Example while sp_who2 is showing only 58 connection, the performance counter is showing 3647 and these instances are all limited to only 200. This is my last stop before opening a PSS call. So as any one else come across this and maybe the solution ...Show All

• SQL Server Parent Package Variable visibility when designing packages

  I've created an SSIS package that uses parent package variables at several steps in the data flow. However, those parent package variables are only visible during runtime, making debugging the package practically impossible. Let me give you a simplified example: In the parent package, I have a string variable named "sqlLookup" that looks like this: "SELECT * from tblTest WHERE city = " + @city Also in the parent package is a variable named "city" which I can set to the name of the city that I want to query on. This dynamically updates the sqlLookup variable, which is being evaluated as an expression. ...Show All

• SQL Server SQL Studio 2005 projects vs. VS.NET database projects. Which is better?

  I've been using VS.NET to create database projects and store sql scripts for quite some time now ( file -> new project -> other project types - database). But now with similar projects also in SQL 2005 Management Studio, which is the best approach to use What do you think Here’s my initial assessment and please feel free to chime in because I’ve been using SQL Management Studio projects for only a couple days. Both have integration with source safe. + 1 for each! SQL Studio is a more natural way to modify procs, in a friendly environment. +2 for SQL Studio! VS.NET projects allow you to drag procs, views, tables, e ...Show All

• Visual C# How to tell if Windows or Web GUI called library

  Is there a system property/method that I can call from within my c# library assembly to tell if it is being called by a windows or asp.net .net program p.s. I have found one way, and that is to put a try catch around a ::global or a webconfiguration call, but I am guessing that this adds overhead. Evan Smith I don't know why you should want to know it. It feels like a bad design to me and it should not need to be know for the Library. The only thing that i can imagine is that you use preprocessor directives to minimize file size, exclude some classes or use a other factory class. ...Show All

• .NET Development DataSet HasChanges problem

  i have a problem with the dataet method HasChanges , im using a combobox DisplayMember to show the empoyee name from the employees table , and in the back im using the ValueMember to update the allocations table with the employee ID. it always returns true when i load the data into the form but im not changing any data. any one got any ideas thanks in advance. this . sqlDataAdapter2 . Fill(ds_temp51, "Employees" ); this . sqlDataAdapter1 . Fill(ds_temp51, "Allocations" ); this . cb_emp . DataBindings . Add( new System . Windows . Forms . Binding( "SelectedValue" , ds_temp51, "Allocations.empid" )); this . cb_emp . ...Show All

• SQL Server SQL Locking up

  Posted - 12/25/2005 :  10:54:44       My ADO based C++ application works fine for sometimes 15+hrs just fine. Im using SQL 2000. All of a sudden I dont know what happens all update operatins and insert operations start failing with 80040e31, timeout expired errors. It seems as though the whole database is locked up. And after 1hr or sometime 2 hrs everything is back to normal without any intervention. if i intervene and i stop all my app services. i run sp_who and there are no connections to the database. I restart my application services and still have those 80040e31 errors come up ...Show All

• Visual Studio Team System Currituck 'Access denied' error from web service.

  Developing a web service to expose the WorkItem store (Currituck). It works OK running in the development server from the IDE, but deployed to the IIS server attempting to access any of its methods returns: System.ApplicationException: another fine error! --->  System.UnauthorizedAccessException: Access is denied. (Exception  from HRESULT: 0x80070005 (E_ACCESSDENIED)) at  Microsoft.VisualStudio.Currituck.DataStore.  HandleComException(Exception e, Int32 hr) at Microsoft.VisualStudio.Currituck.DataStore.DatastoreClass.ConnectEx(  String connectionString, Int32 hCredentials) at Microsoft.VisualStudio.Currituck.Cli ...Show All

• Visual Studio Express Editions Keep getting the error "Syntax Error in UPDATE Statement"

  I've worked with the older versions of Visual Basic and since moving to 2005 express I think I've gone a bit more crazy. I keep getting this error when the dataapdater.update statement is called. Here is the code that I am using and I've also thrown in the information from the syntax error. Private Sub EditMaterial( ByVal codepos As Integer ) Dim con As New OleDb.OleDbConnection Dim updateCMD As OleDbCommand Dim Sql As String , updateSQL As String , idtxt As String con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data" & _ Source = C:\tmp\che ...Show All

• .NET Development Exception: "The underlying connection was closed: The connection was closed unexpectedly." (sometimes)

  I have a windows app connecting to a webservice. In some situation(s) (haven't narrowed it down enough), I get the following exception: The underlying connection was closed: The connection was closed unexpectedly. When this exception is thrown, it is calling a method of a web reference. Now the situation that we experience this is on a laptop in the field that is using a WWAN connection in at least one location. It works fine in the lab at the office. Anyone have any ideas what could be causing this If you are transfering large messages or the operation on the service side is taking very long you m ...Show All