Deac910's Q&A profile

• SQL Server the cost of security auditing

  has anybody investigated the cost of turning on AUDITING for the SQL servers I am talking about enabling the entire C2 Security Audit mode. How much impact the auditing has on the database performance Is auditing for SQL 2005 any better, meaning less impact on performance Any sample, test, and/or numbers to support the arguments Please share any findings that you have or know. Thanks If it is a OLTP (frequent updated) 24/7 based application then it will have impact during the database maintenance jobs and other bulk load jobs, if any. Also you need to take care of disk free space in any case, otherwise the server will have other issues. I suggest you to turn on on the test platform to see what kind of process it follows ...Show All

• Visual C# Referenced DLLs - How to dynamically update the path of the reference dlls in another solution?

  Hello, I am working with 2 C# solutions right now, 1 is the main application we are creating (let's call it MainSolution.sln for now), the other is a unitTest solution (UnitTest.sln) created as a separate solution file, as the main solution consists of too many projects and compiling it takes a long time. It was created separately also because different groups of developers can work on the respective solutions they are tasked to do. In the UnitTest solution, we create unit tests for the main solution classes, hence, for each project in the unitTest solution, I've added references to the respective main solution dlls. A typical full path of the Main solution's DLL is C:\MainApp\<foldername>\bin\Debug\<filename>.dll I'm cur ...Show All

• SQL Server (Newbie) Outer Join Simulation

  I have two tables invoice(fact table) and agents(dimension). Not all invoices have an agent. How do I use the agents table as an outer join When I include agents as a dimension and look at all agents, I only get invoices that have an agent. I know I could create a view in SQL but I want to do this in the cube. Thanks, Bill You can create an unknown member in your agent dimension table and connect all fact records without an agent key to that member. You will have to use TSQL to this. SSAS2005 can help you with doing this without writing code. Have a look at inferred members in BOL! Regards Thomas Ivarsson ...Show All

• Visual Studio Express Editions connect to master database

  i've seen samples for this, but can't get it right to connect master database while trying to create a new sql database. it says it can't open connection and there are some error messages about: sql server default settings and remote connections aren't allowed, and when i try to change it, it says about the named pipes provider error. here's the connection string i'm trying to use: Dim sqlCon As New SqlConnection( "Password=;Persist Security Info=True;User ID=sa;Initial Catalog=master;Data Source=local" ) where could be the problem, change settings, add references, or something else i will post more specific error messages later if needed. thanks again. what dyou mean loc ...Show All

• Internet Explorer Development Internet explorer 7 MUI pack

  Hello, I have Xp pro with multi-language user interface for the dutch language(and other languages). What means that xp is basically english but everything else is in dutch (menu, help etc...) Now my problem started with IE7 install I wanted to install the dutch IE7 version but I got the error message that the language of the operating system is not supported by this download (IE7-windowsXp-x86-nld.exe) So I installed the english version that did work BUT now all my IE7 menu etc.. is in english now Is or will there be a MUI pack for IE7 that will change my menu' back to dutch If there will be a MUI pack when is the release date If allready available please send me the correct link. Help would be appreciated. ...Show All

• SQL Server Dervied Column - Expression?

  Hi: I have a Dervied Column Component, in which there is a column called RecStatusCode. The criteria to give a value to that column is below in SQL: (SELECT CASE CertParticipant WHEN 'Y' THEN 'C' WHEN NULL THEN 'A' END FROM [dbo].[SchoolCertRequest] WHERE SchoolID = (SELECT SchoolCode FROM [WebStrategy].[LAF].[LoanApplication] WHERE LoanApplicationID = @LoanApplicationID) and SchoolBranch = (SELECT BranchCode FROM [WebStrategy].[LAF].[LoanApplication] WHERE LoanApplicationID = @LoanApplicationID) AND LoanType=(SELECT LoanApplicationTypeCode FROM [WebStrategy].[LAF].[LoanApplication] WHERE LoanApplicationID = @LoanApplicationID)) My question is how can I use this SQL in that expression field, or is it possible to have a u ...Show All

• .NET Development Abortable thread with return value

  Hello, There are two possible solutions that would work for me here... Requirements are as follows: I want to run a task in the background. The task returns a value, which I need to collect. I also need to be able to abort the task. I can use Thread.Start, and then Thread.Abort if I need to stop it, but I can't find a way to get a return value by this method. Alternatively, I can use BeginInvoke, which makes it easy to get a return value using EndInvoke, but then I can't seem to find a way to abort the thread. Either method would be fine. Any suggestions Thanks, Nick Dan, The answers have been interesting, but miss the point somewhat. Probably because I didn't take the time to explain ...Show All

• Visual Studio Team System deploy/schema compare scripts - Option for checking IF EXISTS

  My scripts need to check for existence of tables, columns, etc. before creating or altering. My procs and functions need to check existence and drop if they do already exist then create. Is there any way to control script preferences to accomplish this Yes, I could do that if time wasn't an issue. In reality, it's not feasible. I have 40 databases in production today and my company is selling more self-hosted product. I'm with a small company and my DBA duties are only portion of my job. Will this feature be added to the next version Thank you for considering this. ...Show All

