Little_Dice's Q&A profile

• SQL Server Distribution Database Log File Growth

  SQL Server 2000 | Transactional Replication Suspected Problem: Distribution Database Transaction Log Not Checkpointing I have a distributor with a distribution database that keeps growing and growing (About 40 GB in 7 days). The database is using the SIMPLE recovery model but the log continues to accumulate data. I have spent time looking at articles such as: "Factors that keep log records alive" ( http://msdn2.microsoft.com/en-us/library/ms345414.aspx ) and the one thing that stands out is the Checkpoint. I noticed that I can run a manual checkpoint and clear the log. If the log records were still active, the checkpoint would not allow the log to be truncated. This leads me to believe that the server is not properly initi ...Show All

• .NET Development How to Search and a Replace a string using Reg Experssion?

  Pls send me a code to search and replace. very urgent See Regex.Replace . For the future, Google would of found that very easily. Also, it's not nice to demand that other members send you code in an urgent matter. ...Show All

• Visual Studio Express Editions VC++ 2005 Question

  Hi, I am trying to use the code like the one described below...... namespace MyPhone { public class ref phone { ....... private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) { callFunc(); } public: void callFunc() { tryThis(NULL, proc, NULL); //proc is another function it has to call - Error } public: proc(void* p1, void* p2, void* p3) { .... } .... }; } The above code gives me this error: error C3867: 'MyPhone:hone:roc': function call missing argument list; use '&MyPhone:hone::EventProc' to create a pointer to member can anyone please help me resolve this error. I tried creating delegates as per msdn, but I guess, I am losing some syntax. I am not that great with VC++ .Net, can you please tel ...Show All

• SQL Server Total hours calculation

  Hi, I'm new to Reporting Services, and I have to make a sort of timesheet-report out of a sharepoint list. The sharepoint list works great, employees give in their start, stop and lunch times, and the project they are working for. Now, on my report, everything looks great, except, I can not get the grand total of the worked hours. I think I need some function in my totalHours field, but I don't know how to write this. So I am looking for someone to help me write this, and I am willing to pay for it. Can anyone help me out Thanks in advance, Natascha I would create some custom code to handle this... For example, in your textbox for the value expression, enter this: =Fields!TotalH ...Show All

• Visual Studio Express Editions Creating a table in access database Visual basic express 2005 edition

  Hey to one and all, I'm working on developing an application that is connected to access 2003 database. I made a few querys with the help visual basic express. I made a query in access to create a table. In visual basic express i'm seeing that the query is placed under "stored procedure". I would like for example if the user clicks on a button "make new table" that a new table in my database in made. I can't even access this "stored procedure". I was thinking on adding this query to tableadapter but i do not get the option to do that. Can someone explain if this support in VB express 2005.. The same query string that you used in the query genera ...Show All

• SQL Server Error 28092 when upgrading from Express to Workgroup Edition

  Hello, when I try to upgrade SQL Server 2005 using this command line: setup.exe /qb SKUUPGRADE=1 UPGRADE=SQL_Engine INSTANCENAME=Z1 SQLACCOUNT=NT-AUTORITAT\SYSTEM SECURITYMODE=SQL SAPWD=XXXXXX I get error 28092 (administrator rights needed). It seems like the upgrade tries to use Windows authentification although I've told it to use SQL Server authentification. Or did I miss a parameter in my command line If I do the upgrade manually it works without needing Windows authentification. This error means that the user who is running the setup is not sysadmin in the SQL instance. It makes sense this happens on Vista because of AUC the user is not recognize as NT administrator. You need to add yo ...Show All

• Visual Studio Tools for Office VSTO Tools Add In, Outlook 2003

  Hi, we created an Add In using VSTO Tools for Outlook 2003. We have a problem when Outlook 2003 is running and another application has it as well, and we close Outlook, it still runs in memory but when we open Outlook, our Add In disappears. Is there any event or something we can do to make the Add In shown always Thanks! If you still have Outlook loaded in the background (for whatever reason) and you click the 'Outlook' button, Outlook is not actually started... A new explorer is created. So if outlook is running in the background already, you will not his the addin loader (because it already ran on the outlook application that is running). You need to handle the events for new explorer and ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Blending Multiple RenderTargets to the BackBuffer (Another RT)

  Ok. I am trying to write a SceneManager that contains a list of RenderGroup. Each RenderGroup is responsible for rendering a set of items (models, etc) to a RenderTarget and then rendering their RenderTarget to the BackBuffer (in this case a RenderTarget that SceneManager sets). The Problem: Blending between RenderTargets is not working. I have it working so when a RenderTarget is rendered multiple times with separate passes in the PixelShader it blends in Add mode. Between to RenderTargets, or RenderGroups in this case the blending fails. No matter what order I have the RenderGroups setup, it just won't blend correctly. Here is a picture of what I am trying to do: http://images.jsedlak.org/random/Xna5D_SceneManager.jpg ...Show All

• Visual Basic what is wrong with this?

  dim y_m as double dim y as integer y_m = 6.09 For i = 1 To 12 y_m = y_m + 0.01 y = y_m If y_m = CDbl(y + 0.12) Then y_m = y + 1 End If Next When y_m is 6.12 the if statement doesn't catch that fact!!! The CDbl() function doesn't seem to help. It doesn't work whether or not I have the conversion function. Single precision is even worse because adding 0.01 several times gets you not 6.10 and 6.11 but something crazy like 6.110002. Brian Double and Single data types are floating point numbers, they usually do not contain the exact number but something very close. You might want to use Decimal instead. You should never use floating point numb ...Show All

• Visual Studio 2008 (Pre-release) Request some naming convention in LINQ to SQL Attribute Properties

  I was just doing some reading, and I find that the Association IsParent property's name is a little confusing as to which entity class, source or target, it is pertaining to. ThisKey and OtherKey are fairly clear, but the IsParent is not. Since it applies to the target class, renaming it to OtherIsParent would be more intuitive. Thanks. In January CTP, we do not have IsParent anymore. It is replaced by IsForeignKey. If you look at the XML file extracted from the database by SqlMetal, you may find in <Association> there are RelationshipType and IsForeignKey attributes. RelationshipType can be OneToOne or OneToMany. If the value of RelationshipType is OneToMany, IsForeignKey specifies the child/many side when it is true. The M ...Show All

• SQL Server Visual Studio Output information in debug mode while running a SSIS package

  Hello When running a package in VS you can see something like this in the output window: SSIS package "logging.dtsx" starting. Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning. Information: 0x402090DC at Data Flow Task, Flat File Source [1]: The processing of file "C:\test ssis logging\bad_data1.txt" has started. Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning. Warning: 0x8020200F at Data Flow Task, Flat File Source [1]: There is a partial row at the end of the file. Information: 0x402090DE at Data Flow Task, Flat File Source [1]: The total numb ...Show All

• Visual Studio 2008 (Pre-release) LINQ to SQL Feature Request: Automatic generation of temporary Stored Procedures based on LINQ to SQL statements

  Hi,   I would like to see a feature in LINQ to SQL, where we can group a set of LINQ to SQL statements into an object, which could be converted into a code by compiler that creates a temporary stored procedure in the target database. This way we could run a single or set of LINQ to SQL statements as stored procedures and get the benefits of stored procedures like eliminating round tripping to database, pre-compiled queries, etc. At the same time we will not be dealing with permenant stored procedures.   This technique will have all the benefits of writing stored procedures in C# and being executed inside database, which is a perfect world when compared to straight LINQ to SQL queries and TSQL based stored pr ...Show All

• Visual Studio 2008 (Pre-release) Mutual authentication using Kerberos

  I am currently attempting to understand how to configure a WCF client / WCF service to be mutually authenticated via Kerberos. I would like to self-host the WCF service in a Windows service, running under a Windows domain account (MyDomain\WCFHost). From reading various posts in this forum, my understanding is that using this configuration will cause svcutil to generate the following identity element in the client's configuration: <identity> <userPrincipalName value="WCFHost@MyDomain.com"/> </identity> One of the requirements I have is for the client to be able to determine whether the WCF service has been spoofed. Using the UPN as part of a mutual authentication sequence appea ...Show All

• Visual Studio Express Editions how to make password(login form) case sensitive?

  how to make login form password case sensitive I got it now thx.... Dim theDataReader As SqlClient.SqlDataReader = theSqlCommand.ExecuteReader(CommandBehavior.CloseConnection) Dim pass As Object = Nothing pass = theDataReader ("password") if pass <> password.text then msgbox ("incorrect username/password") Else 'do what ever you want!!! End If ...Show All

• SQL Server Ignore NULL values in List Control

  Hi Everyone, I have just started creating some reports using SQL Reporting Services and have run into a problem now. I have a SQL query that returns data in the following format. Field 1 -- Field 2 -- Field 3 NULL A 1 NULL A2 S$ NULL NULL NULL F3 Okay now I have 1 list control that takes 1 Field (Field 1). The problem I am having is that it is creating a new line for every null value and I only want it to display the valid values... I presume I use the Format part of the field to do this, but how would I do that Thanks, Gavin I would create a new dataset that controls your list, then only select values from FieldA that are not null. It is normal in SSRS to have many data ...Show All