Renderflash's Q&A profile

• SQL Server Determining the number of Active users logged into a SQL Server Database

  How does one Determine the number of Active users logged into a SQL Server Database I want to use the info to control concurrent licensing for my Application This query will give you a count grouped by DB, you can also use sp_who or sp_who2 select db_name(dbid),count(*) from master..sysprocesses where spid > 49 --everyting below 50 is SQL Server itself group by db_name(dbid) Denis the SQL Menace http://sqlservercode.blogspot.com/ ...Show All

• Visual C# A common application for recursion

  Hi, A common application for recursion is the problem of generating all possible permutations of a set of symbols. For the se consisting of symbols A,B and C there exists six permutations - namely, ABC, ACB, BAC, BCA, CBA and CAB. The set of permutations of N symbols is generated by taking each symbol in turn and prefixing it to all the permutations which result from the remaining N-1 symbols. It is therefore, possible to specify the permutations of a set of symbols in terms of permutations of a small set of symbols. How to write a recursive function program for generating all possible permutations of a set of symbols using C#. Thi ...Show All

• Windows Forms Exposing User Control Properties and Methods to IE

  I have created a WinForms UserControl and it loads and displays in IE fine. I'm adding an external interface so that it can be 'driven' by JScript in IE.  <OBJECT id="wvf" height="500" width="800" classid="http:\WvfClient2\WvfCtrl3.dll#WvfCtrlNS.WvfCtrl3" VIEWASTEXT> <PARAM NAME="DataSourceURI" VALUE="http://localhost/"><param name="PatientID" value="wvfClientNet/TestWav. ...Show All

• Visual Studio Express Editions header file problem

  I've created my own header file in an MFC project. The reason is I want to use some functions for more classes. But the compiler says: Linking... ServerDlg.obj : error LNK2005: "unsigned short __cdecl calcChecksum(char const *)" ( calcChecksum@@YAGPBD@Z) already defined in ClientDlg.obj Zadanie2.obj : error LNK2005: "unsigned short __cdecl calcChecksum(char const *)" ( calcChecksum@@YAGPBD@Z) already defined in ClientDlg.obj Zadanie2Dlg.obj : error LNK2005: "unsigned short __cdecl calcChecksum(char const *)" ( calcChecksum@@YAGPBD@Z) already defined in ClientDlg.obj as if the function wa ...Show All

• Visual Studio Team System Make domain\TFSSETUP run a WebService.

  Hi, I made one web service and it is called by Notification Service. But "NT AUTHORITY\NETWORK SERVICE" is running the web service and it doesn't have permission to connect to my Team Foundation Server and create one WorkItem. I think i can i solve this problem if i make domain\TFSSETUP runs the web service, but how do i do that Thanks! The identity that a web service runs as is controlled by a setting on the Application Pool for the web site under computer management. ...Show All

• SQL Server about bcp

  Hi all, I would like to know about bcp. The input file (in parameter) must to has \t to separate the columns Is there a way to choice the separator simbol for example the file: 1;Test1;active; 2;Test2;active; 3;Test3;inactive; Yes, there is a command-line parameter "-t" which can be used to specify a field terminator. See Books Online for more details on the command-line options of BCP. http://msdn2.microsoft.com/en-us/ms162802(SQL.90).aspx ...Show All

• .NET Development Collection events

  Hi, just wondering if it is possible to have a collections base class send an event to the collection. Not worded well but heres an example. Class Tree Property color Property species Class TreeCollection property ColorCount property SpeciesCount This is very basic but what I want is if the color of a tree changes an event is fired that the collection sees to reset its count of trees with a certain color. Hope this is clear enough Regards Hi! Add to Tree reference to the collection it is in. If Tree changed, it can call collection for update. This is better than events, because events require to attach/ ...Show All

