McMaster's Q&A profile

• SQL Server Urgent: Finding sessions in SQL server 2000

  Hi, Can you help me how to find out sessions in SQL Server 2000. Also is there any way to see the outstanding sessions for a database Thanks in advance, Vasu. You can do this graphically in Enterprise Manager, or you can use this script: SET NOCOUNT ON create table #ProcCheck( Status varchar(50) , SPID int , CPU int , Pys_IO int , WaitTime int , BlockSPID int , HostName varchar(36) , ProgName varchar(100) , NTUser varchar(50) , LoginTime datetime , LastBatch datetime , OpenTrans int , LastCmd varchar(4000)) create table #ProcInfo( EventType varchar(100) , Parameters int , EventInfo varchar(7000) ) INSERT INTO #ProcCheck(Status, SPID, CPU, Pys_IO, WaitTime, BlockSPID, HostName, Prog ...Show All

• .NET Development Changing credentials on the current thread

  I'm writing in vb,net 2005, and my program needs to allow a user to specify a domain, username and password, and then switch credentials for the current thread and any threads it spawns. If the current thread credentials cant be changed thats not really an issue as most of the work is done by threads created with parameterizedthreadstart. So how can I either launch a thread or change the current thread to use a different windows login thanks Thank you for this. I have implemented the code these articles suggest, but I'm finding that the processes are not getting elevated privelages. However this might be because I'm not working in a domain environment. My setup has all pcs with the sam ...Show All

• SQL Server Deploy Reports via Visual Studio 2005

  This seems to be a basic issue, but I am having a problem trying to deploy a report to Reporting Services. I have setup the deployment options under the properties of the Project. But each time I try to deploy a report, I get "The request failed with HTTP status 504: Gateway Time-out" When I try to connect to connect directly to the TargetServerURL via a web browser from my client or the server itself, I can browse the structure fine. Not sure why I can't deploy via Visual Studio. Thoughts Thanks To localize the test, I put the system running the Visual Studio on the same subnet. It's wide open with NO ACL control or routing from that point. ...Show All

• Windows Forms possible changes to Computer settings

  I think that my daughter may have altered the computer settings. I have Guardian software and it did not record for 1 day. I also noticed that I has a bunch of Security Event Logs (special priveleges to new logon, A trusted logon process registered with LSA, etc.) Also, I think there may be new drivers Is there a way to scan for system changes This forum is devoted to developers and specific questions regarding creating windows applications. I suggest you try the Microsoft Support Site in researching your problem. Good Luck. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do I work with windows Forms (using C++) and Directx (9)

  Hi, I need a help!!! I need a example what show me how to work with windows Forms (using C++) and Directx (9), step-by-step, since declarations until how I create a form and draw inside it a line or other picture, I need a example what make this, if someone can help me..... Tks......... Here's my class that creates a D3D device and lets you use Present() into a form. Check SetupDevice() for how to get started. using System; using System.ComponentModel; using System.Collections.Generic; using System.Diagnostics; using System.Text; using Microsoft.DirectX; using Microsoft.DirectX.Direct3D; using System.IO; namespace EditControls { public struct SceneCamera { public int Color; public bool Grid; public bool Orthographic; ...Show All

