Embirath's Q&A profile

• SQL Server better table management (partitions?)

  Hi, For my work I am now learning Sql server 2005 and I have been given a database that has been set up by someone else to work with. It is my job to get the database ready for use in reports. My problem is that the current database has one huge table with almost 8GB of data. The table contains data from 2004 to present (and growing) from 14 different countries. The reports we use are mostly per country, but we also want to compare the 14 countries to eachother for say, whole 2006.  At the moment the table is stored in one single file instead of using partitions. I believe partitions can give a good performance boost when running the queries. But how do I do this Currently the country codes are just plain text, can they be us ...Show All

• Visual Studio Tools for Office Serialise Building Blocks and 'load' them while 'online'

  Visual Studio in conjunction with Word 2007 gives great opportunities to automate building of documents from XML 'components', but it all seems only possible 'offline', i.e. when the document is closed. I would like to get XML fed into the document (or attached template) while it is open, for example, to update not just content, but also the structure of the document at a user's request, interactively, for when a brand new disclaimer is developed and the user decides to adopt it. Currently, XML properties are read only at runtime and building blocks can only be .Added from ranges (i.e. 'recorded like old autotexts). Can anyone please correct me if I'm wrong or let me know of a possible solution Thanks so much for any help! ...Show All

• Visual Basic Richtextbox and Telnet Window Size

  I'm trying to build into an application some telnet emulation using VB.NET 2005. One of the options I need to cope with is the Window Size option, which equates to the 'output area' height and width. The 'output area' in question is a rich textbox where the font is configurable. I've noticed that a font has a height property, but I can't see a width property. Does anyone know how I can get the number of characters in height/width of the RichTextBox that can be displayed based on the Richtextbox height/width Any help appreciated! not sure if this is what you are looking for...but maybe it will help: Dim x As Integer = 1 Dim g As Graphics = Me . RichTextBox1 . CreateGra ...Show All

• Visual C++ TCP/IP in VC++

  Hi all, Does anyone know a function or class I could use to send files over a network using TCP/IP (in vc++). Even pointing me to a site will help. Thanx in advance Regards Programm3r You need to use Winsock. Here's part-3 of a beginner tutorial I wrote a while ago where I show how to use a custom protocol top transfer files :- http://www.codeproject.com/internet/winsockintro03.asp ...Show All

• SQL Server uniqueidentifier to int forbidden, why?

  xp (sp2) using Management Studio I want to alter a data type for a field but sql denies my operation. why How do I tia You can't convert an INT (4 bytes) to a UNIQUIDENTIFIER (16 bytes), or vice versa, since there's no representation of a UNIQUIDENTIFIER as an INT. If you have data already in your columns, then you can't convert that data to a UNIQUIFDENTIFIER. ALTER your table to add a new column, and drop the old one. Thanks, --R ...Show All

