S_A_S's Q&A profile
SQL Server HOW TO - maintenance wizard, direct delete backup after N days?
Howdy - Must be missing something or going blind but, I cannot find in the maintenance wizard where I can say, for instance 'delete .bak after 4 weeks' when creating a maintenance plan for a database. Am I blind or was this important functionality left out of the wizard Anyone know Tia randyvol Under SSMS -> Management -> Maintainence Plan you actually have to drag-and-drop the "Maintainence Cleanup Task" from the toolbox there you'll find the settings (folder path, how many days, etc...) In our Maint. Plan we have 1. Back Up Database task -> Cleanup Task -> Shrink Task Good luck ...Show All
SQL Server RS 2005 and Custom Code
Hi there I've added quite a bit of custom code to my RS 2003 reports. However, I am having no joy with duplicating the process in 2005. My functions are created (as public functions) and as long as I don't try to reference them in the report everything runs smoothly. However, when I do try to reference a function in an expression using the syntax code.MyFunction (), it does not recognise the function. Many Thanks Hi Teo Thanks for the response. Yes. After much frustration and eventually simply running the "faulty" code I have discovered that RS will simply not pick up Code.<Insert Function Name Here> , and it will show it as being incorrect. Simly ignore and life is a scream ...Show All
Visual Studio 2008 (Pre-release) powerpoint slide viewer control.....
Hi Everyone, In winfx application, i want fuctionality in which if any one click on list of the available ppt file then he/she can view slides........Is there any ppt viewer control available in winfx 3.0 Hi, OK, but if for example you cant make "save as.." an you must to use the ppt file. Is posible to load it in to a C++ app as images without save as image. Thanks ...Show All
Visual C# XML
Hi, How can I decode data in an XML string Like when I get something like > or < in the raw strings, I would like to read or store them as > or < in my application. Regards Kiran Kumar Pinjala. When you have a node with test and childnodes you need to iterate through the nodes childs and find its Text node. Here is a sample code that will do just that. XmlNode node = doc.SelectSingleNode( "/root" ); foreach ( XmlNode nodetest in node.ChildNodes) { if ( XmlNodeType .Text == nodetest.NodeType) { System.Diagnostics. Debug .WriteLine(nodetest.Value); break ; } } ...Show All
Visual Studio 2008 (Pre-release) How to use multiple filters on Items? (Bug or limitation?)
If I want to filter out Items from a TreeViewItem.Items I can just add filters to the Filter property. But there is one problem: The order they are added influence on the result. Consider this example: Items before filters: a b c Adding these filters (pseudo code): Items.Filter += [col1=”a”] Items.Filter += [false] The result is 0 items. But adding these filters (pseudo code): Items.Filter += [false] Items.Filter += [col1=”a”] The result is now “a” Best regards, Thomas Andersen Hi Lee, Actually I just read the blog :-) So I guess it's a limitation. The problem is that I'm filtering on Items on TreeViewItem witch is an ItemCollection, so I have to use Predicate<objec ...Show All
Community Chat Free Online Visual Basic 2005 book
I have recently made my book free, sponsored by AdSense of course. The book is designed for non-programmers. After many hours of tweaking javascript I have finally completed most of the design of the page, so that it works with google and also so that there are no frames. If anyone would like to help with the book, ie: make it better, then feel free to contact me here or at the site. You can find the book link in my signature... I am thinking of using DP Syntax Highlighter ( http://www.dreamprojections.com/syntaxhighlighter/Usage.aspx ) for highlighting the code, and also adding C# to it. Perhaps even C++ I would need some help with this though, as I'm not really that great in those two languages. If anyone wants ...Show All
Internet Explorer Development Problem with cancel IE navigation by using Stop() method
Hello, I try to cancel IE navigation by using BHO written in ATL (I use as example a PopupBlocker by codeproject) and to make IE to navigate to "my" url. But Stop()-Method returns the program to Invoke(...) and causes BEFORENAVIGATE2 event again instead of to stop navigation. The IE will be navigated to navigation cancel site and then to http:///. That is a code example that I use: STDMETHODIMP CPub:: Invoke(DISPID dispidMember, REFIID riid, LCID lcid, WORD wFlags,DISPPARAMS* pDispParams, VARIANT* pvarResult,EXCEPINFO* pExcepInfo, UINT* puArgErr) { if (!pDispParams) return E_INVALIDARG; switch (dispidMember) { case DISPID_BEFORENAVIGATE2: *V_BOOLREF(&pDispParams->rgvarg[0])=VARIANT_TRUE; m_spBrowser-&g ...Show All
.NET Development Editing and Deleting nodes in VB
Howdy, I'm working with a program using an XML file, and I'm trying to delete and edit nodes and attributes (well, delete nodes and edit attributes). I've looked around a fair bit, including through these forums, and simply can't find any good easy-to-use tutorial or documentation on this sort of thing. Does anyone know how I can edit or delete nodes using VB.NET, or any tutorials Any languages is pretty much fine (I can sort of try to translate it, but I would really prefer something about VB.net, if anyone has something of the sort). I've looked all over, and can't really find anything that I'm looking for. Thanks so much! Anything really is greatly appreciated. Thanks again! -Robert Sergey you are so right.... typically I would ...Show All
Internet Explorer Development Strange memory read error with BHO
I have a BHO which launches my Explorer Bar. It has been working fine for some time now. But now I am seeing some strange behavior which I am unable to debug or explain. With my BHO enabled and my Explorer Bar in expanded state, when I close the browser it throws some memory read error. If I go to manage addons and disable AcroIEHlprObj BHO and Yahoo IE Services BHO on different combinations, the error doesn't show up. Even with those two BHOs enabled, if I browse to some web site in the main browser or click anywhere in the browser (like minimize and maximize) and then close the browser, then also no error is thrown! If my Explorer Bar is in minimized state then also closing the browser doesn't throw the error. When I debug ...Show All
.NET Development How can I handle the SerializationException for MSDN Remoting Example: Lifetimes?
I'm trying to run the MSDN Remoting Example " Lifetimes ". I created a solution with 3 projects, one each for the client, server, and remotable object, and copied in the code and config settings given in the example. I built them and started the server, then attempted to start the client. This is what I got: Unhandled Exception: System.Runtime.Serialization.SerializationException: Because of security restrictions, the type System.Runtime.Remoting.ObjRef cannot be accessed. ---> System.Security.SecurityException: Request failed. at System.Runtime.Serialization.FormatterServices.nativeGetSafeUninitializedObject(RuntimeType type) at System.Runtime.Serialization.FormatterServices.GetSafeUninitializedObject(Type type) The acti ...Show All
Visual Studio Express Editions waiting without holding the thread...
hello how can I wait in VB without using the System.Threading.Thread.Sleep method because all this does is excecute and does not give the lines before and after it time to execute....like i want to turn a button the color red, and then just wait a few seconds. This is not working currently because the sleeping is happening too fast, what can I do plesae advide...shyma You should not use Sleep because it will prevent the UI thread from exiting your method and repainting the button OR allowing the UI to do miscellaneous things (making the program appear as if it is "Not Responding"). A better solution would be a Timer. You can override the Timer class to cause something to happen at certain intervals. Then, after the Time ...Show All
SharePoint Products and Technologies SharePoint Services 3.0 stops working after Windows 2003 Server 'dcpromo'
Dear sirs, My SharePoint Services 3.0 was working fine on Windows 2003 Server R2 Standard. It is a standalone machine not connected to the network. But SharePoint stops working after I installed Active Directory on this same machine. I did that executing dcpromo tool. Please, can you help me Thank you very much, Marcos Tito. Marcos, You will require creating domain accounts and modifying the accounts that SharePoint runs as. Typically best practice is not to run a web application of any sort on the domain controller as you are opening a security hole. Now, in your case, I would backup my content databases, create two domain accounts (one for core service account and one for search). ...Show All
Windows Forms How to show the caps lock is on balloon warning like Windows
Does anyone know how I can show that balloon that windows shows when you are trying to logon and your caps lock key is on There are some VB examples out there of how to show balloons, but I need to show one using C# not VB as a warning to users when their caps lock key is on and they are trying to logon to an internal system. Anyone have any links to how to do this in C# or some C# code that will do this I would appreciate it. Thanks, Nathan Hi tattoo, Yeah I actually experimented with that site as well as this one: http://www.carlosag.net/Tools/CodeTranslator/Default.aspx The one I just posted is the one that I used to go through the VB.Net code line by line to convert it. If ...Show All
Software Development for Windows Vista The 64-bit Intel version of App Verifier 3.3 fails to install on our 64-bit Intel machine
The 64-bit Intel version of App Verifier 3.3 fails to install on our 64-bit Intel machine. When we use the AMD version of the installer, it does not generate logs when we run our MSI installer package. The installed application runs correctly in Test Case 4 on the 64-bit machine. To make sure I understand: AppVerifier intel 64-bit "ApplicationVerifier.ia64.msi" doesn't install on your Intel 64-bit machine. What's the error message do you get durring AppVerifier install Do you have related error messages in the event log Can you give us more regarding your machine specs so we can look into the failure ie: Make, Model, proc ...Show All
SQL Server HELP! - The report server is not responding
Hi, RS 2005 (sql 2005 SP1) on Windows 2003 SP1 The report server was running ok until this morning. Its just giving a "The report server is not responding. Verify that the report server is running and can be accessed from this computer." message when trying to open the report manager. Any ideas In the SQLDUMPER_ERRORLog.log file there is this.. 05/22/06 12:53:35, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514) 05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied 05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 328 05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0 05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ...Show All