Hacker Boy's Q&A profile

• SQL Server sys.Conversation_Endpoints

  I know that if a conversation is normally ended the handle will wind up in the sys.Conversation_endpoints table in a Closed State. I realize they are supposed to stay there for 30 minutes to prevent a reply attack, however the number of rows I have in this table continues to grow with the bulk of the states set to 'Closed'. I am trying to use this table to determine if I have any conversation handle leaks. I see some rows in there with a Disconnected Outbound state while some are conversing. What should I be looking for in this table and how can I know I have a problem (ie. leak). I realize that Disconnected Outbound is probably something i need to look into. Are there any other states I should be concerned with Gary ...Show All

• SQL Server Export To Excel

  Hi, I'm trying to use the export to Excel (Excel Destination) however, I wish to supply a dynamic piece of SQL to generate the data. When I set the properties I just get an option to enter "Table or View", "Table or View as Variable" or "SQL Command". The issue is that the table does not exist until the SSIS job is run and the columns will not always be the same anyway. How can I use a simple dynamic piece of SQL (or stored proc) to get a recordset that is simply dumped out to excel - rows... columns... nothing more . Help very much appreciated - Paul. Yeah... I was worried someone would say as much ! What on earth is wrong with sending a dataset of *unknown ...Show All

• Visual Studio Team System Independent builds

  I have a requirements of creating independent builds. I will try to explain the scenario. Let us assume that I have a baseline build already done. Now, I have work item (WI) 1 (that contains csharp code and some DML and DDL) and WI5 that contains the same things. With these two together, I create a build. Let me call it Build1. Again I have WO2 that has some C# code and DML and DDL. I need to create a build that will contain WO2 only. Let me call this build Build2. Purpose is I need to move these builds independent of each other. So, if Build Build1, only WI1 and WI5 will get promoted to the desired environment. On the other hand if Build1 should not move further, I need option of moving Build2 to the same environment where Build1 ...Show All

• SQL Server need help to connect to remote server from client

  Hi, I have a small problem. I have installed MSAS2005 (Analysis services) and Client components and Books online from the advanced option say machine A. I have a MSAS2005 server running on a remote machine say B. I wanted to connect to the server on B from A. When I am trying to connect I am not able to see the cubes on machine B. Things that I have done. Machine A Installed Client components, books online, Analysis services. Haven’t processed the cube. Machine B Have installed everything and have processed the cube. Is it possible to connect in this way. Or have I missed anything. Please let me know. Thanks in advance for the assist. Boudhaditya Hello Boudhaditya, ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Activator.CreateInstance on .Net compact

  I've got a bit of code that loads an assembly dynamically and invokes a constructor working fine in PC XNA but I can't find the equivilent under .Net Compact on the 360... PC Assembly assembly = Assembly.LoadFrom(s); Type mainClosure = assembly.GetType(scriptName + ".MainFunction"); LuaClosure cl = (LuaClosure)Activator.CreateInstance(mainClosure, new object[] { L.Globals }); Attempt on 360 Assembly assembly = Assembly.LoadFrom(s); Type mainClosure = assembly.GetType(scriptName + ".MainFunction"); ConstructorInfo ctor = mainClosure.GetConstructor( BindingFlags.Instance | BindingFlags.Public, null, new Type[] { typeof(LuaReference) }, null); LuaClosure cl = (LuaClosure)ctors[0].Invoke(new Object[] { L.Globals }); Which f ...Show All

• SQL Server Passing different number of parameters to a Stored Procedure

  Hi to all, How can I Pass different number of parameters to a Stored Procedure In my Requirement, Some times i want to pass 2 parameters only, In some cases i want to pass 6 parameters. How can i do this Please give me a solution. Thanx in advance... You will have to use optional parameters then. The procedure head should look like something as the following: CREATE PROCEDURE SomeProc ( SomeParam INT = NULL, SomeOtherParameter INT = 2 )(...) HTH, jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server How to dynamically enter error code and description in a pre-define table?

  Hi, I want to implement error handling my SSIS package. for this I am putting an execute SQL task for a container(which contains different interlinked tasks) in event handler. Say my first task fails in this container.Immedaitely my sql task which inserts the error code and description should exceute in the event handler and populate my error table in OLAP database. Any help will be great SSIS gurus. Thanks in advance. Regards, Aman Why does it not work As a concept it is soundf, and we use it in practice, so can you gives us an error message Another alternative is why not just use the built in logging to table option, and save yourself some work Perhaps even combine this with some of your own logging if you need ...Show All

