crogenicdude's Q&A profile

• SQL Server Getting CPU and I/O stats from several Sql Servers

  Hello , I would like a script for MSSQL 2000 for collection of utilization data for cpu and ram. I need to have the data from several servers. This data for all servers should be stored in a database. I am looking for 10 minute increments. How can I go about this. Thanks You have several sources depending on the granularity level, collection mechanism etc. 1. fn_virtualfilestats - file level I/O statistics 2. master.dbo.sysperfinfo - SQL Server performance counters for first 99 dbs. You can get these via Windows Perfmon also 3. dbcc sqlperf(waitstats) 4. master.dbo.xp_msver - CPU, RAM, product version etc Now, you can use above interfaces and others to roll your own collection mec ...Show All

• Visual C++ Array maximum size

  type * MyVar = new type[Size]; Does anybody know what is the maximum value of const variable Size I tried to use 0xffffffff and 0x7fffffff but i get a compiler error. I want type to be char ... Note: I use Visual Studio 2005. Win32 project. Thanks in advance. bookysmell2004 wrote: Well, i think that is a limit (2GB or 2GiB) cause of the processor 32-bit architecture... I wonder there will be no problem in a x64 one (of course if the memory installed is more than 2GB). Thank you for the replies. Yes, the 2GB limit is due to the 32 bit arch. 32 bit pointers are not able to address areas >= 4.294.967.296 bytes. Half of this is reserved for sharing between all processes and the kernel, and the ...Show All

• Visual Studio Microsoft(R) Uniscribe Unicode script processor

  Hi, Can someone tell me how to make VS2005 Report Viewer WinForm work with Microsoft(R) Uniscribe Unicode script processor (USP10.DLL) I develop software with VS2005 and .Net Framework 2. My application render complex script without problem but when I want to Print with Report Viewer Winform the complex script can't render correctly. Cheers, Kosona The reason your script not render properly because GDI+ is not capable to render complex script. I am not sure why they do it that way but I hope the future version of .net will support rendering complex script. ...Show All

• Visual Studio Team System branch on a label

  Let me walk you through my scenario which will lead to my question. I recently migrated a large project from VSS to VSTF. We stayed away from branching in VSS, which was probably a wise descision. Now that we have much more sophisitated branching functionality in VSTF, we have started using it. When the project was in VSS it was under the root $/foo. About a week before the migration, we cut a label on $/foo called 1.0.0 (as it was just released to production). I created a "foo" team project and then migrated the project from VSS to VSTF under $/foo/main for the mainline development. I then did a branch from the cut label 1.0.0 and called it $/foo/Rel1-Maint. The interesting thing is that I can't do a merge at the $/foo/Rel1-M ...Show All

• Visual Studio Visual Studio tools menu

  I have an academic version of Visual Studio 2003(the box says standard version). With this version I don't have the tools menu and the command line through the Visual Studio menu. Is there a way to install this option I am using the Enterprise edition in class and it does have the tools menu option. I am taking the Microsoft class 2557 and in this class you need the command line through visual studio. The only thing that the command line shortcut does is set some environment variables and open a command prompt. You could create a shortcut and set the command to: %comspec% /k %VS80COMNTOOLS%\vsvars32.bat If this does not work for you try to search the vsvars32.bat file and specify the full path like: %comspec% /k <full pa ...Show All

• Visual Studio Merge upgraded VSS 6.0d (to VSS 2005) and VSS 2005 databases?

  I have a VSS 6.0d database on one server and a VSS 2005 database on another server. I plan to upgrade the VSS 6.0d database to VSS 2005 version and then consolidate the two databases as seperate projects into a single VSS 2005 database. (I need each project to retain the full history of its check ins\outs, etc) Any pointers on how to do this would be much appreciated. TIA, barkingdog Database format is the same in VSS 6.0 and VSS 2005 so all you need to do is to transfer projects from one database to another. Here is what to do: Stop LAN service on VSS 2005. Run Analyze on both databases Archive one database using VSS Admin Using Restore feature copy this database int ...Show All

• SQL Server Parameter maximum string size question

  Does anyone happen to know what is the maximum string size that can be passed in a parameter w/o it truncating or throwing an error Thank you in advance, As it is implemented as a .NET type (System.String) it could take theoretically up to 2^31-1 chars, but passing the parameter through the webservice or the URL will make you only to have your URL expanded to the maximum of 2083 chars to support all the methods like GET / POST / Webservices. http://support.microsoft.com/default.aspx scid=KB;en-us;q208427 HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Report Formula Issue

  Ok I have a formula that populates a String Variable in my report Group Footer. The main formula is like this. If {cParty} = "S" and {cType}="I" and {fPrimary} = -1 then Seller := TrimRight({.FirstName})+' '+TrimRight({.middle})+' '+TrimRight({LastName}); My table looks like this, and my criteria is that IFolder =123456 IFolder cParty cType fPrimary FirstName Middle LastName 123456 S I -1 John A Roberts 123456 S I -1 Susan G Roberts My StringValue for Seller will only display John A Robert, even though Susan G Roberts is also valid. How do I get it to dispaly the correct values if muliple rows are true statements. ...Show All

