TalYam's Q&A profile

• SQL Server How can I programmatically tell if agents are running?

  Ideally I am looking for a procedure that I can call in T-SQL to verify that the Log Reader, Snapshot, and Sql Agents are all up and running on a given server. I found the undocumented sp_MSrepl_distributionagentstatussummary proc and got it to work for the distribution agent. I also found sp_MSrepl_agentstatusummary, but I've yet to get this to work. Overall, I'd really like to have a better way to do this. This absolutely must be something callable from the sqlcmd interface. It can not be through a UI nor anthing more complicated than standard T-SQL. Any suggestions Yup, this is a great example of what I was saying about the table not being a reliable indicator of the actual status of the agent. When I ...Show All

• .NET Development Bug: Validating against a schema throws NullReferenceException in XsdValidatingReader

  Validate an xml document against the schema below to reproduce. If you notice that there is a complexType of "string" defined that has a simpleContent extension to "xsd:string". When creating a new complexType "StringType" with a complexContent (not simpleContent) that has an extension to "string" it will generate this NullReferenceException. The error message should state that it's base type is of simpleContent not complexContent. Xml Schema: < xml version="1.0" encoding="UTF-8" > <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <xsd:complexType name="string"> <xsd:simpleContent> <xsd:extension base ...Show All

• Visual Studio Express Editions _CrtDumpMemoryLeaks() in visual c++ express ...

  Hi, I have been trying to get memory leak checking to work for the past few hours but have been unssuccessful. I have created a basic win32 program winmain etc .... and have tried to allocate some memory and then not delete it ... but I can't seem to get it to report the memory leak. The basic idea ... WinMain( ... arguments ... ) { allocate some memory _CrtDumpMemoryLeaks(); return 0; } I've also tried setting the following .... _CrtSetDbgFlag ( _CRTDBG_ALLOC_MEM_DF | _CRTDBG_LEAK_CHECK_DF ); _CrtSetReportMode( _CRT_ERROR, _CRTDBG_MODE_DEBUG ); but nothing seems to be working. Anyone know why its not reporting the leak It is important that you fol ...Show All

• Windows Forms Case study Problems... PLEASE HELP...

  Dear people, I am getting very very crazy. I am trying to make a case study but I just cant do it. In the link you will find the requirements of the case study... I realy hope that you can help me. Its my last case and then I am done.... http://www.vbforums.com/showthread.php p=2766193#post2766193 Ken Tucker wrote: I get an error when I try and open the pdf you attached in the first post. Hello, Thanks for the quick reply. I have tried to open it and it works just fine. Can I send it to you someway Greetz, John ...Show All

• SQL Server Where Find SQL Server Agent

  Dear All, I have installed SQL Server 2005 Express Edition, Iam not able to find SQL Agent, So anybody help me............................ Regards, Vinayak Hello, Can you provide few examples of jobs, scheduled jobs/maintaince Jobs.... As iam new to SQL 2005........ Regards, Vinayak ...Show All

• Visual C# Reading other user data from registry

  Here is a summary of what I am doing: 1. Running C# application as user1 2. Retrieve ntuser.dat file for user2 and load as a hive in registry 3. Reading HKEY_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders My issue is that when performing #3. The ntuser.dat file for user2 has %USERPROFILE%... in it. When the application retrieves this it is returning the %USERPROFILE% variable for user1. So the results from the ntuser.dat file for user2 for Desktop is C:\Documents and Settings\User1\Desktop. This is not an acceptable result. I would be happy with either of the following scenarios: a. The application returns the reg entry as-is: %USERPROFILE%\Desktop b. The application is able to convert the %USE ...Show All

• SQL Server SSAS 2005. x86. Memory Allocation Errors during processing.

  I have an AS2005 on x86 Box with 4Gb RAM with 2 Xeons 2,2Ghz. On the same box runs SQL Server - the data source for AS. If the cube is processed, i can't reprocess indexes and aggregation after dimensions update. I get permanent memory allocation error. The cube size is funny - only 3Mio rows in 13 artitions. Only thing what runs is to make cube unprocessed and full reprocess it. But it brokes one of the businnes requirements, that users can always query the cube with simple queries, though with 10% of performance. Hi Irina. what is difference between " large attribute" and "attribute with a lot of members" Are things the same Yes I have some of them (ca. 3 dimensions with more the 1. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Activator.CreateInstance on .Net compact

  I've got a bit of code that loads an assembly dynamically and invokes a constructor working fine in PC XNA but I can't find the equivilent under .Net Compact on the 360... PC Assembly assembly = Assembly.LoadFrom(s); Type mainClosure = assembly.GetType(scriptName + ".MainFunction"); LuaClosure cl = (LuaClosure)Activator.CreateInstance(mainClosure, new object[] { L.Globals }); Attempt on 360 Assembly assembly = Assembly.LoadFrom(s); Type mainClosure = assembly.GetType(scriptName + ".MainFunction"); ConstructorInfo ctor = mainClosure.GetConstructor( BindingFlags.Instance | BindingFlags.Public, null, new Type[] { typeof(LuaReference) }, null); LuaClosure cl = (LuaClosure)ctors[0].Invoke(new Object[] { L.Globals }); Which f ...Show All

