vitich's Q&A profile

• SQL Server Set QUOTED_IDENTIFIER and ANSI_NULLS on all objects...

  Is there any way via T-SQL to run through a database and ensure that QUOTED_IDENTIFIER and ANSI_NULLS is set for all stored procs and functions etc on a database without having to recreate every proc / fn The reason this is an issue is I'm trying to take advantage of indexed views to get a performance increase in an application - but not all of the procs/fn's have historically been created with ANSI_NULLS and QUOTED_IDENTIFIER set - so any proc that's not set correctly will fail once the indexed view has been created. I could I suppose, script out all the procs / functions and do a bit of search and replace to ensure that these are set correctly by recreating all procs and functions - but I'm trying to avoid doing that as I've over 500 da ...Show All

• SQL Server how to generate as "enter" function in SQLSERVER?

  For example: select 'sp_refreshview ''' + [name] +''' go ' from Sysobjects where xtype='v' order by [name] I want the result is follow: sp_refreshview 'lt.trxdetai' go sp_refreshview 'ps_account' go thanks Modify your statement to add char(13) as shown below select 'sp_refreshview ''' + [name] + '''' + char ( 13 )+ 'go ' from Sysobjects where xtype = 'v' order by [name] Regards, sam ...Show All

• Visual Studio 2008 (Pre-release) How to solve this problem when we transform a picture?Help me

  The formatter threw an exception while trying to deserialize the message: Error while trying to deserialize parameter http://tempuri.org/:GetUserPhotoResult . There was an error deserializing the object of type System.Drawing.Bitmap As already mentioned in the other thread, it looks like you need to adjust the readerQuotas on your binding. From the SDK: Gets or sets constraints on the complexity of SOAP messages that can be processed by endpoints configured with this binding. The complexity constraints provide protection from denial of service (DOS) attacks that attempt to use message complexity to tie up endpoint processing resources. Other complexity constraints include items such as a maximum element ...Show All

• Visual C# Better than 15.625ms timestamped Mouse-Hook Logging of events

  Hi Folks, Currently I have a Low-Level-Mouse-Hook in place in my program and get all events properly, all nicely timestamped by the milliseconds-since-startup counter. So: I'd think I'd be in the clear. What I observe in my event-log is that the events are grouped each 15.625ms on average due to the system clock resolution (checked to be @15.625ms using www.sysinternals.com 's clockres.exe). How can I get a better resolution there (1ms preferred..) - I tried NtSetTimerResolution from the NTDLL.DLL to no avail.. - I tried running the process realtime and that didn't help either. - I tried the SetSystemTimeAdjustment and again no result Any clues to the why I am about to revert to having some high-performance-counter- ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Vibrate the controller for 1 second?

  Hi, I've just starting playing around with XNA for xbox 360 and have a noob question I want to vibrate controller 1 for a single second. I know to set vibration on I can use the code: GamePad .SetVibration( PlayerIndex .One, 1.0f, 1.0f); and to turn it off: GamePad .SetVibration( PlayerIndex .One, 0f, 0f); But how do you set the length of time for it to vibrate I have experience in programming with C++ but have not yet had the chance to fully immerse myself into C#. Thanks You could also try something like setting the value in a static DateTime object when your start the motor, and then use a TimeSpan to find the number of seconds that have passed since the rumble ...Show All

• SQL Server Hierarchal data reports

  I have set up a hierarchal report, which is based on one data set using a table and grouping. I have a group header, a details, and a group footer section in the table. The details is filtered based on one of the columns, and hidden with the ability for the user to expand and collapse the row based on one of the fields in the group header. My problem is, I am trying to set up a report which gets scheduled to run weekly, and emailed out to its users, in PDF format. The PDF format will not allow the user to expand and collapse the rows. I would just send the users a link to the report, and the can expand / collapse the rows they want to see, if they didn't mind having to be connected to set up their report, and having the extra step of expor ...Show All

• Visual C# Receiving data sent from a C++ socket...

  Hi, In C++, I wrote a small send function which sends a string through a socket as the following: void Send(string input) { char buffer[512]; strcpy_s(buffer, input.c_str()); if (send(sock, buffer, sizeof (buffer), 0) == SOCKET_ERROR) return ; } I want to receive the above data in C#, but how I tried many code snippets but none of them worked. Can you please help me Thanks at all... Hey yabansu, One way to receive the data would be to use a TCPClient. For a full example see: http://www.csharpfriends.com/Articles/getArticle.aspx articleID=69 A simple demo would be: TcpClient tcpClient = new TcpClient("hostname",port); NetworkStream networkStream = tcpCl ...Show All

• Visual Studio How would you improve MSBuild?

  Hello MSBuild Users, Just a reminder that we're always interested in suggestions for improving MSBuild. For small suggestions, the best route is via opening a suggestion at https://connect.microsoft.com/feedback/Search.aspx SiteID=210 . If there's a small change or improvement you'd like to see, that isn't really a bug, I'd encourage you to open a suggestion there: we can track it, and if it's possible, appropriate, and we have time, we'll address it. For big suggestions ("please implement distributed build", "please add native code support") that's probably not a good way. Instead I'd suggest you let us know via this forum -- for example, by replying to this post. The team would like to know what's important to you and wha ...Show All

• SQL Server Query Results to Text

  With Query Analyzer I would run queries that returned text results that I would output to a text file. When I run the same queries using SQL Server 2005, the text output files are twice as large and the are non-printable characters visible between each printable character. It turns out that it's inserting a hex 00 between each charcter. How can I turn this off I need straght ASCII text output files. Thanks in advance,, rdomo Thanks Louis, that corrected the problem exactly. Kind of a pain to go though these additional steps/mouse clicks to get the job done. I thought i had something to do with Unicode characters and was thinking I had missed some configuration setting during the install. Ralph ...Show All

• Audio and Video Development Will Media Foundation support HD/BD?

  From the feature list of Media Foundation on http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnwmt/html/t_d_migrating_from_directshow_to_media_foundation__cyor.asp we can find in section "Media tasks" that Feature group Feature Media Foundation DirectShow Media tasks DVD playback and navigation No Yes That means MF is not going to support DVD. But what about the new generation of DVD Like BD and HD They both have navigation mode and are supposed to be "premium" content. Does the "DVD playback and navigation" here means MF will not support medias with DVD-style navigation, or only traditional D ...Show All

• Architecture usb driver programming

  How can I program a usb driver for windows I am building my own electronic usb peripheral. Exepted the hardware aspect, how can i make windows to identify and handle the peripheral To create a driver you'll need to use the Windows DDK (Driver Development Kit). Last I remember, it contains two or three USB-related sample drivers you can use as a starting point. You might get better information on the microsoft.public.development.device_drivers newsgroup, btw. ...Show All

• Visual Studio 2008 (Pre-release) How to listen for property changes on bound targets in a DataTemplate ?

  I'm creating an editable DataGrid derived from ListBox and want to get notified when the user first edits a bound element in a ListBoxItem (the empty new row at the bottom). In other words I want to hook into PropertyChange notifications on bound targets in the DataTemplate. There doesn't seem to be any way to do this. My next thought was to grab all the Bindings in the container and add a dummy ValidationRule but I can't see an easy way to get the bindings without looping through every DependencyProperty on every element in the container. I don't want to use SourceUpdated notifications because 1) I think this comes too late for my purposes and 2) it requires the DataTemplate designer to remember to add NotifyOnSourceUpdated=True to ...Show All

• Visual Studio 2008 (Pre-release) Queuing in NetMsmqBinding?

  Hello I am not sure if the NetMsmqBinding is helpful in my scenario, maybe someone could give me a hint: I have a web method which takes an array of data items. This web method can be called many times within a short period and every passed array can contain hundreds of data items. These data items have to be put into a sinlge queue (even if they are passed in separate calls). From this queue a worker process makes packages of e.g. 50 data items which are then consecutively processed (with a pause between every package). Example: The web method is called twice within a second. In the first call 70 items are passed, in the second call 90 items are passed. The queue then contains 160 items. From this queue the worker process make ...Show All

• SQL Server counter of the group by statment

  hi, Lets say I have a table called test create table test( number int, [str] nvarchar(50) ) table content, for example: 8,'a' 8,'b' 8,'c' 5,'a' 5,'h' I want to get a result with one more column that indicates on the asc counter of the group by clause. i.e. somthing like this: number     counter 8,                 1 5,                 2 and so on... it does not realy matter regarding the query - All I want is to add one more column to the query that indicates on the count of the group by.so if i have 2 rows ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Pay to play a friends game?

  Ok srry if this has been asked or adressed already, I did not see it, so if I DL the launcher on the 360, and a friend of mine has the membership and all that other stuff and makes a game, I have to have a membership as well just to play Because I find it kinda dumb if I have to pay $100 to play a friends game, (If I were not to be making games and such and just wanted to play others games). It seems a bit much for me if i wanted to do that. BTW I plan on getting it and trying to make a game anyway I just want to know if this is the case. Srry if this is posted in the wrong area. Currently, yes, you need a membership in the Creator's Club to play XNA games. This is not the permanent implementation however ...Show All