• Visual Studio creating a report using a stored procedure that builds a #table

  Hi there, I have built a report in the report designer (VS2005) that references a stored procedure in the database.(MSSQL) the stored procedure builds a resultset in a temporary table (#table) which slowly collates a fair amount of aggregation on values and the final step is: select * from #table. the report designer is giving me an error saying that the object does not exist - sql server error 208 - in preview mode. I assume this means the #table (it is specified in the error message). when I run the query in the data tab - with the appropriate parameters - the data comes back correctly. I had no problem with the designer when the stored procedure was querying tables directly (before I added the calculations) any idea how I can overcome ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 3DS to X (or FBX) Model Conversion Software

  Does anyone know of a good freeware or (inexpensive) shareware conversion app that faithfully converts from 3DS to X format I'm not a modeler, nor can I afford a good modeling program with a plug-in, so a good free utility would rock. Thanks! Ethan Try : - Autodesk .fbx plugins/converter (free at their website) -the x. file exporter from the DirectX SDK (works also with 3DS 8) -Panda DirectX Exporter -KW X-Porter (free, search in the XNA GSE Forum for the dl link cu,gonzo883. ...Show All

• Visual Studio VS 2005 SP1 Beta doesn`t want to install

  I`m not commenting the decision to use windows installer patching system right now (long story short: 1GB of memory wasn`t enough), but after an hour or so the installer doing who knows what atm just died with a very informative message: The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2908. The number was different the first time I think, when I ran out of free space. And as I click OK it just keeps poping again and again. Oh, wait... it`s stopped after 40- or 50-something clicks. Now, after some time, we have this: Error 1935.An error occurred during the installation of assembly 'CppCodeProvider,Version="8.0.0.0",PublicKeyToken="b03f5f7f11 ...Show All

• .NET Development Remoting - GetChannelSinkProperties - error IDictionary requires to 2 type arguments

  Hi readers - <moved to this new thread> The following code is widely quoted (text book and web) as how to send credentials over to IIS for Windows authentication: IDictionary channelProperties = ChannelServices.GetChannelSinkProperties(amazingRemoteObject); channelProperties["credentials"] = System.Net.CredentialCache.DefaultCredentials; However, this results in the following error: Error 8 Using the generic type 'System.Collections.Generic.IDictionary<TKey,TValue>' requires '2' type arguments P:\Projects\Visual Studio 2005\Projects\TestServer\TSConsole\Program.cs 30 17 TSConsole I can declare the types for the generic using <sometype, sometype> syntax but I don't know what types the pro ...Show All

• Visual Studio 2008 (Pre-release) Change backcolor of disabld control

  Can we change the backcolor of textbox control in Xbap application in framework 3.0 if yes How.... You can change the template in the style, for ex. in the following when the textbox is disabled, background will be yellow and foreground blue < Style x:Key = " Style1 " TargetType = " {x:Type TextBoxBase} " > < Setter Property = " SnapsToDevicePixels " Value = " True " /> < Setter Property = " OverridesDefaultStyle " Value = " True " /> < Setter Property = " KeyboardNavigation.TabNavigation " Value = " None " /> < Setter Property = " FocusVisualStyle " ...Show All

• Windows Live Developer Forums The Driving Directions script does not work.

  Hi, I am working on the script that displayes the "RouteItenary" Class and whenever I implement it the map does not display. I searched for Javascript errors but there was none. How do I fix this Well, at least I thought it was a bright idea.   Funny how that code keeps getting changed on us. Anyway, the lightbulb that I changed was supposed to be  bracket-i-bracket: [ i ] without the spaces. ...Show All

• Software Development for Windows Vista Parenthesis in Rule Condition Editor

  It seems as if the Rule Condition Editor is inconsistent in handling parenthesis in conditions. If you add parenthesis to your condition in order to clarify the precedence of a compound condition, sometimes they are persisted, other times the editor removes them as you press OK. The behavior appears to be that if the parenthesis are placed where according to the default order of precedence (e.g. AND takes precedence over OR), then the editor removes them. If you use parenthesis to specify a non-standard precedence, then it leaves them. I would prefer that the rule condition editor leave things the way I entered them, even if they duplicate default behavior. Some of us like to document default behavior by explicitly entering things like pa ...Show All

• SQL Server Cascading Multivalue Parameters fail to populate in subscription view

  SSRS - SP2 We have many reports with cascading multivalue parameters. The reports and the parameters work as expected within the BI development and when deployed to the RS server. The issue we are having is that when we go to the Report Manager webpage for one of these reports and create a New Subscription the report parameters in the subscription field fail to populate. The first one or two parameters may properly populate but the 3rd, 4th, and 5th fail to populate. As a result we can not select the parameters to submit the subscription. We have two example reports where one report uses only sql (text) and the other report uses only stored procedures. Both reports have 2 or more cascading parameters. Any known issues with cascadi ...Show All

• Smart Device Development how to detect if phone is "turned off"

  Hi folks, Some of our customers have reported a strange intermittent problem with thier WM5.0 devices. Apparently our application loses it's GPRS connection, and when the user tries to make a call, they are informed that the phone is "turned off" and they are asked if they want to turn it on. Once they do that, our app reconnects and starts sending data again. The app works fine after a device starts up, this happens after the device has been working for a while, it's almost like the device has gone into flight-mode. 1. Any ideas why this might be happening 2. Is there a way we can programatically (vb.net 2005, .netCF 2.0, WM5.0) check to for this condition and turn the phone back on Our app will try to send data ev ...Show All

• SQL Server ROLLBACK TRANSACTION

  Hi everyone, In the following T-SQL code snippet,when I attempt to insert more than one record I encounter an error because of the following trigger but I have some doubts about the performation of ROLLBACK TRANSACTION in here. So there is only one transaction occured in the specified table that contain both trigger and the specified table however I supposed that when we call ROLLBACK TRANSACTION, the transaction is aborted. But the code run the Raiserror statement which is located in after the ROLLBACK TRANSACTION statement. So why do this code( Raiserror) is run Should not it be terminated because of the ROLLBACK TRANSACTION statement ALTER TRIGGER kimlikNo_Degistir ON Bilgi FOR INSERT AS IF(SELECT COUNT(*) FROM Inserted) > 1 BEGIN ...Show All