Jim Perry's Q&A profile

• SQL Server How do you export SQL 2005 Maintenance Plans?

  I am in SQL management studio right now and I have created a maintenance plan. However I see no way of exporting that maintenance plan so I can install it on another SQL 2005 server. I would normally expect to right click on my maintenace plan and have the ability to import or export, that feature is not there. Infact I have found that there are a lot of features missing from management studio, in general it lacks a lot of the right click functionality that use to be in enterprise manager which is a shame, it saved a lot of time. Is there some place to script this maintenance plan I retrieved the xml file using the Select Cast(Cast(packagedata as varbinary(max)) as varchar(max)) method. However there ...Show All

• SQL Server Create Table with variable name

  This should be simple, but... I want to create a table in a stored proc using a variable name instead of something hard coded. I was hoping to do something like.... CREATE PROCEDURE foo -- Add the parameters for the stored procedure here @TableName char = null AS BEGIN SET NOCOUNT ON ; CREATE TABLE @TableName ( [HRMONTH] [int] NULL, [HRYEAR] [int] NULL ) ON [PRIMARY] But no combination of names '@'s , etc, allows me to use a variable name that I passed into the procedure. What am I missing I will either receive a syntax error or the procedure will create a table called TableName rather than whatever TableName really stands for... Thanks, Tom ...Show All

• Visual C++ getting program filepath

  how can i make my program get its own filepath-i have tried GetModuleFileName but all that gives me is "C" when the real directory is something like C:\my documents\visual studio 2005...... is there any other way to do this I think there is other method -- GetCommandLine -- but any method requires correct usage. Perhaps you did not use the GetModuleFileName function correctly (incorrect usage of strings or of sizeof operator etc.) ...Show All

