Karen Grube's Q&A profile

• SQL Server Data Transfer from Active Directory to SQL Server

  Hello, How can I transfer data (for example the list of all the users, groups) in the active directory into a SQL Server   Where can I find information on how to do this Thank you. This might be something you can accomplish with "SQL Server Integration Services" in SQL Server 2005.  This looks like a good site on the product http://www.sqlis.com/  and here's the link to the MSDN forum http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=80&SiteID=1 . Hope this helps, Vaughn ...Show All

• SQL Server Store the output of sp_executesql - solved with managed code

  hi I am trying to store the output of sp-executesql into a variable to implement it as a user defined function later The function is ALTER function [dbo] . [UnitsAvailable] ( @id int ) returns int as begin declare @sql nvarchar ( 100 ) declare @params nvarchar ( 500 ) declare @count nvarchar ( 10 ) set @sql = N 'Select count(*) from units where projectid=' + convert ( varchar , @id ) + 'and sold=0 and displayunit=1' set @params = N '@countOUT nvarchar(10) OUTPUT' ; exec sp_executesql @sql , @params , @countOUT = @count OUTPUT ; return @count end The r ...Show All

• SQL Server How to get a handle of my queries

  Does anyone knows of a tool that will help me manage my queries I have 100's of them and all scattered. On my PC at home, some in my laptop, some of them at work, some in memory sticks. Then, when I need them I can't find the one I'm looking for so I end up writing the query again. Any ideas YOu could use SourceSafe or a simple folder structure. If you want to keep them scattered, you can use MS Desktop Search to index all of your possible storage locations. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Smart Device Development Text Formatting in a ListBox

  Hi, I'm trying to add some formatting to items being added to a list box. Using the code below, 'System.Windows.Forms.ListViewItem' is added to the listbox instead of the text. Dim lvi As New ListViewItem lvi.Text = "Out of Stock" lvi.BackColor = Color.Red lstProducts.Items.Add(lvi) ...Show All

