Amde's Q&A profile

• SQL Server why job can't start automatically

  hello,everyone,i meet a problem that the job can't start automatically while i set the schedule,the job can start manual,so i don't know why somebody can help me,thank you Hello, A few questions: 1. What version of MSSQL are you running 2. What is the error you receive in the job run history 3. If you receive no errors in task history, are you sure you've created and enabled a valid job schedule Cheers, Rob ...Show All

• SQL Server Update slow(5 Hrs, 14mil rows) on perm tables, however as part of SP using temp tables fast(45 mins 14mil rows)

  Greetings All ITEM1: Here is the statement :(Perm Tables) update jkk_AllLogic_Allocation1_Work set ExpAllocValue = a.ExpFinValue * (a.SalesFinValue / s.TotSalesValue) from jkk_AllLogic_Allocation1_Work a, jkk_SumOfSales2 s where a.ID = s.ID ITEM2 Here is the similar Statement(excerpt) from SP: /* Adjust Expense amount depending on sales ratio */ update #AllLogic_Allocation1 set ExpAllocValue = a.ExpFinValue * (a.SalesFinValue / s.TotSalesValue) from #AllLogic_Allocation1 a, #SumOfSales2 s where a.ID = s.ID The SP does a lot of things Update being the longest. QUESTION Why is ITEM1 taking 6 times longer to run than ITEM2. I am totally confus ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Any 3D tutorials for XNA?

  Hi, does anyone know where can I find any tutorials, help etc. for developing 3D games with XNA I've played with 2D sprites, its all nice, now I want to move on :) I would like to be able to create simple things like terrain, skybox , move around map etc. Is this possible or I have to wait for beta2 / final release Thanks, ErnisJ You're probably trying to make you DirectX code work One of the main differences between MDX and XNA is that you need to load an effect that contains a vertex and pixel shader before you can draw anything. This effect file must be written in HLSL, but you can also use the BasicEffect class, which provides basic functionality. I've written a series of XNA tutorials that do ex ...Show All

• .NET Development Reurn name of directory

  I have an OpenFileDialog control. When the dialog is diplayed i want to navigate into the directories and to get the name of a selected directory ,not file. The problem is that the dialog does not close until selected a file. I want just to select a directory and get the name (path) of this directory Thank You OpenFileDialog is designed to open files, not directories. Use FolderBrowserDialog instead. Michael Taylor - 11/13/06 ...Show All

• SharePoint Products and Technologies Extending Web Aplications and problems with document library folders

  Hi, I have extended a web app to give remote access to external users via https. The internal path to the sharepoint site is http://sharepoint:5800/default.aspx and the external path over the web is https://sharepoint.icemostech.net:6000/default.aspx . Everything seems to work fine until I try to access a document library folder. At this point the path reverts back to the internal address. Documents in the root of the library are not affected - only sub folders within the library. Has anyone encountered this before Any help appreciated! Thanks Ronan I have sinced resolved the issue It turns out that I had not used the external web address in the Load Balanced URL field wh ...Show All

• Visual Studio Express Editions Encrypt to Md5 or Sha1

  Hello, i need to encrypt a string to md5 or sha1, i did this in vb long time ago. but gave me other values then php did. now i want to do this with C# and get the same hash codes. Hello in php is: Sha1 Encryption: f7ff9e8b7bb2e09b70935a5d785e0cc5d9d0abf0 Md5 Encryption: 8b1a9953c4611296a827abf8c47804d7 Can someone please help me with this Thanks so much Chris take a look at this: http://msdn2.microsoft.com/en-us/library/system.security.cryptography.md5.aspx http://msdn2.microsoft.com/en-us/library/system.security.cryptography.sha1.aspx ...Show All

