Zachovich's Q&A profile

• SQL Server The merge process failed to execute a query because the query timed out

  Hi there. I have occasional sincronization error. -XSUBSYSTEM Merge -XSERVER MYSERVER -XCMDLINE 0 -XCancelEventHandle 000006E0 2006 - 12 - 22 14 : 55 : 00 . 833 Connecting to Subscriber 'Subscriber01' 2006 - 12 - 22 14 : 55 : 00 . 895 Connecting to Distributor 'Publisher01' 2006 - 12 - 22 14 : 55 : 02 . 974 Initializing 2006 - 12 - 22 14 : 55 : 03 . 083 Connecting to Publisher 'Publisher01' 2006 - 12 - 22 14 : 55 : 06 . 005 Retrieving publication information 2006 - 12 - 22 14 : 55 : 06 . 130 Retrieving subscription information. 2006 - 12 - 22 15 : 00 : 07 . 222 The merge process failed to execute a query because the query timed out . If this failure continues, increase the query timeout ...Show All

• Visual Studio 2008 (Pre-release) 3d transparency and zbuffer

  Hello, may be you can help me with this. I'm trying to generate a 3d carousel, using a plane and a ImageBrush (png with transparency). When I rotate the carousel I see a render problem and I suppose is generated by the order of rendering, I reorder all the 3d elements every time I render the scene, and it works but it cosumme a lot of processing time. Can anybody know if there's a property to enable z buffer automaticaly Any of you try to make the carousel effect only with Image instead of 3d elements. Thanks a lot !!! Depth comparison is always on. DiffuseMaterial writes to the depth buffer but EmissiveMaterial and SpecularMaterial do not. If all you have is transparent planes, you could make them ...Show All

• Visual Basic Printer compatability library source code ?

  Is the source code available somewhere I don't want to emulate the VB 6.0 printer object - I just want to avoid using the stupid event driven .Net PrintDocument - I want to control page breaks myself - like in the VB Printer model. Having the source code would help. Hi DrinkWater, Printer object is written in VB.Net. It is a layer of abstraction on the System.Drawing.PrintDocument that shipped with VS 2005 . ...Show All

• Visual Studio Express Editions Process volume controller? (audio)

  Hi my appologies if this has been posted before... I am making a program that controls volume of each application individually, just like the new audio controller in windows vista. The only thing I dont know here, is how can I set the maximum volume for a process In other words, I am playing a song and broowsing the internet at the same time. If I want to lower the volume of IE but keep that of WMP high, is it possible And how thanks The thread was moved to the DirectX forums since that maybe a better place to post. There is no direct way of doing this other than using the SDK's for DirectX for example or perhaps some WinAPI for Vista but doubt there maybe one. ...Show All

• Visual Studio 2008 (Pre-release) Syntax for Binding Attached Properties

  Hi, I am trying to bind an attached property to another dependency property. I believe I can do something like this, but I'm not sure what the right syntax is: < ScrollViewer Name = " scvPageViewer " HorizontalScrollBarVisibility = " Auto " VerticalScrollBarVisibility = " Auto " > < Grid x:Name = " PageSizer " > < local:BrickPanel x:Name = " LayoutPanel " /> < local:BrickPanel Orientation = " Vertical " HorizontalAlignment = " Left " VerticalAlignment = " Top " Background = " Gray " > < local:PriorityOffsetPanel local:BrickPanel.Offset = " {Binding RelativeSource={Relat ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Question about location and number of main game objects

  Ok so I'm still starting out with XNA, so apologies if this sounds like a strange question. I'm still getting the hang of the architeture of XNA, and am having trouble working out the numbers and location in the heirarcy of certain important game objects. Im using a GameState style engine for my game, and refer to each "state" as a "screen" This is my current layout... GraphicsDevice - One in main game class, passed through constructors to relevent functions ContentManager - One per "screen", made sense as if a screen unloads then all its content should unload too ( ) SpriteBatch - Currently one for each low level game object (eg, Sprite object, UIElement object) however i think this should be higher up and pa ...Show All

• SQL Server rsinvaliddataSourceReference problem

  Hi, I have some rdl files to be deployed using RS 2005. I have 3 folders viz., ReportFolder1, ReportFolder2 and System Files. ReportFolder1 - contains soem reports ReportFolder2 - contains some other types of reports System Files - Contains the shared Data source All the above folders are present in a main folder called ReportMain In all my rdl files I have given the value of DataSourceReference element as 'ReportMain/System Files/MyDatabase'. Still when the reports are deployed and i try to view any report, I get the following error: The report server cannot process the report. The data source connection information has been deleted.(rsInvalidDataSourceReference). Why do I get this error still Can anyoen help Thanks. Hi SandyJ, ...Show All