• Visual Studio Express Editions Listbox Help plz

  How do I hide a url address in a listbox and change it into a name For example i want a user to click on the name (eg. Radio 1) in the listbox without giving out the full address, which then plays through media player. Im using visual basic 2005 express edition. Here's a completely different approach: Public Class Form1 Private Class MyListItem Public mText, mUrl As String Public Sub New(ByVal txt As String, ByVal url As String) mText = txt mUrl = url End Sub Public Overrides Function ToString() As String Return mText End Function End Class Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load ListBox1.Items.Add(New MyListI ...Show All

• Windows Search Technologies ADM File for WDS 3.01 not Working

  Hi, I have run the installer, copied the extracted folder and located the desktopsearch30.adm file. When I import this into GPMT I cannot locate any of the settings within the User Configuration area. I was expecting it to be User Configuration\Adminstrative Templates\Windows Desktop Search or similar. I have imported the MSN Search Toolbar ADM without any problems and straight away the settings were viewable. Am I missing something, has anybody seen this before Regards Ben Posting this in this thread as it is more specific to ADM files than the Admin Guide. It would appear that the version 3 adm file is missing many of the settings that was in the previous version, including your Outl ...Show All

• SQL Server DataReader output column length

  Hello, I have an ODBC connection manager to a Progress database. In that database there is a column declared as a string of 10 characters long. However, some data in this column is actually up to 15 characters long. This makes my DataReader Source fail everytime I try to run my package because it sets the output column like this : Datatype : Unicode string [DT_WSTR] Length : 10 Is there any way to solve this without changing the datatype in the Progress database (that is beyond my control) tanks in advance ... Thoroughbred still lives Aaargh! The only implementation of a computer language I ever saw that allowed indefinite GOTOs (I'm not kidding). I had not heard about this "integrity& ...Show All

• Visual Studio Team System Sudden Expiration of TFS Release Candidate and no upgrade path

  Problem Context: I am a Certified Partner with an ISV Competency. My shop has been on the TFS Release Candidate since it became available in February 2006. Developers connect to TFS using Visual Studio Team Developer installed from our monthly MSDN DVD distribution. The Problem: Last night, our TFS RC instance began throwing the following exception to all clients: " HTTP Code 403: TF30072: The Team Foundation Server trial period has expired or its license is otherwise invalid. Install a licensed editition of Team Foundation Server to continue ." As you might guess, development ops are severely blocked, since nobody can access TFS. I called Partnership Support to ask for guidance. They said that ISV pa ...Show All

• SQL Server Problem exporter PDF.

  Hello everybody: I have a simple report (table), and when I make export in PDF, he(it) takes out to me a badly formated file PDF (columns moved and empty pages). It is what the problem Thank you in advance. Thank you for your reponse: but I have any attempt but uca marche not, you can look at the .PDF file http://ftf-166.yousendit.com/download/1/ED443F25437C8D89/f2aa0f49f46c00359990203df421f4b6476a6e19/Situation%20de%20compte%20MBE.pdf and say to me it needs to put what to post(show) 4 columns. Thank's ...Show All

• Visual Studio Team System Query error when team project name contains spaces

  I create a report and take team project name as a parameter. It works well when the team project name doesn't contain spaces, but get query fail error when the team project name with spaces (e.g. My Project). The query is created from the query builder. SELECT NON EMPTY { [Measures].[Current Work Item Count] } ON COLUMNS, NON EMPTY { ([Work Item].[Microsoft_VSTS_Common_Priority].[Microsoft_VSTS_Common_Priority].ALLMEMBERS * [Work Item].[Bug_IssueType].[Bug_IssueType].ALLMEMBERS * [Work Item].[Bug_Severity].[Bug_Severity].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@AreaParentID, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@TeamProject, CONSTRAINED) ) ON COLUMNS FROM ( ...Show All

• SQL Server how to change the data label in SQL?

  I have the following SQL statement.. select month ( dbo . udfAddUTCBias ( start_date_time , 180 )) as report_month , direction as direction , count (*) as total_records from traffic with ( nolock ) where dbo . udfAddUTCBias ( start_date_time , 180 ) >= '2/24/2007' and dbo . udfAddUTCBias ( start_date_time , 180 ) < DateAdd ( dd , 1 , '2/24/2007' ) group by month ( dbo . udfAddUTCBias ( start_date_time , 180 )), direction but the result of the direction field is 1 and 0.. however, I need to show inbound when the result is 0 and outbound when the result is 1 without changing the actual data in the table. You could use CASE keyword: http://msdn2.micr ...Show All

• Visual Studio Express Editions Centering image in picturebox?

  Is there a way to center an image inside the picture box or for that matter align the image in some way picBox.SizeMode.CenterImage = PictureBoxSizeMode.CenterImage This doesn't work i get an error msg: "Constant cannot be target of an assignment" ...Show All