• SQL Server Active Directory/ADSI connection problems...Here's the correct syntax

  I am having weird problems using ADSI and SQL Server. Our local intranet is ASP with a SQL database on Windows 2003 Server. It uses Active Directory (via ADSI linked server) to get authenicate users, etc. Every now and then (about once a month) the SQL connection to AD will "crash". The following error is what I see when it has crashed: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'ADSDSOObject' ICommandText::Execute returned 0x80040e37]. Sometimes it will come back on its own later, others are solved by a server reboot. Here is how my SQL query looks: SELECT adspath FROM OPENQUERY(ADSI, ...Show All

• Visual C++ C++ and Xml Data Type

  Hello guys! I'm need to manipulate xml data in sql server 2005 with c++. Walking through the documentation I don't finded references to work with oledb and xml data types... Can you help me with a way Thanks []'s Shinji hello, here is a link talking about accessing XML data using OLE DB Templates, hope this can help you: http://msdn2.microsoft.com/en-gb/library/yxzsww18(VS.80).aspx here is another link have fully introduction to Microsoft OLE DB, just for your reference :) http://msdn2.microsoft.com/en-us/library/ms722784.aspx thanks Bite ...Show All

• .NET Development web service string as a web browser object

  Hi guys, using asp.net and visual studio 2003 i've invoked a simple web service that returns the current weather as a string in xml form. I've placed the string in a text box, but what I would like to do is have the xml string displayed as a web browser object without saving the xml string as an xml file and then refering to it. this is my current code: private void btnGetWeather_Click( object sender, System.EventArgs e) { net.webservicex.www1.GlobalWeather aw = new net.webservicex.www1.GlobalWeather(); string s = aw.GetWeather(txtCity.Text, txtCountryName.Text); txtResults.Text = s; } instead of placing the string (s) in a text box, how can I make string "s" be displayed as a web b ...Show All

• Visual Studio Tools for Office Open WINWORD.EXE process

  Hi, I am performing Word 2003 automation using C#, VSTO 2005. I perform various operations like mailmerge, embedding document, inserting text from file, inserting tables.... on a base template file. Once the document is generated, i save it to some location, close it and re-open it. And before closing the same, i release all references wrdSelection = null; oWord = null; oWordDoc = null; objMailMerge = null; The problem is that when i re-open the document and in the task manager, two processes are open for WINWORD.EXE. I am puzzled as to from where the second WINWORD.EXE process gets loaded. Hi Amrish As you've been advised before, the correct place to post automation questions is the office.develope ...Show All

• SQL Server HELP !! HELP: Trigger to send REPORT !!!

  Hi all, Report Manager is failing to email out the reports !!! And... I can not use Report Manager to configure the trigger ! How can I trigger manually to have SQL 2005 email out the reports again OR how can I trigger to run those emailing jobs again Thanks, Frank I don't really understand the question. How are the subscriptions configured (Timed or Snapshot ) If they are configured to fire on a snapshot then you just need to update the report execution snapshot. If they are on a schedule, you could fire the SQL Agent job manually or call FireEvent passing in TimedSubscription and the subscriptionId. Does that answer your question ...Show All

• Visual Studio Team System Changing the drop location (overriding ?)

  Does anyone know how I can override the drop location to be a custom one I noticed that there is a UpdateBuildNumberDropLocation step in the build process which spits out the new drop location after updating the build number. Is there any way I can sneak in and change this to my own custom location You would have to override the CoreDropBuild target by copying the one from Microsoft.TeamFoundation.Build.targets into your TFSBuild.proj file and modifying the DestinationFiles parameter on the Copy task. Be aware that the CoreXXX targets are subject to change between versions of Team Build, so you may have to go back and modify any builds that use this method at some future date. The CoreDropBuild target ...Show All

• Visual Studio 2008 (Pre-release) sample service doesn't work on Windows XP 64

  Hello, I tried to make a windows service that hosts a WCF service. Naturally, I've tried the sample first. It crushes raising an error: System.ServiceModel:Incorrect function at System.ServiceModel.Channels.SharedHttpTransportManager.OnOpen() at System.ServiceModel.Channels.TransportManager.Open(TransportChannelListener channelListener) at System.ServiceModel.Channels.TransportManagerContainer.Open(SelectTransportManagersCallback selectTransportManagerCallback) at System.ServiceModel.Channels.HttpChannelListener.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Channels.DatagramChannelDemuxer`2.OnOuterListenerOpen(ChannelDemuxerFilter filter, IChannelLi ...Show All

• Visual C# Create a pdf

  Hi everyone From Visual Studio 2005 is there libaries to create your own pdf documents If there is please point me in the correct direction. If not please give me suggestions on how i can achieve this. Other libaries available Thanks in advance Thanks for the response. Im making an application that should be able to export what ever document is open. Basically whatever the print out looks like i would like to export it. If you use crystal engine is it possible to write a pdf without creating a layout In other words at run-time i say to crystal i want a pdf with this in it. The link you provided is for a pdf writer but not for free, i was hoping maybe visual would have pdf libaries....can anyone confirm if it doe ...Show All

• Visual C# best obfuscator

  What is the best obfuscator out there each one of them claims to be better than the others. So which one to choose from One thing i noticed is that lost of obfuscator out there are more or less like "project product". They have a limited or sometimes none existent sale and support systems. The only one which looks commercially descent is dotfuscator (prob the reason why it is more pricey). So what is your take on Dotfuscator ...Show All