nhaas's Q&A profile

• SQL Server Transaction log growth during Maintenance Plans

  During my maintenance plans every night, my transaction log for a 17GB database grows to about 9.5GB. I am running transaction log backups every 2 hours, and my transaction log stays around 300MB during the day. However, every night when the optimization job runs, this explosive growth occurs. I have the optimizations set to Reorganize data and index pages, changing free space to 10%, and remove unused space from database files to 10%, shrinking when they grow beyond 50MB. This database handles cash register operations which are not active during the maintenance plan. Hi adgross , I got the same problem as u. I have no idea how to get rid of this. Besides, I can't even change the FULL recovery mode ...Show All

• Software Development for Windows Vista ActivityExecutionStatus Executing to Closed

  I have created a simple Custom Activity and overridden the protected method Execute. The nature of job within Execute is such that the response would arrive into the activity asynchronously, I am returning ActivityExecutionStatus.Executing at the end of the method. I have a delegate callback private void myCallBackMethod(object Sender, EventArgs Args). My callback gets called successfully on recieving the response. What I do not understand now is, how and where do I return ActivityExecutionStatus.Closed so that the workflow having this CustomActivity knows that the activity is completed and it can proceed with the rest of the activities. In my case I will need the workflow execution to wait until the CustomActivity is completed, but since ...Show All

• SQL Server Run DDL Task failed when I try to BeginTransaction in it

  Just try this: 1.Create a AS Connection Manager in a package, put the RetainSameConnection property into True. 2.Drag a Run DDL Task, and use the Connection in step1. 3.write the DDL query as this: <Command>    <BeginTransaction /> </Command> 4.Run the package. Result: It said a mistake like this:    Error: the  element  Command at 7 row, 38 column(Namespace urn:schemas-microsoft-com:xml-analysis)  can not be displayed under Envelope/Body/Execute/Command. Please help me, what's the hell of this Thanks.     Can you provide some more information what have you tried to debug. did you try here http://www.topxml.com/MS-XML-Analysis/rn-21 ...Show All

• SQL Server Security, Dynamic SQL, and CLR Stored Procedures

  Okay, I have sort of a peculiar permissions question I am wondering if someone can help me with. I'm suspect there's a simple answer, but I'm unaware of it. Basically, here's the scenario... I have a CLR stored procedure which does some dynamic SQL building based on values sent in via XML. It's a CLR stored procedure using XML because I want to build a parameterized statement (to guard against SQL Injection) based on a flexible number of parameters which are basically passed in the XML. The dynamic SQL ends up reading from a table I'll call TableX and I actually discovered an (understandable) quirk with security. Basically, the connection context is impersonating a low-privilaged Windows account ("UserX") coming from a . ...Show All

