KitGreen's Q&A profile
SQL Server Problem running SSIS Package using Credentials/Proxy
Hello, I have a problem running a Package stored in the msdb datatabase (The Database Engine is configured as a 1 node cluster) using a SQL Job that uses Creadential/Proxy Every time I try to run the SQL Job, it fails with the following error message: Unable to start execution of step 1 (reason: Error authenticating proxy Mydomain\Myaccount, system error: Logon failure: unknown user name or bad password.). The step failed.". The package runs perfectly if I run it logged as Mydomain\Myaccount ussing DTExec.exe from the command line. if I run the sql job as "SQL Agent Service Account" instead of using a proxy, it works great, but if I use the same account as a credential, the sql job fails. In ...Show All
SQL Server Time intelligence
I was trying to using the BI wizard and add time intelligence, but when I try to do so, I get an error stating: "One or more dimensions do not have a data source view. The time intelligence wizard can only be run if a data source view is present." Does anyone know how to get around this error Thanks! ...Show All
Smart Device Development New Sprint PPC-6700 but out of date build using VS2005 5.0 SDK
Just beginning to build an application specifically for this phone and bought a new Sprint PPC-6700 phone today. The software on it is February 2006 vintage and when I tried to run the program I built on VS2005 with 5.0 SDK I get an error message that This application ( AppName.exe) requires a newer version of Microsoft .NET Compact Framework that the version installed on thsi device." I tried the software store on the phone and handago update failed. Is there a update available or SP, or do I need to reinstall the OS with latest version on a 'factory fresh' phone that was not built yesterday I tried copying the patch to the device and running it, but it would not run. Purhaps because at 16.7 ...Show All
.NET Development Bypass Proxy Server Setting Reverts Back
Has anyone else here had a problem with the Bypass Proxy Server setting reverting back to the previous setting when you change it When I work from home over the VPN and run a web application from within Visual Studio in debug mode, I want to enable the "Bypass Proxy Server for Local Addresses" setting. This can be set by going into Tools > Options > Web Browser, and then clicking on Internet Explorer Options, the Connections tab, and LAN settings. Each time I run VS, I have to go back and re-check the checkbox for this setting. Is this a bug with Visual Studio ...Show All
Visual Studio 2008 (Pre-release) Abort animation
If i've started an animation with BeginAnimation is there any way to stop it I have a program where the user can change the animation but when they do that i get realy bad performance if the previous animation isn't complete. The code looks something like this: void handlekeys(Key key) { DoubleAnimation scroll; if(key == A) scroll = new DoubleAnimation (100.0, duration); else if(key == D) scroll = new DoubleAnimation (200.0, duration); image.BeginAnimation(Canvas.TopProperty, scroll); } If the image isn't already moving the program run smooth but if you press A and then D quickly you realy get performance issues. In the code above you will probably not notice anythi ...Show All
Visual Studio 2008 (Pre-release) Responding to events in FlowDocument
I'm trying to build a document viewer that will allow the user to interact with the content of a flowdocument. Is there a way to respond to mouse events from Paragraph controls or any other flow content elements I'm looking for mouseover to change bg colors and mouseup to identify when a paragraph has been selected. I have not had any luck doing this. If this can't be done is there a way to simulate the document viewer with a flowpanel and custom content controls Thanks! No.. the window1.xaml file seems to be fine.. Here is the code listing.. Code Block <Window x:Class="WPFTest.Window1" xmlns=" http://schemas.microsoft.com/winfx/2006/xaml/presentatio ...Show All
Software Development for Windows Vista VB 6.0 - How to elevate my application?
Hi All, I am new in Vista and not a very experienced developer. I am currently developing an application in Visual Basic 6.0, and I want the application to start Elevated in Vista. I want to be able to pop up the window to ask the user for permision to run the application. As I'm new to this can someone help me with a detailed way of doing so, an example code will be very nice. Thank you, Alex Do an MSDN search for Vista and Manifest. That will contain information on how to immediately elevate your application to run with Admin privileges. It also contains sample XML for the manifest file. The manifest can be a separate file or it can be included as a resource within the executable itself. ...Show All
Visual Studio Team System Is there a way to edit/modified changeset?
Hi all, Is it possible that we could update changeset using commandline/UI I remember somebody already post this but I couldn't find. Best Regards, Thanks for your responded. You meant there is no way that I could update changeset. For an example: I've changeset 1 which contain file1.cs, file2.cs Now I want to update changeset 1 to add 1 more file, file3.cs Best Regards, ...Show All
Visual Studio Express Editions Directory Security
I need to make a program that will get a list of names from a text file, make a directory in a certian folder and set the permissions for network acces. Is this possible I will need help on setting the security settings. OK, I got it to make the permissions, now I need it to share the folders individually. The sharename will be the name of the folder followed by a $ so it is a hidden share. ...Show All
SQL Server Indexing Question
I am somewhat new to SQL and have an indexing question I have a table that consists of 60 columns of mostly numeric data. Included in the table are fields called Customerid, CustDate and CustTime. Every hour data is posted to the table with the current time and date as well as customerID. The table is about 6 million rows. I have a query that reads: SELECT CustomerID, custdate + custtime as date FROM Mytable WHERE CustID = 905 and (date between ‘1/1/7’ and ‘1/17/7). The query works but it takes longer than I would like so I am wondering if it’s an indexing issue. Currently my table is indexed as CustomerID + CustDate + CustTime. None of the fields are unique, but the combination of the 3 i ...Show All
Visual C# Windows Service
Can someone tell me on how to get started creating a Windows Service in Visual C# in vs.net File->New->Project and choose Visual C# (or vb.net if you prefer) -> Windows -> Windows Service. This will get you a basic starting point for a system service that you can add your code from there. -Allen Anderson http://www.glacialcomponents.com ...Show All
Visual C# Best practice for an interruptable Worker Thread in C# 2.0
I'm writing a DLL (no GUI involved) that exposes a couple of functions that control the execution of a long process. There will only ever be one client of the DLL at a time, and only one worker thread. For brevity's sake the two functions are: Start() - Starts the long process. Stop() - Stops the long process. Long process preforms resource cleanup. The long process does not have a completion point - it is expected to run until stopped. After the worker thread is spawned by the Start method, I want it to report back to the main thread that everything is up and running OK, or report any error that may have occurred. The Start method will return this status to the user. I'm sure I have a few options as to h ...Show All
Visual C# Object Oriented Programming
Hi all. Im a C++ Programmer that just moved to C# and am having problems learning about classes and objects, i just cant seem to understand it. Im not sure whether i have the wrong book, so any advice and help on the best place i can learn OOP for C# from would be much appreciated. Thanks. cgraus wrote: Ah, OK, so you didn't do much C++ The real differerce is that C++ ALLOWS OOP, C# ENFORCES it. You can't have global methods in C#, you don't even have a global namespace. Everything is inside classes, wrapped in namespaces. http://www.google.com.au/search hl=en&q=OOP+C%23&meta = Any of these will do for starters. C# does not enforce good object oriented ...Show All
SQL Server How can I programmatically tell if agents are running?
Ideally I am looking for a procedure that I can call in T-SQL to verify that the Log Reader, Snapshot, and Sql Agents are all up and running on a given server. I found the undocumented sp_MSrepl_distributionagentstatussummary proc and got it to work for the distribution agent. I also found sp_MSrepl_agentstatusummary, but I've yet to get this to work. Overall, I'd really like to have a better way to do this. This absolutely must be something callable from the sqlcmd interface. It can not be through a UI nor anthing more complicated than standard T-SQL. Any suggestions Yup, this is a great example of what I was saying about the table not being a reliable indicator of the actual status of the agent. When I ...Show All
Visual C++ Can you tell me how to convert long to BYTE?
when i upgrading vc6.0 project to vc2005 project it has the following warning: Warning 233 warning C4244: '=' : conversion from 'long' to 'BYTE', possible loss of data e:\ooltip.cpp 1884 the code is as follows: BYTE *iDst ,*posDst; iDst =255*(i%2); //hard Can you tell me how to convert long to BYTE I appreciate your help. The compiler isn't smart enough to know this expression can't overflow. Just help it along: iDst[ i ] = (BYTE)(255 * (i % 2)); or less efficient but more readable: iDst[ i ] = (i % 2) 255 : 0; ...Show All
