DQM's Q&A profile

• SQL Server Increase activation time

  Is there any way to increase the activation time, i.e. the time between service broker creating a new instance of the activation SP. Not that I know of, but what you can do is use a conversation timer to simulate a delay.  The way I've implemented this kind of thing is by using a persistent queue.  The activation proc immediately returns if the incoming message is not a conversation timeout (and since the queue is persistent, the message stays around).  If it is a conversation timeout message, the proc grabs the old message still sitting on the queue and processes it as needed.   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.h ...Show All

• Microsoft ISV Community Center Forums Can you use VBA to access a spread sheet embedded in a word doc?

  I am trying to use VBA code written in MSWord to access an embedded spread sheet. I can't find any documentation on how this is suppose to work. Does word access the sheet through an instance of excel Is the sheet part of the document so I can find it in the "ThisDocument " I have tried everything I can think of, so any help would be appreciated. Andy - I haven't done this in a while, so I may have skipped a step or two. I only tested it in the Immediate Window, which is like stepping through the code. Word is more flaky than PowerPoint for programming to an embedded OLE object. PowerPoint doesn't make you activate the object. In 2007, this only works on objects which were inserted u ...Show All

• SQL Server Permissions needed to run SSIS Package

  If one of our SSIS packages fails because of a communication problem with the backend, and the DBA is not available, my boss wants another individual (probably a senior programmer but not an "sa" type) to be able to re-run the job. What is the "right" way to do this under SSIS\ sql 2005 TIA, barkingdog ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Done :)

  Hello, I just wrote a little puzzle game (Windos Game Project) and now I want to build the 360 version of it, but I have a little problem (probably PEBKAC *g*) I wrote a content-processor for instanced rendering (overriding ModelProcessor) and implemented a new ContentItem called 'Font'. It reads the *.fnt files from AngelCode Bitmapfont Converter. Because I want to reuse this, I put it into a "Windows Game Library" and everything works fine.. Now, if I try to put my custom content stuff into a XBox 360 Game Lib, the build process told me, that there exists no "TargetPlatform" enum - which is needed for the serialization methods. After thinking about it, I realize, that I wouldn't make sense that th ...Show All

• Visual Basic Standard Deviation

  Try as I might i cannot figure out how to code the Mean & Standard Deviation HELP!! The mean = The sum of scores/n Dim sum as Integer For I as integer = 0 to n-1 sum += score(i) next Dim mean as double = sum/n The standard deviation is the square root of the sum of the difference of scores from the mean Dim SumX as double For I as integer = 0 to n-1 sumX += (mean - Score(i)) next dim sd as double = math.sqrt( Sumx/(n-1)) ...Show All

• Visual Studio 2008 (Pre-release) DataContract issue

  Hi, I want to design a simple ServiceContract that has an OperationContract like this: [ServiceContract()] public interface IClientPublisher { [OperationContract(IsOneWay=true)] void Publish(object message); } I want to be as generic as possible here, I don't know who is calling me, all I have to do is save the message to disk. Is this possible When the client[1] invokes the method, I get this error There was an error while trying to serialize parameter message. The InnerException message was 'Type 'ConsoleApplication1.Order' with data contract name 'Order:http://schemas.datacontract.org/2004/07/ConsoleApplication1' is not expected. Add any t ...Show All

• Windows Live Developer Forums Windows Live Contacts Gadget beta release!

  I'm pleased to announce that the Windows Live Contacts Gadget has been released to beta! The Contacts Gadget allows end users to access their Windows Live (Hotmail + Messenger) contacts in the context of third-party web sites, and use those contacts with the web site. It's easy to add the contacts gadget to your web sites - just reference the .js files on dev.live.com, copy one channel.htm file to your web server, and write a little code to construct the contact gadget and respond to its callback events. More details can be found here: http://dev.live.com/contactgadgets I'll be posting articles and code samples over the next few days on my blog . If you have any questions, feel free to ask! -Danny Good product, ...Show All

