sarvesh m's Q&A profile

• SQL Server CREATE TABLE/VIEW from stored procedure or SELECT...

  Can anyone tell me how can I create a table in (SQL Server 2000) direct from a stored procedure execution or from a SELECT result I need something like this: CREATE TABLE < t > FROM <sp_name p1, p2, ...>or like this: CREATE TABLE < t > FROM SELECT id, name FROM < w > ... Thank you! Sorry joeydj but your example create a copy of another table! I need to create a table that contai ...Show All

• Visual Basic Disappearing Data Sources

  I just installed the VS2005 RC and now my Data Sources window loses its contents whenever I open a form or user control.  I have 2 data sources defined, and they show up fine if I don't have a form as the active window in the IDE.  As soon as I click on a form or usercontrol window, the data sources disappear and the data sources toolbar becomes grayed out.  It's slightly different than when there are no data sources in the p ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Computer Hangs

  K ne time i play a game or even watch a video with surround sound, my comp. hangs and i have to reboot it manually. comp. spec's pentium 4 - 1.6ghz 384mb of ram 128 mb ati 9550 creative soundblaster audigy 2 zs 40 gb hard drive NEC DVD+/-RW Logitech X-530 windows xp home with all this i should be able to play games,movies/surround sound no problem but everytime i do have a problem which kinda sux cuz i pay so much for this stuff and it hangs, be ...Show All

• SQL Server SQL CLR memory management

  Hello, I have a few questions about the behavior of the CLR host within SQL Server 2005. We are using a UDT (call it MyDateTime) created in C# that represents the COM FILETIME type, in order to have single millisecond resolution. MyDateTime values are stored in the database as binary(8), with the UDT itself being used primarily for display and reporting purposes. I am running performance tests using a prototype (written in C# as ...Show All

• Visual C# sql extract data

  Hi i have a big file in DB like 300 MB i want to save the contents of that Table in a XML file.. problem is i get the exception System.OutOfMemory ... has anyone done that before suggestion how to do it is it possible to request a amount of data from the SQL server like.. the file HAs 300MB .. the server send 10MB then another 10MB.. and so one untill all data is sent Thanks!! If you have a 'record id' field in your data table then yo ...Show All

• Visual Studio Purchasing Source Safe 2005

  According to the info at http://msdn.microsoft.com/howtobuy/vs2005/editions/pro/  I will have to buy the Visual Studio 2005 Professional with MSDN Premium Subscription for $2299/yr in order to obtain VSS. Is this the only way to get the new version of VSS I have a team of 4 people and paying this for all 4 seems very expensive. Would i need a full copy of sourcesafe 2005 on every station with visu ...Show All

• Visual C++ Owner Draw Listbox problem

  Hi All, I have an owner drawn list box. i have disabled its scrollbars and im drawing a custom one. since there is no scrollbar, when im calling GetScrollPos(), it is returning 0 always. how i can solve this issue regards, sarath Usually the system sends SBM_GETPOS windows with standard scrollbar when GetScrollPos is called. So you can overwrite the behaviour by handling this message. ...Show All

• SQL Server How to get a row committed

  I have a package loading up rows of employees from an excel file. An employee may be in the file multiple times. The package does a lookup and if not found it inserts the employee. When the employee is found it does an update. So in my file employee A gets added on the first occurrence in the file. On the second occurrence, the lookup does not find the employee and tries to insert a second time and I get a unique constraint. How do I make the ...Show All

• Visual Studio Team System Running FxCop plugin from the VS 2005 debugger

  Hi It is possible to run an FxCop plugin from the VS 2005 debugger Thanks Just for the record (for anyone else reading), this is certainly possible. You just need to attach the debugger to FxCop.exe or FxCopCmd.exe and set a breakpoint in your rule source. Nick ...Show All

• Visual Studio Class Details window (MSDN bug ID: FDBK24857)

  I'm having a problem with the Class Details window. Click on the following link to see the corresponding bug details: http://lab.msdn.microsoft.com/ProductFeedback/viewFeedback.aspx feedbackid=914d3c3f-efdd-41ed-8c6c-da5ed91f48db When I click on a class in the Class Designer, the Class Details window shows up, docked at the bottom of the screen. But when I click inside the Class Details window, it dissapears! Every time. I tried to&n ...Show All

• Visual FoxPro sys(2015) Conversion back to System Date Time

  I'm working on a project to do some analysis, and difference between versions of ClassLibraries (VCX/VCT), Screens (SCX/SCT), Projects (PJX/PJT), Etc... I'm looking at the Uniqueid field which is a sys(2015) type of value, which is based on a given system date time.  I've seen an article that explains how to reverse the value back to the date time, but I just can't find it anymore. Can anyone help me with a sample of what I need for this co ...Show All

• Visual Studio Team System Test Repository Full - How do I allocate more space?

  I'm using Team System for Testers, running web Load tests. (which is sooo much better than ACT!) Using the local DB for storage (default), and a 1 minute sample rate, the repository filled up after 30 hours or so when running the same load test. After deleting the results, I'm still getting the error message. After deleting all old results in the Test Runs tab, and even after deleting all 'TestResults' folders I can find on this machine, i st ...Show All

• .NET Development Capturing binary download via code through axwebbrowser1

  Dear All, Firstly, apologies for disturbing. Im trying to find a method to capture the download event for binary files via http ( ie notifying the user when attempting to download an executable file that executable files are unsafe to download when they attempt to click on a link pointing to a .exe ). Currently, I dont seem to be able to stop the AXWebBrowser1 control from taking control of file downloads. If at all possible, I want to be able t ...Show All

• Visual Studio Team System Expanding History Entries in History Tab

  Is there a way to expand by default the "changed fields" in the History tab of a work item Our QA team reviews the history and the changed fields frenquently. When they have to go through a long list of entries (or changed fields) they have to manualy expand all the nodes one by one to find the info they are looking for. This was one of the features in PStudio... Thanks. Unfortunately not. You can use the Tab and Enter k ...Show All

• Windows Forms Visual Studio .Net Professional upgrade

  Unless someone in here can prove otherwise why can't you take Visual Basic .Net Standard (which I have) and upgrade to Visual Studio .Net Professional  From what I have found you can buy the upgrade and it will work for pretty much everything&n ...Show All