• Visual Studio Team System What is the criteria for running web validation rules?

  I have a web page that references a gif file, however the file is not there. This shows up in the results when I run a web test. If I add a validation rule it appears that the validation rule is not run, however if I add a validation rule where I do not have a missing gif file it appears to be fine. Tom I did not see this. Here is what I did. 1) I have a web site and I recorded a web test against the home page. 2) I renamed one of the gifs 3) Played back the test and verified the test failed because of the missing gif. It did fail 4) Added a validation rule to the request 5) Played test again and this time the request failed and ...Show All

• Visual Studio Express Editions runtime redistributable?

  Hi, anybody know where I can find the runtime distributables described in "redist.txt" which is in the folder "c:\Program Files\Microsoft Visual Studio 8" Thanks,     Andres Yes you are right! I just revied the SDK docs about private assemblies: http://msdn.microsoft.com/library/default.asp url=/library/en-us/sbscs/setup/private_assemblies.asp There are more locations but the solution you are searching for is not available. Take care! If you place a CRT DLL in more than one directories and you use all those applications at the same time. the CRT DLLs are not shared if the CRT DLLs reside in di ...Show All

• Visual Studio Team System Synchronization of two TFS?

  Hi, I'm wondering if there is a possibity to synchronize 2 team foundation servers I want to synchronize a project (worked on on both tfs) every day or so. thanks, Rhapsy There is nothing out of the box. It would depend on the circumstances, but it would be possible in a simple scenario to do some syncronization programatically ...Show All

• .NET Development Simple remoting program throws system.security.securityexception

  I am fairly new to .NET and am having trouble getting my head round all the security aspects. I have written a very simple remoting application in C#. The server exposes a method which returns a string. The client calls the method and displays the string. I have a two PCs on my LAN: my main desktop running XP SP2 and a laptop running W98 with .NET1.1 added. I can run my app on these two PCs either way round and it works fine. The server consists of a host .EXE and a server.DLL. The client is a standard windows .EXE form app - all standard stuff (the remoting is configured programatically not using XML so there is no config fil ...Show All

• Windows Forms VB Help Plz

  Am trying to make a button on a start page to go to my other vb file how do you do this plz put a the code to do it Hey Thanks and just to let you know am planing on buying a book but I have VB 2005 Express and most books have not came out for it Thanks again. ...Show All

• SQL Server Problems With SQL 2005 SP1 (x64)

  Hi, After installing SP1 onto our SQL x64 2005 box (running Server 2003 x64 R2), I have come across two problems. The first is that the install seems to fail for database services (and I see I'm not the only one), declaring the following: I haven't had a problem across a suite of x64 installs here at the bank. Disk space can be an issue as the SP install seems to require a lot. You can also run into problems if you have removed the security groups that SQL installs - there's another thread on this on this forum. ...Show All

• Microsoft ISV Community Center Forums Why Excel 2003 keeps PivotItems with zero record count after refresh?

  After a pivot table is refreshed, if some pivot item is no long exist in a pivot field, the pivot field drop selection still show that pivot item to allow user to select.  Selecting this kind of pivot item will lead to no data showing at all. This is no good. I perfer Excel will remove zero record count pivot item from the pivot field drop down selection box after a refresh. (I don't mind Excel keeping zero record count pivot item internally (this is good to preserve manual sort order of pivot item -- one refresh may return zero record for a pivot item, next refresh may have some records returned), but never show this pivot it ...Show All

• Visual Studio VSS 2005 can not show history.

  I'm using VSS 2005 and VS2005, both version are 8.0.50727.42. I'm using VSS Explorer. The "Show History..." does not work. No any results when I choose a long period. I tried to empty "From" and "To" fiels, the result is same. Any idea Thanks in advance. I'm experiencing the same problem. I've recently upgraded to the RTM version of VSS 2005 (was previously using the Beta version, and 6.0d before that). I've observed that any databases that I created with the 6.0d client work properly. I can view the history of files, see their dates and labels, etc. Any databases I created with the 2005 Beta or now with 2005 RTM, History functional ...Show All