• SQL Server Merge Join vs. Lookup vs. Custom Script - which is fastest?

  Very often we have 50'000+ rows which you need to pull values from different source (e.g. CityNames from citycode in Excel file). Currently we are using Lookup - but the questions is which of those 3 options is best in performance wise If you do test the three methods, please post the results here. I am using custom script for lookups (small reference lists but millions of source rows in pipeline) but I would like to know how large reference lists perform. ...Show All

• SQL Server INSRET/UPDATE trigger

  Hi, I user RAISERROR(@Error, 16, 1) in the INSRET/UPDATE trigger, does this rollback record in the table It seems it does and I am wondering if there is any workaround. Thanks, It depends on the severity of the error. You should do RAISERROR with a lesser severity and then do ROLLBACK explicitly. See Books Online topic on RAISERROR and how to use it in triggers in SQL Server 2005. There are several samples that shows how to use RAISERROR. ...Show All

• SQL Server SQL 2005 Express and Visual Studio 2003 - Connecting

  I have Visual Studio 2003 and had used it successfully with MSDE. I recently upgraded to SQL 2005 Express and cannot seem to connect to the SQL server. it appears in the list of servers on localhost, but when I try to create a new database it tells me that it "cannot create databases on this server." It will not even open up any existing databases. I have .NET 2.0 installed. I uninstalled SQL and reinstalled it, but nothing seems to help. I feel I must be missing something, but do not know what. I no longer have the MSDE installation files, so I hope I can get Studio to talk to SQL Express. Any help is appreciated. There is no other server listed within VS 2003. Under Control Pan ...Show All

• SQL Server Replication of check constraints

  I have tables that are replicated using transactional and merge replication. As a result I am unable to use automatic identity management as transactional replication doesn’t seem to understand it. Therefore I have implemented a version of the automatic mechanisms that seems to work in a hybrid environment. It is based on a central table that holds the maximum identity for each table that has been issued to date. Valid identity ranges are issued to each publisher and subscriber as needed in a similar way to the automatic mechanisms and tables are reseeded as needed. I want to enforce the ranges in a similar way to the automatic mechanism using a check constraint similar to this: alter table [dbo].[test1 ...Show All

• Windows Forms Finding controls inside a region ?

  Hi there, I have a problem which I expect to solve here.. Here is what I want to do : I have got 5 sub panels and 1 main panel (all of them containing various controls) .. I want to do simple drag&drop operations on them. To be more clear I will drag the main panel over one of the sub panels. Now, where I stuck is that when I drop the main panel anywhere in the Form a method should check wether there is a sub panel in the region of the main panel. If yes the main panel will transfer its controls to that sub panel. If no the main panel will return to its original position. But also, in the region there may be two panels. In this case the main panel will transfer its contents to the closest one. How can I do such region checks and also ...Show All

• Visual C++ Use of environment variables in Property Sheets

  I'm attempting to create a common property sheet for use in debug and release configurations for each of the projects in my solution. I'd like the location of the common property sheet to be in a place where all the projects can access it. In my build environment, I have an enviroment variable called CURR_SRC_ROOT that points to the source root. (this is needed because the source root is always different from machine to machine as the "view" name is included in the source root). I'd like to have each project refer to the common property sheet using this environment variable (e.g. $(CURR_SRC_ROOT)\Application\CommonSettings.vsprops) This doesn't work. I've looked at Peter Huene's blog about utilizing a U ...Show All

• Visual Studio 2008 (Pre-release) vNext August CTP and Linq May CTP problem on VS 2005 Team Edition

  Hi When install vNext and Linq at home on VS 2005 Pro Edition there is no problem. But when I intalled it at work on VS 2005 Team Edition the error list is full. It can not recognize something like this from c in db.Categories where c.CategoryID == categoryId select c).ToSequence().First(); it give errors like this ' ; exprected' 'invalid expression term 'in' ' and etc. but when I run the app it works fine!!! there is no intellisense in the query and even not recognize the Model Obejct assembly when I type using NorthwindModel although that there is a reference in the project. Like I said when I run the app it works but how to fix this 10x I had a same problem with you. I solved that I just copied &quo ...Show All

• .NET Development Validating schema element from XPathNavigator

  Hi, As I traverse different elements in my XPathNavigator object I come across some elements which I need to check particles such as MaxOccurs against the schema. I can search the schema and find the appropriate element but the problem I have is when the element name in the XPathDocument is not unique. For example, the <name> element could be a child either from the <person> or the <company> element. What should I do to ensure I am validating the correct element Any help would be appreciated. Thank you With .NET 2.0 XPathNavigator has type annotations if you load the XML and the schemas, see the SchemaInfo property . ...Show All