• .NET Development C# Com Interop problem - should be simple!

  I have some trivial vb6 sample code that uses a com dll to interface to talk to some hardware but I can't seem to port it over to C# Interop successfully. I have tried many permutation of marshalling attributes but I get a "Attempted to read or write protected memory..." exception with types I believe will work and DataTypeError returned from the com interface function if I am deliberately incorrect with the types.   The com interface declaration in OLE Viewer: long RpcCall(long iJobCode, VARIANT SendData, [in, out] VARIANT * RecvData);   The sample in vb6: Dim n() as Byte Dim r() as Long n = StrConv("Time_s" & vbNullChar, vbFromUnicode) conn.RpcCall(10012, n, r)   The intero ...Show All

• Visual Studio Express Editions VB 2005 to Send Email

  I regularly have to send on a daily basis approximately 20-30 emails which are processed by an email-based SQL server that then returns the results (via email) to my Inbox. And before you ask what kind of messed up approach this is - hey, I didn't make it, I've just got to live with it. Here's the deal - all the email I send has the same TO; SUBJECT; and nearly the same BODY (body is the same except for two items that are changed each time). Also, my evironment uses an Exchange server, so while I've seen some of the code for using SMTP, all of it references authentication - since I'm local to the Exchange server and use Outlook, I wouldn't think I would need to authenticate - but perhaps I'm wrong. What I'm trying to accomplish is tw ...Show All

• Visual C++ problem with LoadRunner for Framework2.0 Application(C#)

  Hi, I need to call a C# dll from C (Mecury LoadRunner Vugen Script to be more specific) I have been told that i need to create a C++ wrapper class, and have instructions for doing this for Visual Studio 2003. I have using Visual Studio 2005 and understand it is different to create a mixed mode dll with .Net 2.0 Also I am very unexperienced with Dlls and C++, but i understand that i need to do something with structs in order for me to pass strings across from my C# managed code dll to my C++ wrapper dll and then finally the call from my C script. Thanks The syntax has changed from Managed C++ (__gc class) to C++/CLI (ref class). You can still compile MC++ programs with the /clr:oldSyntax compiler option. VS2005 does this aut ...Show All

• SQL Server DataFlow task fails?

  Hi: I am getting the following error when I start debugging my Package, I am not sure what this is related to, but basically, input (datatype is a int, and its mapped to a column which is also int), so I am not sure whats happening here. The input column is actually a derived column, and its set as a 4 byte un-signed int, please advice on where should I start looking to troubleshoot this issue. This loanapplicationid is actually a user variable that is utilized by other tasks in my control flow as well: Error: 0xC020901C at InsertApplicationCL5, OLE DB Destination [16]: There was an error with input column "LoanApplicationID" (1161) on input "OLE DB Destination Input" (29). The column status returned was: "Th ...Show All

• Windows Forms Is it just me :o(

  Hi, I have been trying to find an answer, even a hint, but despite posting the following question on various forums i haven't even had a single reply for nearly two weeks :o(. "Why do treeview tooltips flash if the main form has its transparencykey set " Could a couple of people please try this (its a 67 second job) just so i know it isn't just my PC :o) You can replicate this behaviour really easily by (c# VS2003) 1) creating a new c# windows application 2) set Form1.TransparencyKey to the same as Form1.BackColor 3) Add a treeview to the form 4) Add a node to TreeView1 whose text is too long to display (i used 'whyisthishappeningwhyisthishappeningwhyisthishappeningwhywhywhy') 5) run the application and hover your ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Text Renderer and Font Generator

  Check out my font rendering system. I think its the easiest one to use that's out right now that can handle any character set :) There is full source to the font generator as well as the font renderer. Here is a tutorial on how to use the font renderer as well as the downloads to the generator and a sample that uses it. http://www.ziggyware.com/readarticle.php article_id=44 All of the samples on my site that render text use this system. http://www.ziggyware.com/articles.php cat_id=6 This class (TrueTypeFont) does not work with the AngelCode tool mentioned. I used the BitmapFont tool to generate a ".fnt" file as text and it cannot parse the text w/o throwing exceptions. ...Show All

• Software Development for Windows Vista Returns non-zero value for the handle while using LoadLibrary in vista

  Hi, I tried this code directly from the following link: http://www.devx.com/vb2themax/Tip/18307 It worked fine on my XP machine.But when i tried the following code on my vista machine...even when the Dll did not exist it returned a non-zero value...whilst it shud return null. please help me. Private Declare Function LoadLibrary Lib "kernel32" Alias "LoadLibraryA" (ByVal _ lpLibFileName As String) As Long Private Declare Function GetProcAddress Lib "kernel32" (ByVal hModule As Long, _ ByVal lpProcName As String) As Long Private Declare Function FreeLibrary Lib "kernel32" (ByVal hLibModule As Long) _ As Long Function IsProcedureAvailable(ByVal ProcedureName As String, _ ByVal DllFilename As String ...Show All