Answer Questions

• Sukhbir Dalal embedding a DTS package and logging/error reporting

  Hi All, When the embedded DTS package fails at runtime, and logging has been enabled for the package (and all log events selected for reporting on for the package and the task), the DTS error (i.e. any meaningful errors) are not thrown up to/caught by the SSIS/outer level. All you get is something like: COMException - error returned from a call to a COM component. Does anyone have any comments &/or know to get errors thrown from within an embedded DTS package, thrown up to the wrapping SSIS package Cheers, Tamim. Hi Tamim, Try configuring your DTS package (using the old SQL 2000 designer) to log to an msdb database (it can be a SQL 2005 msdb). Then you will find the DTS messages logged to t ...Show All

• Can-Ann Not quite right...

  We keep a database of events that are classified by severity. I've got a good, efficient query that gives me the grand total for these events. And I have a bad slow query that breaks down the information into daily totals. My fast query will count the totals for 3213586 events in 4 seconds. The slow daily query takes about 60 seconds for each day. Please help optimize my slow query! ------ Database schema is: Column Name Data Type Length Allow Nuls 1 msrepl_tran_version uniqueidentifier 16 0 0 [time] GMTtime (int) 4 0 0 msec int 4 1 0 offset GMToffset (smallint) 2 0 0 type nameType (varchar) 15 ...Show All

• .NETBloake Union problem

  I have follow query declare @z int select id from table1 union select id from table2 i want after union in @z save value 0, 1 or 2. 2 - when first and second select returns any results 1- when one of selects return any result, and another return nothing 0 when both selects returns nothing Can you help me. How i solve this problem Hi, you probably would have to query the resultset a second time: SELECT SUM(SomeSum) FROM ( Select TOP 1 1 SomeSum From Table1 UNION SELECT TOP 1 1 SomeSum From Table2 ) SubQuery HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- 10x this is a good idea. Now I have another problem. I ...Show All

• Mateusz Rajca Intermittent Connection Problems with Sql Server

  I am experiencing intermittent connection problems with the Northwind database and sql server express. The most frequent error message indicates that I am already logged in and will not allow another user. The odd thing is that even when I am locked out I can access a Northwind database from another connection on Server Explorer. I ran code to demonstrate simple binding for two text boxes, no problem. I added a project to show complex binding using the datagrid view tool, but could not get past selecting the database. I tried the same simple binding project on another computer running a beta version of VS 2005 Pro and could not connect to Northwind on that computer also. (Two different Northwind databases, different computers) ...Show All

• Nilabja Roy How to import flat files into Microsoft SQL 2005 Express Edition automatically?

  Iam aware that Microsoft SQL 2005 Express Edition does not have agent or DTS capabilities, but how may I automate an import of flat files to the DB tables Must I use an external VB development of is there a way to schedule an import of flat files to Microsoft SQL 2005 Express Edition These approaches never occurred to me. I have found my heroine. Thanks for the great tips! -B hi, Kraven3d wrote: Here is a sample of the data and what I need to do with it. 1ETTX800401V411TTX BNSF851293 1ETTX800913V411TTX BNSF840295 This data needs to be brought into the data base as: 1 ETTX 800401 V 411 TTX BNSF 85 1293 1 ETTX 800913 V 411 TTX BNSF 84 0295 The seperation will ALWAYS occur af ...Show All