• Visual FoxPro Wait Window "" timeout 0.01 and Sleep(10) in VFP-9

  At times my VFP processing requires *rest(s)* it seems. (report processing/printing, various functions, .BeforeRowColChange events, etc.) I've *discovered*: Wait Window "" timeout 0.01 && ... helps at times while the preferred: Windows API Sleep() routines && ...I've had NO success with API Sleep() declarations Any general or specific feedback concerning *rest(s)* in VFP-9 is appreciated. I tried this.refresh (as per Andy's example below and in other lines therein). And still there is no 'red-light' (in .backcolor). I may try to find another example, later. Thanks for you insight. ...Show All

• Visual Studio Express Editions Connecting to SQL Server not a Database file

  I have recently downloaded VB 2005 Express and have been developing an application in it. I have gotten to a point where I want to create a connection to SQL Server 2000. I am able to do this by writing out the code: Dim conn As New SqlConnection conn.ConnectionString = "server=SQL_Server;database=Web;Trusted_Connection=True" Dim adapter As SqlDataAdapter adapter = New SqlDataAdapter( "SELECT * FROM tblBedStatus" , conn) Dim dsBedStatus As New DataSet adapter.Fill(dsBedStatus) I am not able to create a connection to the SQL Server by using the "Add New Data Sources". The only Data Sources that I have listed are "Microsoft Access Data File" and "Microso ...Show All

• Windows Forms Tooltip of ErrorProvider class gets lost

  Hello whenever ErrorProvider detects an error it shows the tooltip when you hover your mouse over the icon. It stays there for some period and then it goes away. now if you hover your mouse over the icon again then tooltip is not displayed. i think it is getting lost any work arounds for this Thanks and Regards Jayesh (Moderator: Thread moved to this forum for better responses) Hi This is cool but it doesnt solves my problem i.e., if i get the error then when i hover on the icon i can see the tooltip.now i am not moving my mouse from the icon now i see the tooltip for sometime and then it goes away. now when i move mouse and again point it to the icon then tooltip doesn't comes up in above solution we ...Show All

• SQL Server Multi Column Subreport

  Hi, I am trying to use a multi column report as a subreport. I want to know how can I do it without loosing multi column. Thanks, -Rohit I have these reports which I am running separately. One of them is a multi column report also. I want to put together all these reports in one report, for that I am using these reports as subreports. The problem I am facing is, when I use multicolumn reports as subreport, I loose the multicolumn part of it. All the data come as one single column. I am using Rectangle to hold the subreports. May be I am not doing it wrong. Can you please help me, how can I bind all my individual reports into one single report and not loose any formatting (i.e.multicolumn ...Show All

• Visual Studio Express Editions How about for VStudio 6?

  When U code in a Visual Studio env, can U get the line numbers in the code area, ie *.cpp or *.c area. How Thanks I think it's possible in VS6 too and it's done in the same Tools/Options dialog. Other than this I don't remember much, there are some years since I haven't seen a VS6 ! And these forums are intended for VS2005 anyway... ...Show All

• Visual Studio Property of a shared file

  How can I tell from the properties links tab which path belongs to the original file Is it always the top one No, I think the list is sorted alphabetically. I don't think there is an easy way to see this information. You'll probably have to look in the History of each parent project sharing the file, and look for lines like "File.txt -- Added" or "File.txt --- Shared $/Original/File.txt" Alin ...Show All

• Visual Studio 2008 (Pre-release) Tabs and Data Binding

  I'm having trouble understanding data binding. I have an Xml document as follows <Xml> <Tab Name="Tab1"> <Group Name="A Group" /> <Group Name="B Group" /> <Group Name="C Group" /> </Tab> </Xml> The following could displays the tabs but how would I add the groups to the tab panel. Everything I try seems to end up in the TabItem. Is there anyway of doing this just in Xaml, and am I going about this in the right way. Thanks in advance. Andy p.s Here is the current Xaml code. <Page xmlns=" http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x=" http://schemas.mic ...Show All

• SQL Server get timezone specific date

  Hello, I am struggling with one algo i.e. I want to retrieve the date according to time zone I have table called TIMEZONe in which i have the information about the hours difference (+12 to -12) from GMT... now my scenario is that I want to get the date, using information from timezone area table (time difference from GMT), of any particluar time zone can any one tell me, how will I able to achieve this task. for example: it 4:00 AM in the mornign in GMT TIME and date is 11-08-2006 but in US it 11:00 PM and date is 10-08-2006 Note: Server date is set to GMT (System date) regards, Anas i HAVE DEVISED THE FOLLWING ALGO IF @OFFSET - DATEPART ( HH , GETDATE ())>= 0 SET @SYSDATE ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Woeful XNA GSE Install

  I've uninstalled my XNA GSE Beta 1 and everything but I get that stupid error message whenever the installer gets around to installing the DX Runtime. I never had this error when I installed GSE Beta 1, so why now You'll have to run that from the command line. To open a command line window hit the Windows Key+R and naviage to the directory where the install is located then type that line in the command line window and hit enter. ...Show All

• Visual Studio 2008 (Pre-release) How to display vertical header Text in an expander

  Hi, what I want to achive is almost the thing like an "autohiding toolbox" in VS200x. I gave the expander a try and it works for me but (newby to XAML) I could not achive to display the header text verticaly when collapsed and horizontally when expanded. Can anyone help me with this pls Manfred ...Show All

• Windows Live Developer Forums onchangeview event does not happen after using Pan()?

  I've created a map and am also using map.AttachEvent("onchangeview", SomeFunction). I've also created my own custom compass and zoom buttons. Clicking on the zoom buttons fires the onchangeview event function, but it doesn't fire when clicking on the points of the compass. For moving the map I'm using Pan(x,y). The map pans correctly, but this doesn't trigger an onchangeview event. I'm looking to get the lat & long coordinates of the map's boundary after the pan has occured. Is there another way I can do this Thanks ...Show All

• .NET Development Detach process from parent

  Hi All, First of all, I don't usualy write apps for MS so please be gentle... My question is simple : how do I detach child process from parent so when the parent gets killed the child stays alive Thanks Chris I've got no problems helping a Linux guy, but I'll probably get toasted by the vast anti-Linux Conspiracy (TM) trying to keep us silent ALL processes in Windows are automatically detached from the parent process. A simple way to test this is to run notepad from the command prompt and then exit the command prompt, notepad will stay open. Parent processes are only really used for bookkeeping in Windows, not for lifetime control. ...Show All