longrujun's Q&A profile

• SQL Server Regular Expressions in SQL Server 2005

  Hi- Someone posted on a thread that you can use VB (or C#) to write Regular Expressions for SQL Server 2005. I know how to write RegEx in VB, so can someone point me to a reference which explains how to use them in / with SQL2005 Or, can someone explain how Thanks, -David OK. At this point I'm pretty sure that this can be accomplished through the common language runtime. Can someone confirm this -David ...Show All

• SQL Server questions from newbie

  just finished installing SQL Express, and now, dont know what to do next :) - I have installed FULL. Does it have any GUI tool for me to create a database - how can I login into system - how can I restore a backup file I have a backup file from SQL 2005 standard - how can I create backup for databases thanks Thanks. I have installed it. Now, after logging in, I can create new database (db1), create new user (new login ) with default db is the database just created above (db1). But, I cannot use it with my code StrDB="DRIVER={SQLServer};Server=localhost;UID=username;PWD=password;Language=us_english;Data ...Show All

• Visual Studio Express Editions .Exe Packager

  Hi guys, I know that to give anyone a copy of one of your programs, to make it work, you have to have the 1.1143 redistributable framework from microsoft. I was wondering if there was any way or if there are any utilities that package the files, and make regular .exe files that will work on anyone's computer reguardless of whether or not they have the framework on their computer Is there anything like this on the horizon Any input is greatly appreciated! -Robert No - this question is asked frequently and the answer is always the same - applications developed in .NET languages required the .NET Framework to be run. There is no way a ...Show All

• Windows Forms Saving a control Region

  I am working on image-shaped controls and forms. This requires me to calculate a System.Drawing.Region from the image and then set the control.Region to the calculated Region. So far, so good. But for larger images, this process takes awhile, and the performance penalty has to be paid each time the control is loaded, not just at design time but at run-time too. I would like to calculate the Region once, at design time, and then persist the calculated result. At runtime I would just load the persisted Region description instead of recalculating it. I am aware that the Region.GetRegion.Data method provides a byte array describing ...Show All

• .NET Development Moving the file while it's still being created

  Hi everyone, I have the following problem. I use FileSystemWatcher.Created event to call a procedure that needs to move that file. Well, Created event should be called Creating, because it raises when file creation begins, and while it is being created. So, my problem is that I can not move the file until process that is creating the file ends. This is my solution: Dim Success As Boolean While Success = False Try Success = True File.Move(sourcePath, destPath) Catch ex As IOException If ex.Message <> "The process cannot access the file because it is being used by another process." ...Show All

• SQL Server Annoyed with SQL Server 2005 Imponderables - Help!?

  Hello, upon our recent upgrade to SQL Server 2005, there are three issues that have plagued me that I cannot find a workaround for, despite much forum scouring. 1. I have a DTS package that I migrated to SSIS.  The migration seemed to go smoothly, and I can successfully run the SSIS package.  However, when I try to create an SSIS job from it, the job fails to run.  I merely get a "The step failed" error message.  I've seen related posts, none with fixes. 2. DELETE FROM table_a WHERE id IN (SELECT id FROM table_b).  A simple command that would take seconds to run in SQL 2000 now takes almost an hour.  ...Show All

• SQL Server problem inserting datetime

  Since two days, I suddenly experience trouble inserting datetime values on my contracters sql server As example I can  created a table like this: CREATE testDateTime (dateTime DATETIME) and insert: insert testDateTime (dateTime) values ('13-8-2005 11:56:39') this works OK on my local Microsoft SQL Server 2000, but since two days not anymore on my contracters Microsoft SQL Server ("The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value") Maybe they had an upgrade with changes in the way datetime values are handled I sent an email to the administators of my contractors webserver, and I w ...Show All