• SQL Server Search and Replace only replaces one Char per field

  I am attempting to find quotes (") in a column and replace with the string '--THIS-WAS-QUOTES--'. Right now my script only converts the first quote it finds in the description column, converts to the string and moves to the next row leaving the other quotes as they were. Below is my query script DECLARE @find varchar(8000), @replace varchar(8000), @patfind varchar(8000) SELECT @find = '"', @replace = '--THIS-WAS-QUOTES--' SELECT @patfind = '%' + @find + '%' UPDATE Incident SET description = STUFF(convert( varchar(8000), description ), PATINDEX( @patfind, description ), DATALENGTH( @find ), @replace ) WHERE description LIKE @patfind ...Show All

• Windows Forms Window class name is not valid.

  I get this error about 75% of the time I try to debug in Visual Studio 2005.  I have reinstalled VS and applied the latest service pack with no relief.  It never happens if I run without debugging, only when I try to debug.   It happens with every project I create, it's not isolated to a single project or solution.  Any help is greatly appreciated. It’s always thrown on this line (or equivalent): public static void Main( string [] args) { Application .Run( new MainForm ()); } System.ComponentModel.Win32Exception was unhandled   Message="Window class name is not valid."   Source="System.Windows.Forms"   ErrorCode=-2147467259   NativeErrorCode=0 &nbs ...Show All

• SQL Server Windows integrated logins across machines

  HI, I've got the folloing scenario: Client app is a windows forms app on client machine. Web Service on a dev machine (Windows 2003 standard), SQL Server 2000 on a seperate machine. The user logs on to the using their windows login. I'd like to pass these credentials to the web service, have the web service impersonate the user and access the SQL Server with these credentials... not a problem I thought. Setup windows integrated login on IIS for the web service, impersonate="true" in the web.config, Mixed mode on the SQL server. Passed the network credentials through to the Web Service, and this works correctly, however when the web service (impersonating the user) tries to access the SQL Server, I get the message about a ...Show All

• Smart Device Development DAAB for Smart Device Application

  Hello Experts, Can we use Data Application Block to communicate to the Sql Mobile in a Smart Device Application, is it compatible to System.Data.SqlServerCe Regards, Suman Ghosh Hi Suman You should consider using the 'Mobile Client Software Factory ' as this is designed for mobile applications. Michael ...Show All

• SQL Server Using variable in DataReader's SqlCommand text

  I'm attempting to configure a DataReader's SqlCommand text to use a package-level variable and I'm having trouble. I've read about using the "sql command from variable" option but although I see that during the configuration of Ole DB source, I don't see the same option for DataReader source. Viewing the properties of the DataReader and selecting the SqlCommand property does have button to configure the value but only displays a string value editor window. (I was hoping for the expression editor.) The configured connection to the DataReader uses the odbc Data Provider (under .Net providers). I'm connecting to mySql, if that matters. What I'm looking to do is to use a variable in the where clause of the DataReader's SqlComma ...Show All

• SQL Server SQL Server 2005 Express

  I installed SQL Server 2005 Express without issues. During installation, I wasnt asked for server name or password for SA. I look at installed programs, SQL Server 2005 shows up. But under Administrative Tools - Services, I dont see SQL server services. Upon launching studio 2005, it seems to work find but with no local server. I am able to register other SQL servers on the network & query them using the studio installed. but there is no local server. Any help is deeply appreciated. Thanks in advance. hi, if you do not instruct the wizard to "show advanced settings", a named instance named SQLExpress will be installed.. that's to say you have to access ComputerName\SQLExpress instance in your scenario.. and onl ...Show All

• SQL Server Help with finding last record!

  I have two columns - code (nvchar) and date (datetime) within an sql 2005 table. The code contains a list where the items are duplicated and I need to search for each item for the newest date and if the date is older than 180 days to display that record. Was relatively easy using the Last function but this does not exist now. Any help would be appreciated. TIA Try something like this: select Code , max ( date ) - ( This will give you the most recent date) from table_1 (- Your table) where date <= 01 / 01 / 2006 - (make this date 180 days ago) group by Code ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. WOW!! Difference between running the EXE and from within GSE

  I've just been playing round writing my sprite class. I already had what was effectively a parallax star field using textures that were 151x68 (some old rockets from when I did Dexters Lab on the GBA) using a custom class but I wanted to try my new generic classes. Each rocket was scaled by speed value to push the slower ones into the distance and each one was tinted to make the distant ones darker. So that's scaling and colour transformations at the same time. The whole lot was sorted by speed to make sure the faster ones appeared on top. Nothing fancy but it was doing quite a bit of donkey work. I decided to start pushing the code to see just how many it would move. From within the GSE, at 200 it was jerky and not very pleasant. I ...Show All