• Windows Forms Add a number of entry schemes

  Hello I am making a system for managing a small library. When I add fx a proceeding (which contains a number of articles) I want to be able to specify the titles and authors of the contained articles. That is if the proceeding contains 5 articles, I want a list of 5 entry schemes on my screen. These entry schemes will have to be added dynamically. Which component or method will be the most useful I have already tried FlowLayoutPanel but didn't find it useful. \Mikkel Several ways to do this: - Use a DataGridView - Make a UserControl with the controls to enter the properties of one article. Dynamically create UserControl instances for each article in a proceeding - Use a ListView with a form to en ...Show All

• SQL Server NULL values returned when reading values from a text file using Data Reader.

  I have a DTSX package which reads values from a fixed-length text file using a data reader and writes some of the column values from the file to an Oracle table. We have used this DTSX several times without incident but recently the process started inserting NULL values for some of the columns when there was a valid value in the source file. If we extract some of the rows from the source file into a smaller file (i.e 10 rows which incorrectly returned NULLs) and run them through the same package they write the correct values to the table, but running the complete file again results in the NULL values error. As well, if we rerun the same file multiple times the incidence of NULL values varies slightly and does not always seem to impact the ...Show All

• Visual Studio Team System Is the TFS Trial download incomplete, or it is me?

  I downloaded the TFS trial edition that was posted on 3/17 expecting it to be the final version. Rather than install it, I did a search on "Aigile" and extracted the MSFAgile_new.zip file so I could have a look at the process guidance and the examples and templates. When I open the process guidance, it says at the bottom of the page that it is build 100, whereas the MSFFormal_new has build 1.000.0000. It seems that there are many examples and template files missing from the Agile (I didn't do the same check with the formal), for example: Scanario List Storyboard Quality of Service Requirement List etc. In fact every file I try from the "See Also" panel give a file not found error, and though not eve ...Show All

• Windows Forms How to compare values from two databases.

  Hello, I have two different databases that I want to compare values from. I was thinking of loading the data into two separate listviews and then comparing the listviews but I dont know if that is the right way to go. Should I be using a datagridview instead Any ideas how to solve this problem. Regards Hi if you want to show something from database to the listview here is an example using Access Hope it help u. lv = new ListView ( ) ; lv.Left = 0 ; lv.Top = 0 ; lv.Width = 700 ; lv.Height = this .ClientRectangle.Height ; lv.GridLines = true ; lv.FullRowSelect = true ; lv.View = View.Details ; lv.Scrollable = true ; lv.MultiSelect = false ; lv.HeaderStyle = ColumnHeaderStyle.Nonclickable ; // ...Show All

• SQL Server install error

  I have tried to change the name of the file in the regedit and I am still receiving the same error that a previous program installtion created pending file operations on the installation machine. You must restart computer before running setup. What do I do now i ahve restarted 3 times. Can you try this 1. Run command regedit. 2. Check whether the the key HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\Session Manager\Pendingfilerenameoperations exists. If yes, please remove it and reboot the machine. Then you can retart installing. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Qs about Multiplayer game

  me plan to do a 2D multiplayer action game. Not plan too far for the MMO, but just a party around 8~20 players at once, something like Counter-Strike/Freelancer, players can travel around in a big map. me never did this before, so that me not sure my logic is correct or not. here my communication flow between [game server] and [client] 1. [client] collect player input and process 2. [client] send player input(or make it simple as command) to server 3. [server] receive client command, process it and boardcast the result to clients 4. [client] client receive server command, process and update my questions is: assume that my client running in 60 FPS 1. what the frequency that me have to collect the input and send the command to se ...Show All

• Visual Studio Express Editions Trouble Creating a Class File

  New to Visual Web Developer 2005 EE, have created a website to learn development, and am having the following problem (with website already opened as a project): 1) File --> New Item 2) Click Class 3) Choose a name for the class file, then Visual Basic selected 4) Click [Add] The studio then attempts to create the folder and file on the server, but gets the following message: "Unable to add the folder "App_code" to the web. Cannot create the folder 'App_code'. This same series works ok on my local machine, but not on the web server. Is this a bug, or is it trying to create the folder in a directory that is higher up than the web site root directory Creating the folder beforehand does not help. Help is ap ...Show All