• johnny_no1_boy Error with Management studio - collation problem

  I receive the following error when trying to right click / properties on a database in Management studio. I caught the sql causing the problem, and fixed it by adding explicit collation definitions. Can this be integrated into a service pack / hotfix (I cannot view and of my databases as the model database collation has been changed. This was done to protect against collation problems in the tempdb database) =================================== Cannot show requested dialog. =================================== Cannot show requested dialog. (SqlMgmt) ------------------------------ Program Location: at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDialog(XmlDocument initializationXml, IServiceProvider ...Show All

• manick312938 Minimum config to upgrade 2000 to 2005?

  I am trying to upgrade from SQL Server 2000 Developer Edition (SP4) to SQL Server 2005 Developer Edition. I want to be able to use Reporting Services in the 2005 version. But the 2005 Upgrade Advisor says: Reporting Services is either not installed or is installed incorrectly. - Virtual directory settings do not match the default configuration - Custom virtual directory settings block edition upgrades - Custom extensions are deployed on the report server - ASP.NET account information is encrypted What do I need to install from the 2000 product in order to be able to upgrade to the 2005 version That step didn't report any errors, it worked out great. The only config step I still have problems with is Encryption Keys (which repor ...Show All

• KervyChoa Tricky SQL Problem

  Hello all, I'm very new to SQL, but find myself with this problem that i've been working on for a while, but I just can't figure out how to work through it. I've got a database of appointments for vehicles. This database holds start time, month, day, year, end day month, year... etc. I want to make a query that allows users to select a begining year, month day etc. and ending month year etc. so i've got this query (I'm using PHP, so the $...'s are just $_Post variables. so here's my query: $query = "SELECT * FROM `appointments` WHERE start_year BETWEEN $start_year AND $end_year AND start_month >= $start_month AND end_month <= $end_month AND start_day >= $start_day ORDER BY start_year, start_month, start_day, start_ti ...Show All

• Squirrelz How to use parameter with LIKE?

  Hello. I have a query that ends like this: WHERE ID LIKE '12345%' I want to replace the '12345' with a parameter name p_id. If I'm useing only p_id without the % it ok but if I'm useing the % after the parameter I'm getting an error. I'm working ORACLE database. Any ideas Thanks in advance, Roy. Or, if using native Oracle vs. OLE/DB: Where ID Like :your_parameter || '%' Hope this helps, Don Shelman try this WHERE ID LIKE :your_parameter + "%" ...Show All

• JavaBoy NEWBIE.. SQL EXPRESS Attach during VB.NET Windows Application Install - Oneclick

  Here's what I'm going for: I have an 05 VB.NET windows application that will be used as a smart client for our folks in the field. The windows application includes 05 SQL Server Express. I have included in the Data Sources of my project and attached file going through the wizard Microsoft SQL Server Database File (SqlClient) ='s (myfile.mdf) and then selected all tables, views, stored procedures, and functions... the corresponding myfileDataSet.xsd with the myfile.mdf are now located in the root of the project. I now recompile the project without error and go to the properties section Publish tab... select the Application Files button and myfile.mdf Publish Status is set to Include and the Download Group set to Requried. With this in p ...Show All

• magicalclick Publishing reports to different versions

  I have Visual Studio 2005 and Reporting Services 2005 on my client development machine. I want to publish the reports to an SQL Server 2000 with Reporting Services 2000 server, is this possible I get the following error message: The report definition is not valid. Please verify that the report definition uses the current report definition namespace (i.e. ‘http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition’). (rsNotACurrentReportDefinition) Get Online Help Thanks. Bruce Unfortunately, you will not be able to use the 2005 report designer to publish directly to a 2000 report server. This is due to the fact that the RDL's (Report Definitions) created are different betw ...Show All

• Vijay Guru Prasadh Can someone clarify why only a single-statement can be executed in a command?

  I'm evaluating SQL 2005 Everywhere Edition for use by our desktop application. I'm a traditional SQL Server developer and I rely heavily on stored-procedures to encapsulate basic data manipulations across multiple tables and inside multi-statement transactions. I was excited to see an in-process version of SQL released and my thought was "this is great... now I can ditch the tediousness of individual OLEDB/.NET commands, and write batches of T-SQL and just focus on the data manipulations". But, alas, it seems I cannot. Why is SQL Everywhere Edition limited to executing a single SQL statement at a time For example, my application would like to update mutlipe rows in one table, delete multiple rows from another, and insert mu ...Show All

• Sunil Virmani SQL 2005 DW and BI Features comparison to SQL server 2000

  Dear all, I am developing a proposal to my company, which is a microsoft select client, for introducing SQL 2005 to a new BI project. The company already has SQL 2000. I would like to have a full tabular format of SQL 2005 DW and BI Features comparison to SQL server 2000 (SSIS, AS, RS). Most of feature enhancement paper has only tell what is new but not tell about what is already existed and how much it is improved (in quality and quantity). Yes, tabular format is more useful. I tried to search through microsoft.com, technet but still cannot find the relavent one. Would you please give me a web link Best regards, CJira Dear all, Where should I ask this kind of question Please su ...Show All

• Tony P Brightman sql server trigger

  Dear Sir/madam, I have two tables AccountGroups and AccountGroups_Bal. I want whenever a record is inserted in to the 1st table, a corresponding record should be inserted in the 2nd table. both tables have the "code" column. USE [DealSoft] GO /****** Object: Trigger [dbo].[trgAccountsAdd] Script Date: 03/01/2007 12:38:49 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TRIGGER [dbo] . [trgAccountGroupsAdd2] ON [dbo] . [AccountGroups] AFTER INSERT AS INSERT INTO AccountGroups_Bal ( code ) VALUES ( select code from inserted ) the following trigger gives the below mentioned error Msg 156, Level 15, State 1, Procedure trgAccountGr ...Show All

• jbreaux Error creating Subscription to reports

  Hi all,   I am having a HUGE issue with SSRS, I am running SQL 2005 on Win 2003 server, the SQL uses SQL and windows permissions. I have a datasource which stores it credentials securely on the server but for some reason when i try to subscribe to the report it errors saying "Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked server the link is no longer valid." Beats me but the credentials are stored, I am  connecting using a user account which can run the report fine (This is proven). I have SP1 installed, and have literally tried every last option in the book.   N.B i have read all the existing post about this and i seem to have a different ...Show All