• SQL Server help needed in replication..

  Hi All, I am new to Sql Server.I have to create snapshot replication between SQL 2000 and 2005.The Publisher should be sql 2000 and the subscriber is sql 2005.I need ur valuable inputs as how to start. Hi, I would start with the replication section of SQL BOL ( http://msdn2.microsoft.com/en-us/library/ms151198.aspx ) for general information on snapshot replication. To use multiple version of SQL in a replication topology, you can refer to this page ( http://msdn2.microsoft.com/en-us/library/ms143241.aspx ) for more information. Thanks, Peng ...Show All

• Visual Studio .root folder

  A copy of my project name except with a .root extension is created in VSS. I am not quite sure why it did that. I started to appear after I was having issues trying to checkout files using VS2003. Any insights Which one should I use - projectA or projectA.root "solutionName.root" is the name SourceSafe provider suggests when you run the Add Solution To SCC wizard. You can type whatever name you want. ...Show All

• Windows Forms New Publish causes full download

  Every time I publish, it seems to cause a full download for the user. Am I misunderstanding how ClickOnce is supposed to allow the client to only download what has been changed in the application. I see it maintains a completely separate copy of the app by revision number. How can I configure ClickOnce to only require the user to download what has changed rather than the whole app again everytime when I publish a new version Thanks, John Elizabeth, Thank you so much for your reply. I appreciate your expertise. When publishing with ClickOnce, that status indicates it rebuilds the project you are publishing. However, files that are simply referenced, and not built in the project, also get r ...Show All

• Visual Studio 2008 (Pre-release) DLinq Inheritance and Association

  I'm having trouble with an association to a subtype It's pretty bad design, but ah well sometimes... Ex : A vehicle has an association to one of it's subtype, the car. Looks like DLinq can't manage this. <Table()> _ <InheritanceMapping(Code:= "V" , IsDefault:= True , Type:= GetType (Vehicle))> _ <InheritanceMapping(Code:= "C" , Type:= GetType (Car))> _ Public Class Vehicle Private _car As EntityRef( Of Car) <Column()> Public CarID As Integer <Column(IsDiscriminator:= True )> Private Type As String <Association(Storage:= "_car" , ThisKey:= "CarID" )> _ Public ReadOnly Property Car() As Car Get Ret ...Show All

• SQL Server How to handle multivalue field?

  Here is my scenerio: I tried to do a comprehensive catalog of my classical music collection, and my most basic unit of data is a track from a CD. As it happens, a track have a variable number of performers (e.g. a symphony may contains a conductor and an orchestra, a string quintet may contains five members, a piano trio contains three members, etc.), so I can't easily provide a field for performers. I have a table for performers and another for tracks (along with other things). Since I have a large number of tracks, it would be very undesirable to create an additional table relating every individual artist with a track (it would blow up the database size and is rather unnecessary). So my ideal solution is a multivalue field for perf ...Show All

• SQL Server How to select 'save results as' file extension

  I create ad-hoc queries, eventually with 'results to text'. Then I 'save results as'. With SQL 2005 Management Studio, the file extension is .rpt. For several reasons, I need to specify the default file extension to be .txt. In my old school (Query Analyzer), we had an option for 'Result File Extension'. I need this. Select "All Files *.*" and type in the whole name as you want to save the reults like Something.txt HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Software Development for Windows Vista Accessing HKLM from a vb6 exe that calls a .net dll

  Greetings! I have a vb6 exe that calls a .NET 2.0 dll. The dll needs to write to odbc settings. If run as an admin this fails with the exception: that I am not allowed to access HKLM - this is expected. What is the best way to gain write permissions for the dll I read about manfiests, and created the following manifest for my dll: < xml version="1.0" encoding="UTF-8" standalone="yes" > <assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0"> <assemblyIdentity version="1.0.0.0" processorArchitecture="X86" name="MyLibrary.Common.Database.Tools.PowerTool.Library" type="win32"/> <description>This applicatio ...Show All

• SQL Server db_dtsadmin role

  Our DBA has given me access to MSDB on the SSIS service on one of our servers as db_dtsadmin. When I try to connect to the server using Integration Services in the connect drop down menu, I get the following generic error msg: connect to SSIS service on server 'xxxx' failed: access is denied. I'm told this role should be sufficient to give me access. Do I need other server access roles to use in conjunction with db_dtsadmin or are we missing something really easy here. Thanks. DBRICHARD wrote: Our DBA has given me access to MSDB on the SSIS service on one of our servers as db_dtsadmin. When I try to connect to the server using Integration Services in the connect drop down menu, I get t ...Show All

• Visual Studio Dynamically changing ReportViewer properties

  Hi, I have created six reports, Report1.rdlc, Report2.rdlc,.....Report6.rdlc, I want to use a single form to run these reports, that is in the Form_Load event of the form I want to write codes to select a reprot to display. Can anybody tell me how to dynamically change the properties of the ReportViewer control placed on the form. Thank you, shahid Take a look at this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=196684&SiteID=1 It has some sample code that will do what you want. ...Show All

• Visual C# Why can't attribute parameters be dynamic?

  I was looking at decorating a method with the PrincipalPermission attribute. It tried to do this: protected static string foo = "bar"; [PrincipalPermission(SecurityAction.Demand, Role = foo )] public void DoSomething() { } But it doesn't compile: "An attribute argument must be a constant expression, typeof expression or array creation expression" What the technical reason for this and do you think it would be good feature to have this, or better to leave it as it is I would be very interested in hearing your opinions on this, thanks! The value of the attributes paramters must be fixed at compile time. In your example, "foo" can change at run-time. If you change the line to protec ...Show All