Roy mm's Q&A profile

• SQL Server Connecting to Linked Servers

  I know this is an easy one for most of you but this is new territory for me. I am trying to link a production application database to an existing SMS database. Both of these databases are SQL 2000. I have sa access to both of them. I have an accreditation application that deals with internal processes within our active directory network. We are using SMS database collections to provide the discovery for reporting of this application database and I want to compare the collection to the existing data between the 2 databases. For simplicity I will define them both. Application Database we will call “A-Database” SMS Database we will call “B-Database” I have gone into the A-Database and gone to linked Se ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Xna few problem?

  Hi all, i has few question with xna game studio express, hope sombody help. Q1. How to draw dynamic test in display Q2. i tried draw model in my game, but i want real time change my model texture. how to do Q3. how to set model alpha channel to 80% best regards, ...Show All

• SQL Server Just installed SQL express, what else am I missing??

    Hi everyone, I believe I have installed SQL server 2005 (SQLServer2005_SSMSEE.msi) and I can run "Mircosoft SQL server Management Studio Express" I can see the "Connect to Database Engine dialog", however I am unable to connect to a server  (I know I need to create a server or instance but don't know how ;-(   ): Server Type: Database Engine Server name: Authenitication: Window Authentication User Name: myID\myID Password: Now, how do I create a server name (instance ) Do I need to download other software to create an instance so I can try the SQL Server locally Please help ,I am lost ;-( Hi, SQLServer2005_SSMSEE.msi only installs SQL Server Management Studio Expres ...Show All

• SQL Server Setting Report Parameters

    Just working on my first report and am having trouble get the report paraments set up. When I try to set a parameter on the Data tab such as @Zipcode it treats it as a string and surround it with quotes. Also it does not automatically create a parameter in the Report Parameters collection on the Layout tab. Even if I manually create the parameter it does not tie back to the query. Any ideas of what I should be doing Thanks, Paul Hammond Richmond, VA If you write a query for a SQL Server data source, such as SELECT FirstName, LastName FROM Employee WHERE EmployeeID = @EmpID report designer will automatically detect the query parameter. Once you move to the Layout mode, it should also automatically create a report para ...Show All

• Windows Forms How to erase the lines I have drawn a moment ago ?

  I have to cover the first line with a new line with the same "backcolor".if the backgroundimage is a picture, how do i do Check this thread for code... ...Show All

• Visual Studio 2008 (Pre-release) Peer Channel Chat Sample - Not working for me

  Hey guys, I've been searching the forums but haven't found any answer. Here's the deal, I have .NET 3.0 on my laptop, and I installed the WCF samples. I can successfully build and run the Peer Channel Chat application, however, when I send a message, it does not send to the other clients. :( So it's not working... what do I have to do to get it to work I did not change any of the code. What are the necessary steps needed to take before I can get this specific sample to run I noticed the links to the "One time setup for WCF samples", but all those steps were for IIS hosted services over http. This app is tcp only, if I have read the code correctly. So what is needed to get just this sample to run I installed it on my wo ...Show All

• Microsoft ISV Community Center Forums Newbie in VBA Drag and Drop..

  Hi, Do not know if this is possible drag and drop effect of items in dropdown control inside a word application The task is to import and export data from and to database, but user can select from a list columns what they want to add, there will be a dialog will appear and allow user to select data to be included in a word document, how can this be done Thanks in advanced. den2005 Hi, Looks like your best to create this in a Word template using VBA. You'll need a user form which will get the data from the web, display it in a list, let the user modify and upload, and also letting the user perform the drag and drop, and uploads. Since the user is primarily working with word thats w ...Show All

• SQL Server Problem creating stored procedures

  I am getting the following error message every time I try to create a stored procedure - any stored procedure: Msg 6354, Level 16, State 10, Procedure AuditOperations, Line 14 Target string size is too small to represent the XML instance A search of books online and MSDN didn't return anything. Thanks. OK, but the code doesn't appear to matter. I get the message for any view or stored proc I try to create. I've scripted some of AW views and stored procedures with the same result. CREATE PROCEDURE ListEmployeesByDepartment @DepartmentName NVARCHAR ( 50 ) AS SELECT c . Lastname , c . FirstName FROM Person . Contact c INNER JOIN HumanResources . Employee e ON c ...Show All

• Visual C# Allowing an object model to talk to two projects

  Ok, this is a completely new area to me. I'm not asking how to do this, just someone to point me in the right direction of what I should research. My question is this, say I have two executables: myApp1.exe and myApp2.exe both of which are running. myApp1 is written in C# 2005, whereas myApp2 is written in VC++ 2005 Next, using myApp1, I created a live object model from a C# DLL I referenced. Finally, I would like for myApp2 to be able to somehow see this live instance and monitor it for changes, as the user will be making many changes during runtime. Is this something that Web Services or Windows Services would be good for I don't have any experience in either area, so please bear with me if I am way off base here. A Windows servi ...Show All

• SQL Server Bar chart report(grouping datetime info yearly, monthly, etc...)

  hello, I am creating a bar chart report which contains a datetime information on the x -axis. The unit of the x-axis value depends on the parameters value(StartDate and EndDate). For example, if the difference between StartDate and EndDate is > 2 years, say 4 years for instance, then the value of the x-axis should be presented on a yearly basis, like this: I am creating a bar chart report which contains a datetime information on the x -axis. The unit of the x-axis value depends on the parameters value(StartDate and EndDate). For example, if the difference between StartDate and EndDate is > 2 years, say 4 years for instance, then the value of the x-axis should be presented on a yearly basis, like this: ...Show All

• Visual Basic Add text to textbox which already contains text

  Does anyone know how to wirte text to a textbox which already contains text. For example: I have a textbox on my form and i set the text to say "color" when the program runs the form displays buttons with names of colors and when i click on the button i want the name to appear in the textbox BUT i DO NOT want it to overwrite the text that is currently in the box. Any thoughts Thanks!! Hi, you could use TextBox's AppendText method: TextBox1.AppendText( "black" ) Andrej ...Show All

• SQL Server Time Series Periodicity

  I'm trying to learn about time series algorithm but I can't set the time periodicity right. I have information stored 2 times a year (semester) so I'll should set up a PERIODICITY_HINT = {2}, right but it does not change anything. Here is a screenshot that might help understand the problem: Jamie, thanks a lot for your explanation. I think I understand now what's the problem, but I have no idea how to fix this because the problem is not the algorithm .. it's probably the data or the time period that I choosed. Any ideas are appreciated. Santiago Acenolaza Argentina ...Show All

• Software Development for Windows Vista Calling CreateProcessAsUser() from service

  According to some MS documents (e.g. http://www.microsoft.com/whdc/system/vista/services.mspx), it should be possible to use CreateProcessAsUser() API in a Vista service to create a process in user session. I am trying to achive this, but the function returns error code 1307 (ERROR_INVALID_OWNER) = "This security ID may not be assigned as the owner of this object." Does it work for somebody Many thanks in advance. The same code works for us on Vista as on XP, etc. The service is running as the Local System. 1. use WTSGetActiveConsoleSessionId to get the ID of the current active Windows session at the console (i.e. the machine keyboard and display, as opposed to WTS sessions). 2. use WTSQu ...Show All

• SQL Server Convert Date

  Hi ! I think I need your help... to convert the date (2006-09-09) to weekday, weeknumber, month number, month, year in OLE DB source editor ... created following sql, which is not working. How about using derived Column transformation editor SELECT DATENAME (WEEKDAY, YYYYMMDD) AS weekday, DATEPART(WEEK,YYYYMMDD) AS weeknumber, MONTH(YYYYMMDD) AS month_number, DATENAME(MM,YYYYMMDD)AS Month, YEAR(YYYYMMDD) AS year, DAY(YYYYMMDD) AS date FROM Purchase thank you so much... Thank you, I have a Derived column due to the (weekday unicode problem) and added following expression in derived column (ISNULL(weekday) "" : (weekday)) Moreover Destination Mapping Input column ignore and weekday in Destination column. Is this Ok Still ...Show All

• Visual Studio Team System Filtering Associated Work Items

  I have a TFS project that includes multiple solutions for more than one team (client, server, etc.). I have set up a build type that builds solution server.sln successfully. However, I want the build log to display the work items associated with this build that only fall under a certain area path. I have my area paths set up hierarchically for each team. How is this possible Thank you, Sammy Your first two assumptions are true. I do not understand exactly what you mean by assumption #3. I have a build type that gets sources from only one branch under my version tree. I'll explain: /$MyProjectRoot - Server - Server.sln + source code - Client - Client.sln + source code So I ...Show All