• .NET Development Security when Hosting CLR

  I have an unmanaged application that hosts the CLR. This application may be located in a location that does not have full trust for managed applications (on a network share, or on a locked down machine). The unmanaged application obviously has full access to machine resources. However, any functionality in managed code is limited by the security settings for where the assemblies are located. Is there a way (since I'm hosting the CLR) to give the managed code I am running full trust access, even if they are located on a network share, for example. See Chapter 10 - "Extending the CLR Security System to Protect Your Extensible Application" from "Customizing the MicrosoftR .NET Framework Comm ...Show All

• Visual Studio Express Editions VB Business Users

  Do business users need a licence to use VB. My understanding is it is for home use only - does anyone know where I can find the official position on this as I can't seem to find it on the msdn site. Thanks http://msdn.microsoft.com/vstudio/express/support/faq/default.aspx 4. Can I use Express Editions for commercial use Yes, there are no licensing restrictions for applications built using the Express Editions. ...Show All

• Visual Studio Team System Service Broker Support

  I see basic SSB support has been added. But as you will know, there are always 2 sides involved in SSB communications and large parts of the configuration depends on the other side. What's the recommended way of keeping multiple DB projects synched and what other features will you provide in the future to help aid in this The "Service Listing Manager" supplied by the SQL2005 team is quite buggy and there does not seem to be any more enhancement being done on it. Maybe it should be integrated into this project-type and create/update the elements needed to communicate with the "target" service. I hope you meant thread, not threat ;) Ok. all message-types must be available in both db's. Same goes for Certs ( ...Show All

• SQL Server How to specify config file for package within a package

  I have a situation where I have Package A, which is called from Package B. Both packages have been designed to use config files for their connections, etc. The issues arises when executing Package B. I can specify a config for Package B to use, but how do I tell the embedded package to use its correct config file By default, Package A has its config file pointed to development, but I would rather not have to save a special version of Package A that points to production. I dont see any option within the execute package task. Any ideas We usually setup our jobs with a config file which points to the respective environment. We havent decided to use system variables to point to environments, or use the config option in job s ...Show All

• Visual C++ Giving the user a language option in VC++??

  Hello, Could any one please explain how it is possible to give the user the option to change the language of the status bar,main frame etc during runtime I create a dialog box in an SDI based MFC-application(using Visual Studio dot net 2003) and have a list box in the dialog box,with language options such as "English","French","German" etc.The default language is english,but if the user selects German,then on pressing ok the language should change to german. I heard it can be done by using "String resource".A little detailed explanation would be highly appreciated. Thank you Hi Martin, Thanks for the steps, A small problem: the copies of the resources I create remain in the same language as the ...Show All

• SQL Server Why the plan guide with OPTIMIZE FOR query hint for the parameterized SQL statement doesn't be applied?

  1.create a plan guide sp_create_plan_guide  @name = N'AppendixPlanGuide', @stmt = N'SELECT p.Name AS ProductName, v.Name AS VendorName,  p.ProductLine FROM Production.Product p, Purchasing.ProductVendor pv,  Purchasing.Vendor v WHERE p.ProductID = pv.ProductID AND pv.VendorID = v.VendorID AND p.ProductLine = @P1 ORDER BY p.Name, v.Name', @type = N'SQL', @module_or_batch = NULL, @params= N'@P1 nchar(2)', @hint = N'OPTION (OPTIMIZE FOR(@P1 = N''M''))' 2. execute the following sql with value 'S' in the query editor SELECT p.Name AS ProductName, v.Name AS VendorName,  p.ProductLine FROM Production.Product p, Purchasing.ProductVendor pv,  Purchasing.Vendor v WHERE p.ProductID = pv.ProductID AND pv.Ven ...Show All

• .NET Development SQLDataReader.GetOrdinal() fails rarely with IndexOutOfRange

  Hi everybody, We were developed some Web-Services that run against SQL Server 2000 with SQLDataReader that executing Stored Procedures in the DB. Most of time (95%) everything is running well, but sometimes (when exactly, we don't know) the same WebService that worked 200 times, fail. The code is simple:         public string myFunction( int ANumber )         {             string strRetVal = null ;             SqlDataReader myReader = null ;             SqlConnection MyConn = null ;             ...Show All

• Software Development for Windows Vista There's GetDefaultAudioEndpoint,but no SetDefaultAudioEndpoint

  Hello, There's GetDefaultAudioEndpoint But I need to Set it Have a function doing that Tks. http://msdn.microsoft.com/library/default.asp url=/library/en-us/CoreAud/htm/devicetopologies.asp HRESULT SelectCaptureDevice(IMMDevice *pEndptDev); the sample can't work here: // Follow downstream link to next part. hr = pPartPrev->EnumPartsOutgoing(&pParts); EXIT_ON_ERROR(hr) this part we want to get the outgoing parts list first time enter the loop it will work then it found a Connecter if (parttype == Connector) {.....} break,and trace into loop again the EnumPartsOutgoing(&pParts) will return Element not found so we can't select an Endpoint by AudioInputSelector!! any one make it w ...Show All

• Visual Studio 2008 (Pre-release) Don't Forget MARS

  If you are triyng to do lazy loading direclty with the objects, you'll get an error when you try to load children cust.Orders.Load You'll need to edit the connection string to turn MARS on MultipleActiveResultSets=true Note - I have only tested scenarios with direct object context access, not queries, so I am not saying you have to do this with queries (yet) But I have to bolt, so thought I'd put this here. The key thing to remember is that while you are enumerating the objects that result from a query there is a DataReader open streaming those results from the DB. If you call .Load on a collection while you still have that DataReader open, then we will need to execute another query which mean ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Incorrect BoundingSphere Info On Mesh

  Can I just ask anyone out there who has used the .x import and then rendered the mesh to check the boundingsphere information for me please. I have looked at the information for my mesh and it just doesnt look right. I have a quad that is 100x1x100 and the information for the bounding sphere says - d.Center {X:-16.51774 Y:0 Z:8.666386} d.Radius 88.6924744 Can someone confirm if their mesh has the correct boundingsphere info. Thanks guys, Dave. This is expected behavior like Kris mentioned exact computation of the smallest enclosing bounding sphere is possible but is slower and requires a more complex algorithm. We choose this algorithm because this method could be use for runtime bounding ...Show All

• .NET Development How to put all the value of the same Column in to an array in the datatable?

  i know that there a method to put all the value of the same Row in to an array in the datatable but is there any method can put all the value of the same Column in to an array in the datatable Thanks Hi, Or you can use this: DataTable1.Rows["ColumnName"].ItemArray It returns an array of objects... cheers, Paul June A. Domag ...Show All