• Visual Studio 2008 (Pre-release) Service Moniker for COM Clients using WSDL and not mex.

  Any chance someone can post what the Xml string/stream needs to look like in order to use the wsdl parameter for COM clients using the Service Moniker and WSDL Not the MEX (WS-Mex) method, the WSDL method. From Andy Milligan's PDC presentation, there was a slide (I don't have the demo's) with the following: wsdlStr = "<xml ... "    << -==== What's in the string Set monikerProxy =        GetObject("service:address=http://myServer/TestService/,      wsdl='" & wsdlStr & "',      binding=wsProfileBinding,      ...Show All

• SQL Server Divide by Zero Error

  I have a function that compiles a number of different aspects of a Select query and then creates some high-bred fields based on the result. The problem I have is that some of these values contain a zero or Null and therefore I am getting a divide by zero error. The three sums I have are as follows; Number 1:- SELECT........, fnWTRalldata . floortotocc / fnWTRalldata . floortotal AS floorspaceperc, BLAH BLAH FROM Number 2 :- SELECT........, fnWTRalldata . NetRent / fnWTRalldata . FinalRtLsincSC ) - 1 AS rentrolldiscperc, BLAH BLAH FROM Number 3 :- SELECT........, fnWTRalldata . NetRent / fnWTRalldata . floortotocc AS ...Show All

• Visual Basic COM Interop, Property Get,Let,Set Interface Attribute?

  Hello, We are in the middle of a rather large piecemeal upgrade of our VB6 system to .NET 2.0.  We started in 1.1 and have sence migrated that code to 2.0.  We have done a few of our libraries to this point, and are gearing up to upgrade a lot more of them in the next month or so.  We ran into a problem in our first library that required a rather nasty fix and I was hoping someone could point us to a better solution. Problem:  The problem we are having is in VB6 we defined many properties of type Variant for the sole purpose of being able to store Null.  These properties are typically used t ...Show All

• Software Development for Windows Vista workflow and web apps

  How do you go about utilizing WWF in a web application I'm currently looking into building a workflow system for publishing web pages in a cms. I've got a basic workflow built and have been testing it using a console application. I need to port this workflow to the web application where users would interact with it using webforms instead of a console app. I'm a little confused on how this would be done in a stateless environment. The workflow is the usual review process... a reviewer receives a notification via email that a page needs to be approved. They log into the web app and do their review and either approve or reject the page. If a ...Show All

• Visual C++ VS2005 unnecessary build for project

  In a solution, a particular project appears to Build for no reason which I can discover when I choose Build. Is there any way to determine why the IDE Builds a project, in other words why it is deciding that it needs to actually do anything when one chooses to Build Can a makefile be generated from within the IDE for a project or is there any way to get the IDE to show something which will lead me to discover why it is Building In this project the IDE will actually compile the source files, not just do the link, when it appears to be totally unnecessary. This does not happen all the time but intermittently. If I can understand what it is fin ...Show All

• SQL Server Bug, Can not create varchar(max) columns with SMO

  I just want to create a varchar(max) column with SMO. My code is as follows. Instead of varchar(max), a column with datatype varchar(1) is created!!! Table t = new Table(db, "t1"); t.Columns.Add( new Column(t, "c1", new DataType(SqlDataType.NVarCharMax))); t.Alter(); That seems to be a bug of release version. I don't face this problem in Beta 2 Is there a workaround for that problem This seems like bug to me also.  I will file a bug against the product. As a workaround, you can execute the T-SQL directly, such as db.ExecuteNonQuery( "create table tb (id nvarchar(max))" ); Peter ...Show All

• .NET Development What has changed in xsd.exe from beta2 to .net 2.0 final?

  I have a bunch of schema files that generate working .cs files using xsd.exe in .net2.0 beta2, but in net2.0 final I get errors related to xsd:import and schemaLocation. Tried to find out changelist myself but didn't, so decided to ask here. The schemaLocation attribute on xsd:import was never officially supported by xsd.exe. We experimented with adding this support in .Net 2.0 Beta 2, but had to pull it back because it caused certain problems that were uncovered during beta testing. You may work around this issue by including all relevant .xsd files on the xsd.exe command line. ...Show All

• SQL Server Copy Table from another table

  How to create a Table from another Table I need both structure and data If any one know pls rply bye murali murali@gsdindia.com The simplest method of all for doing this is to simply use the SELECT INTO statment. Here's how: Suppose you're trying to copy the authors table of the Pubs SQL Server database with data and structure. To do so simply use this SQL script: ----------------------- USE Pubs GO SELECT * INTO copy_of_authors FROM authors GO ----------------------- Executing this script will create a table named copy_of_authors containing all data from the authors table. Regards, Ejan ...Show All