Answer Questions

• desny How to restrict a custom component to be used only in the event handler tab?

  Hi, One of my plan is to develop a custom task compoent to log the errors into the destination provided as paramter to the component. Now how can I restrict the use of this component in the event handler tab only. can something like this be done Also extending this a little further, is the below thing possible The custom component should expose custom properties which should allow the user to add the destinations for logging the errors. It will be a predefined list (window event log, text file, sql table etc) and the user will be allowed to check what all he/she wants. Then if the user has selected sql table then ask for the oledb connection and the table name, if text file is selected the ask for the path of the file. Apology ...Show All

• allpdoff Which one is better?

  I have 2 tables A - having 118040500 records B(its temporary table) - having 1500 records. When I say select * from A where a.id in (Select b.id from B) A.ID is unique it takes almost 2 minutes to return data. How can I optimize this. Should I remove in with join Will it help Please suggest incase you have any other suggestion thanks in advance This may yield better results select * from A where exists (select * from B where b.id=a.id) You should just experiment with it-try all alternatives and chose the best one. Generally, the server is having more alternatives choosing a plan when executing a join than a correlated subquery, so you m ...Show All

• redshock Sharepoint 2007 Report Services Addin Install Problem

  I have the following setup: Windows 2003, Sahrepoint 2007, Report Services Addin (v9.00.3033) on one machine Windows 2003, SQL Server 2005 SP2 CTP (v9.00.3033) on another. When I install the Report Service addin on the Sharepoint machine, the install goes fine; however, when I go to the Application Management screen in Sharepoint Central Admin I don't see a "Reporting Services" section or a "Manage integration settings" link. Any thoguths Thanks, Atul I searched the computer for a log file that starts with "RS_SP", and nothing came up. But, I reinsatlled using the /log command line flag, and attached the contents of the logfile below: === Logging started: 1/13/2007 17:06:04 ...Show All

• Ben-TSK Plase HELP ! SQL ERROR =>> An I/O error occurred while receiving the TDS prelogin response.

  i get this error when i try to connect to sql server 2005 developer edition with the latest JDBC. sql string =>> jdbc:sqlserver://localhost:1434;databaseName=c1 Elvis elvis SQL STATE: 08S01 ERROR CODE: 0 MESSAGE: An I/O error occurred while receiving the TDS prelogin response. And the stacktrace is: com.microsoft.sqlserver.jdbc.SQLServerException: An I/O error occurred while receiving the TDS prelogin response. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) at com.microsoft.sqlserver.jdbc.DBComms.Prelogin(Unknown Source) at com.microsoft.sqlserver.jdbc.DBComms.<init>(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source) at com.microsoft.sqlse ...Show All

• charlestek make a stored procedure

  Hi In my table i have a datetime field now i want to delete all records there are more than 1 hour old can someone help me with this Alvin Hi, Here is a possible solution: delete from tableName where datettimeField < dateadd ( hour , - 1 , getdate ()) Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• mta37 System.DirectoryServices Performance Issue in table-valued function

  Hi, I am trying to write a table-valued function in SQL Server 2005 (SP1) to return all active directory groups a user belongs too, using managed code (VB.NET). Testing the code with a simple winform I get the list of groups in about 0.4 seconds. However the table-valued function takes upwards of 17 seconds to run! Is this normal for managed code in SQL Server Imports System Imports System.Text Imports System.Data Imports System.Data.SqlClient Imports System.Data.SqlTypes Imports System.Collections Imports System.DirectoryServices Imports Microsoft.SqlServer.Server Partial Public Class UserDefinedFunctions #Region "Constants" ''' <summary> ''' The connection string for Active Directory. ''' </summary ...Show All

• ConfigSSIS Inserting float value problem

  Hello, I wrote a stored procedure which gets some parameters and do an insertion according to these parameters. A parameter is type of float.In my own develop machine when I call the sp like this: mySP 'X', 4, 9.2 it inserts the float value 9.2 correctly. but a customer tells that when he wrote 9.2, it is inserted as 92 or 9.0. What is the problem causing this situation Hi, this is either caused because the parameter was not defined the right way either on the client or in the procedure. You will also hae to make sure that different language settings on your computer might interpret the value the wrong way,either with a decimal point or a thousend’s delimiter. To investigate the first issue you will have to see throug ...Show All

• AP Erebus ASP.Net Server Setup Exception (reqsql.exe)

  I was attampting to add application services to a remote server to my ASP database and received and exception. Setup failed. Exception: An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 8152 and the SqlException message is: String or binary data would be truncated. ---------------------------------------- Details of failure ---------------------------------------- SQL Server: Database: [consecdevdb] SQL file loaded: InstallCommon.sql Commands failed: CREATE TABLE #aspnet_Permissions ( Owner sysname, Object sysname, Grantee sysname, Grantor sysname, ProtectType char(10), [Action] varchar(20), [Column] sysname ) INSERT INTO #aspnet_Permissions EXE ...Show All