• SQL Server Licensing for a web server

  What kind of license do I need to run a single web site on a web server that needs SQL server to operate it's a public site that runs DotNetNuke but it's the only site on that box. If you want to use anything more highlevel than SQL Server Expr. you have to either license every single user (which is complicated if you have a public available website) or use a processor licencse (which turns out to be a *bit* more expensive if you have a small number of users, but I don’t actually know the break-even for that). SQL Server Express is ok for that, for regular backups you can use TSQL statements and schedule them via AT or a similiar Scheduling tool. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Moving reports backward from RS2005 to RS2000

  Is there a nice way to get reports from an RS2005 project into an RS2000 project I know this sounds like an odd request but I have built reports in RS2005 that need to be deployed to a server with only 2000 on it. I don't really want to have to go in and re-draw all those reports. Any ideas would be most appreciated! Thanks, Eva YAY!!!! Thank you, thank you, thank you! for taking the time to post that link. It worked like a charm and I just saved countless hours of work when this literally took seconds a report. You honest, really, and truly made my day Eva ...Show All

• Visual Studio How to execute IronPython on web projects

  Hi, I was downloaded Visual Studio 8 SDK, April V3 this version is supported ironpython on web projects, i see the document so, i tried make a web project, it's very well but, i can't executing and see the error messages are "C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\WebSites\WebSite7\Default.aspx(1): Build (web): 'IronPython' is not a supported language." "C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\WebSites\WebSite7\Default.aspx(1): Build (web): '.py' is not a valid language extension." i think a visual studio is not supported ironpython how think do that, i hope to executing... ok, problem is mine because i ...Show All

• Visual Studio Express Editions vsual basic lesson video

  I am using window XP, I have been doing video lessons for beginners,on Visual Basic 2005 I did not download but did directly from the web page, however it was still using up my data bundle so I decided to download and veiw offline. Have downloaded but cannot find the lessons to run them.Please could you instruct me how to run them once downloaded. thank you. Hi, Had exactly the same problem. I fixed it by using FireFox with the add-on "Unplug". Basically, with this add-on, you go to the page, click the little fish in the top right-hand corner and it opens another page where it gives you the video media that is downloadable. Just select them one by one and save them as you would any other downloade ...Show All

• SQL Server Cannot add or replace data in SQL express

  In this project I m using SQL Server 2005 express edtion.I can run select queries but I couldnt run insert and update query.Is there any protection for adding data to the Sql Server express edition thanks. There is no error or like that.Seems like everythings ok but I go to the database, there was no changing. Are you sure that you are working on the right database file. Probably your changes are valid, but when you try to validate those changes, you are checking some other database file. When working with SQL Express you should be precocious about this things. ...Show All

• Visual C# Using assignment in an if/while/ condition?

  Hey all,   I am currently working on a rather large product and am nearing completion, and I was currently working on some of the Excel/Word conversion and IO routines and I thought to do something like this... StreamReader sr = new ...blah blah blah while ((tempString = sr.Readline()) != null) { < parsing code here...> }   .. Is there anything absolutely wrong with that type of while or if statement Is it considered bad practice   Will that sort of thing even work right ;p   Alright.. Thanks :)   I hadn't ever seen that before and wondered if it was something that was just generally frowned upon.. but its exactly how I need things so i ...Show All

• Visual C++ error LNK2019: unresolved external symbol LOG referenced in function MALLOC

  I am developing using embedded Visual C++ 4.0 and receive errors: mwlib.lib(sip-lib.obj) : error LNK2019: unresolved external symbol LOG referenced in function MALLOC ARMV4Dbg/ubicon2.exe : fatal error LNK1120: 1 unresolved externals What do they mean Please help me Thanks a lot . toantu wrote: I am developing using embedded Visual C++ 4.0 and receive errors: mwlib.lib(sip-lib.obj) : error LNK2019: unresolved external symbol LOG referenced in function MALLOC ARMV4Dbg/ubicon2.exe : fatal error LNK1120: 1 unresolved externals What do they mean Please help me Thanks a lot . Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. These oper ...Show All