• .NET Development C# 2.0 Convert Bitmap to Icon

  Hi There I am using .NET 2005 Beta 2, and am trying to write a utility program that converts icons to bitmaps.  The following function creates an icon file OK, but the icon file is not properly formed.  When I try to open it using Visual Studio I just get a heap of jumbled characters. public void BitmapToIcon(string sourceFileName, string destFileName) {   // Create a Bitmap object from an image file.   Bitmap bmp = new Bitmap(sourceFileName);   // Get an Hicon for myBitmap.   IntPtr Hicon = bmp.GetHicon();   // Create a new icon from the handle.   Icon newIcon = Icon.FromHandle(Hicon); &nb ...Show All

• Smart Device Development Unable to play WMV on WMP10 on PocketPC

  I'm not sure if this is right place to ask this question, apologies if I'm out of line. I'm trying to play a video file (encoded as Windows Media Player 9 Screen) on a Pocket PC running Windows Media Player 10 Mobile on Windows Mobile 2003 SE (it's a Dell Axim X50v). I get the sound but no picture, so I'm guessing I'm missing the WMP9 Screen codec. Does anyone know how I can fix this Thanks in advance. I did not have any problems with wmv on my windows mobile 5 phone. But I did use a converter though. Try blaze media pro, you should have no problems with the wmv converted from it (customizable frame rates so ...Show All

• Visual Studio Team System Team System Discussion Topics

  I was thinking about it...I wouldn't mind soliciting a list of good Team System topics that we should cover.  Here's some thoughts: 1.  Customizing Team System Project Templates 2.  Managing Projects with Team System 3.  Using Team System to increase ROI of Software Development 4.  Business Values of Team System 5.  Team System Adoption Strategies Thoughts   Joel Semeniuk wrote: 2.  Managing Projects with Team System How about "Introducing Team System in a non-agile project" ...Show All

• Visual Studio 2008 (Pre-release) XLinq and OrderBy

  I am struggling with the order by clause in VB's implentation of XLinq. The use of the "It" keyword seems somewhat arbetrary and may be the source of the problem. Consider the following LINQ query that works correctly (yes, this is using Northwind) Dim filtered = Select e.FirstName, e.LastName, e.Orders, e.Orders.Count _ From e In Emps _ Order By it.Count Descending I try to do a transform to XML (using the VB literals). The transform works if I exclude the Order By clause, but can not determine the proper syntax for the order by clause. Dim XOut = <Performance> <%= Select <Cust>&l ...Show All

• Smart Device Development urgent: modeless dialog doesn't get focus

  Hello everyone, I am developping a win32 application for smartphone that needs to open a modeless dialog to display information. The dialog is showing up, but the problem is that it seems not to have the focus. Indeed I can't use its menubar, nor can I edit or go to my textfileds on the dialog. Please help! Thank you for your reply but I think we posted at the same time so that you couldn't see my second post. I've read that SetFocus( ) was not the appropriate code and that we had to do a PostMessage. Unfortunatly, this doesn't help.... ...Show All

• SQL Server Changing Instance name

  Does anyone know how to change the instance name on an installed server short of reinstall Scenario We are about to deploy 20 2K5 servers. We can not deploy them remotely. We will send install disks into the field and use local network support tech to do the work. Currently, the servers are running 2K. We will be running a side-by-side upgrade to insure minimal down time. Since this is a side-by-side upgrade, a second instance name is required. If our techs typo the required name our client apps will not be able to connect. We can run a script remotely if we need to but can it be done ...Show All

• .NET Development Remoting remote ip

  hi,, is there any way on the remoting server to get the ip of the client and i also want to know when does the user connects,.,, any idea mig16 This question is better suited for the Remoting forum. Please reserve the C# forum for questions specifically related to the language. I'm moving your question to the Remoting forum. Thanks. Michael Taylor - 6/19/06 ...Show All

• Visual C# A real easy one

  Can someone tell me how to translate this BASIC statement into c# (There are no help topics in the c# express package about trig functions) y = sin(x) Also: Is there a translation tool that can help old BASIC programmers like me translate things from VB to VC# (My C is pretty wobbly) Thanks and apologies for the noobieness. double y ; double x = Math.PI ; // Set x to 180 degrees in radians y = Math.Sin (x) ; Hope this helps :) ~Sean ...Show All

• Visual Studio Express Editions Can't find a "SysInfo Control" equivalent

  Hi, I really like the Visual Basic Express. I am having a problem getting information about the system battery. Something like this: http://msdn.microsoft.com/library/default.asp url=/library/en-us/vbcon98/html/vbconsysinfoscenario3monitoringbatterypowerstatus.asp would do. However I can't find a "SysInfo Control" to use in Visual Basic Express. The only reference in the msdn  I can find is here: http://msdn.microsoft.com/library/default.asp url=/library/en-us/vbcon98/html/vbconcontrolclass.asp How would I load this Also the " PowerBroadcastStatus Enumeration " seems to be related to the battery information but there seems to be no w ...Show All

• Software Development for Windows Vista Font manager and viewer solution in Vista?

  I still havnt seen the font manager + viewer in Vista what will it be like in Vista any screenshots will there be an application for fonts like Font Book in Mac OS X for example.. Please remember that this is a software development forum. Questions about the Windows Vista feature set are out of place here. ...Show All

• Microsoft ISV Community Center Forums Access 2002 Error 2455 - invalid reference to the property Form/Report

  How can I refer to ControlSource property of textbox control of a subreport The reference below ended with the error 2455 - invalid reference to the property Form/Report. It was written in Report_Open event of the main report. or, cannt we refer to the control in a subreport Reports![report_name]![subreport_name].Report![textbox control_name].ControlSource Original object was to set ControlSource of a textbox in a subreport at runtime . When I tried to set ControlSource in Report_Open event procesure of sub report, I received "2191" error - you cannot set the control source property in print preview or after printing has started. ...Show All