• Brandon Patram Union all does not union all rows

  Hi all, I have a Union All transformation with 4 inputs and one output when I debug the package the sum of the different inputs rows does not match the row count in output. I don't understand, I've used the Union All transform many times and I've never seen this. Any idea why this could happen Are you sure that all rows from all inputs are unique If there,say, 4 common rows coming from 4 inputs the output will return only 1 row instead of 4 I've read about this somewhere, allthough I can't recall where. I'll check. In the meantime: did you install SP1 Pipo1 I have never seen it. I think you need to provide a bit more information if ...Show All

• yaotong SqlCe Memory issue

  Hi all, I am querying an SqlCe Database on my PDA and noticed that the device is slowly running out of memory every time I execute a query. I am using the following code: public  SqlCeDataReader ExecuteReader(string command, params SqlCeParameter[] commandParameters)         {             SqlCeDataReader reader = null;             SqlCeCommand c = new SqlCeCommand(command, cn);             try             {             &nb ...Show All

• Dobojlija Export to MS Excel carriage returns

  I have a report which has multiple fields in the same column of a table. So that it formats correctly, on the stored procedure side I inserted char(10) + char(13). This allows the next field to correctly carriage return on the report. The report looks great. But once the report is exported to MS Excel, it appears to add in extra carriage returns. This can be cleaned up by going record by record and back-spacing over the carriage returns. Is there any other work around for this Just curious. Thank you for your help. T.J. I haven't found one as yet. The other minor annoyance is that when you open the exported report in excel the cells with carriage returns all have the same row height and henc ...Show All

• fulish1 How is security to FoxPro managed through Linked Server from SQL

  I’ve been working on getting a linked server through SQL 2005 to work with VFP 9. I get access denied for any and all security set ups on the linked server. I’ve checked the folder-level security settings and see that the user I’m logged in as, and have tried through security settings, and they seem to have access. What other security settings should I be checking Thanks for the help screen. I've been trying different combinations. Also trying all possible ways to open up security for various users. What I have gotten is that the SQL Server service user ID can now load through the Linked Server but I can't get any other IDs to load through the Linked Server. Good progress though. Yeah, I thought there was no other s ...Show All

• Ron Of Dynasty Software Row by Row Copy

  I'm writing a stored procedure that requires I duplicate records through a loop, one record at a time (required because I need to execute SCOPE_IDENTITY() logic on each insertion). But each row has 40 or so columns, making my stored procedure ridiculously full of long declaration lists. So I want to either: 1) Learn a way to auto-insert the column declarations into my code without having to type them all by hand, or... 2) Learn a way to represent the whole row for insertion, without having to specify each column specifically. The latter solution would be the most elegant, but I'll take what I can get... Wow, that is quite the solution.  I think I need just a wee more help...since I am so rusty/inexperienced with T/SQL ...Show All

• Kiwi bloke =Globals.PageNumber & " of " & Globals.TotalPages

  how do i get pagenumber and total pages when i try to put on the page header i get error: =Globals.PageNumber & " of " & Globals.TotalPages error: [rsPageNumberInBody] The Value expression for the textbox ‘textbox17’ refers to the global variable PageNumber or TotalPages. These global variables can be used only in the page header and page footer. Build complete -- 1 errors, 0 warnings any help please it’s ok now.. Thx Jarret. The error message [rs PageNumber InBody ] clear mentions that you are using the Global Variables in the body of the report layout. Hello Turkaum, First you need to h ...Show All

• Mazzica how to include the nulls??

  Hi, I have the following query stored: SELECT dbo.OrderDetails_Retail.ProductID, dbo.OrderDetails_Retail.ProductName, SUM(dbo.OrderDetails_Retail.Quantity) AS ProdQtyPerWeek, DATEPART(wk, dbo.Orders_Retail.OrderDate) AS SalesWeek, YEAR(dbo.Orders_Retail.OrderDate) AS SalesYear FROM dbo.OrderDetails_Retail INNER JOIN dbo.Orders_Retail ON dbo.OrderDetails_Retail.OrderID = dbo.Orders_Retail.OrderID WHERE (dbo.Orders_Retail.account = @Account) AND (dbo.Orders_Retail.OrderStatus <> 'Deleted') AND (dbo.Orders_Retail.PayStatus <> 'Pending') AND (dbo.Orders_Retail.OrderStatus <> 'Refunded') AND (DATEDIFF(d, dbo.Orders_Retail.OrderDate, @StartDate) <= 0) AND (DATEDIFF(d, db ...Show All