Answer Questions

• John Portnov Applying a diagonal line in a report

  My client cannot workout how to apply diagonally aligned text on a report. We need to apply the text on statements and invoices to alert the clients to accelerate their payment, or notify them of account issues. Could someone please tell me where I could find the information required to do this so I can forward it to the client. I don't know how to do this, but this concept is typically referred to as adding a "watermark". HTH your searching for an answer ...Show All

• MattWilkinson2006 how do i use select top.. in a different way???

  how do i: select a second item of the top 3 most recent added item from the Product table Product ======= item ItemName AddDate ------ --------------- ------- 1 Apple 3/1/2006 2 Tree 6/5/2006 3 Grass 3/7/2006 4 Orange 2/1/2005 5 Cat 9/1/2006 Thanks, Alan, select top 3 * from Product order by AddDate desc In SQL Server 2005:   SELECT     x.Item,     x.ItemName,     x.AddDate FROM (     SELECT TOP(3)         Item,         ItemName,   & ...Show All

• Saibal Goswami Merge Replication with SQL Mobile 2005

  We are using SQL 2005 (SP1) and mobile agents with SQL Mobile. We are seeing an excessive number of updates after a device's database is reinitialized. My understanding was that if I generate a new snapshot or reinitialize all subscriptions (from the server), the devices would only get what the database looks like right now (inserts only) after syncing and/or reinitializing, but they are actually getting the right number of inserts and a huge number of updates in Replication Monitor. Any ideas Thanks! Mike First of all, I have an update. We recreated the publication on our test server as well as our production server (causing outages to our customers). After doing so, everything went back to no ...Show All

• mcrisf Problem with SSIS Package (dtsx)

  Hi all! I have open the one package dtsx and return this error: Error loading 'Test.dtsx' : Error HRESULT E_FAIL has been returned from a call to a COM component.. c:\projects\... etc.. which the problem THX The full error message or messages would hopefully include the real cause, that is not enough, and a bit more background about where thsi package came from and when it last worked compared to now. What tool is opening the packge  Dtexecui or BIDS (Visual Studio) If BIDS, is the package part of different solution/project other than the one in which it is opened, or part of any solution/project at all Reason I ask is that I have noticed this same message in BIDS in certain circumstances& ...Show All

• banababa Cross-tab query in SQL Server

  I have a table with results from several inspection tests. The Pass/Fail parameter in the cross-tab output would be Pass if all tests for that serial number are Pass, and Fail if any of the results for that serial number are Fail. How would I create a cross-tab query in SQL Server Table for input to cross-tab query: [Inspection Data] SerialNumber ParamName Result Pass/Fail 001 Test1 3.43 Pass 001 Test2 3.27 Pass 001 Test3 2.97 Pass 002 Test1 2.88 Pass 002 Test2 3.01 Pass 002 Test3 4.22 Fail 003 Test1 3.11 Pass 003 Test2 2.91 Pass 003 Test3 3.28 Pass Cross-tab Query Out ...Show All

• Jacx Application unable to connect Sql Server 2005

  Hi, We recently installed Sql 2005 server and it was working fine. But today one of our user reported that they could not able to connect the sql server 2005 from the application. When I checked the error log, I found the following error for every one minute. We restarted the sql service on this sql 2005 instance but still we are getting the same error. SSPI handshake failed with error code 0x80090311 while establishing a connection with integrated security; the connection has been closed. Could any one help us on that Regards, Sankar Hi, SanKar Is your computer in a Domain If so, it seems the problem that no KDC can be contacted. Suggest: 1) Disjoin the domain and rejoin your co ...Show All

• DonMartin Excel file stays in use after I import it using a SSIS package

  Hello everybody... I have a very simple SSIS package that loop throught the worksheets of an Excel file and insert the data into a SQL server 2005 table. The SSIS is very simple and works fine the problem is that after the Package executes if I double click on the Excel file imported I have the message that the file is in use. I think that the Excel connection manager of the package doesn't release the Excel resourse but this is only a guess.. Do am I right If yes how can I release the resource Thank you very much Marina! Have a look in Task Manager and see if there is a process called dtexec.exe or dtsdebughost.exe running after execution. If so its possible that the package i ...Show All

• Norbert.Bender Simulating triggers on SQL Server Mobile

  Hi, Can anybody let me know if there are ways to programatically track changes made to a SQL SERVER CE table I am writing a db monitoring tool on SQL server CE which should track any changes made to the table.(Insert update and delete) We could have done this using triggers on Sql Server 2005. Since triggers are not supported on SQL Server CE, are there any alternate ways to achieve this functionality Regards, Ananth thanks a lot for the link!! You can track changes to a database by using a few techniques. I have used a few on my own products and they involve adding a uniquly indexed GUID column to the tracked tables and adding a tombstone table to the d ...Show All

• Karan M G Date format - Parameter/Field

  Hi, I have some difficulties to format a Date value in my reporting service. As you know you can use this kind of expression: =DateTime.Parse(Parameters!ReportingDate.Value).ToString("dd/MM/yyyy") But it does not work, and when I just want to use the format property of the textbox content such as " dd/MM/yyyy ", it displays "dd/MM/yyyy", not the real formatted data, this property works for " =Today() " but not for parameters and fields. What is the diffrence Have you an idea to format a Parameter/Field of Date type such as dd/MM/yyyy Many thanks! Vin, You can make your parameter of data type DateTime, this would eliminate the need to pars ...Show All

• kimo my script not working when the name of a DB has - (the dash character)

  Hi, this script uses MSforEachDB to check all the SPs in all the databases and look for a keyword LockCookie . The script runs well except when there is a database with a dash - in ots name. ie: When in the script is replaced by a database whose name contains a dash - the dash and the rest of the database name after the dash is ignored. And I get the message for example: Could not locate entry in sysdatabases for database 'SharePoint_AdminContent_f5c0f71f'. No entry found with that name. Make sure that the name is entered correctly. Here is the script: exec sp_MSforeachDB ' use select ''LockCookie'' as searchedTxt, o.name AS ProcName ,Len(SubString(object_definition(o.object_id),1, PatIndex(''%LockCookie%'', object_definitio ...Show All

• su45937 Registration

  I have a client that is running SQL 2005 Standard edition and they purchased 10 more Cal's, do I have to enter new registration keys, and if so where do you enter them Thanks in advance. Joe No, you don't have to enter additional reg keys. Thank you ...Show All

• GirishUmadi How to detach replication dbs?

  There are two databases on two web servers, db01 is on server01, db01_replica is on server02, db02 is on server02, db02_replica is on server01. db01 and db02 are both for one system. Each time after doing performance test, I have to recover databses. I copy the data files in a folder, try to use detach and attach to recover databases. But with two replication dbs, I don't know how to do it. The replication db should also be recovered. The situation is: my project is partitioned in two db servers, which all use SQL Server 2005. db01 is on server01 and has replication in server02, db02 is on server02 and has replication in server01. Each time there is a new build of the project, I have to do performance test for it. Unlucki ...Show All

• KitGreen Update SubQuery(two tables), pls advice wats wrong with the query. 1 hole day i spent still cant figure

  Table A, Table B. need to update table A balance field from table b sum of amount UPDATE CUSTOMERS SET BALANCE =( SELECT SUM ( AMOUNT ) FROM PAYMENT , CUSTOMERS WHERE CUSTOMERS . ID = PAYMENT . ID GROUP BY PAYMENT . ID ) Msg 512, Level 16, State 1, Line 25 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The statement has been terminated. Stephen: If you are trying to update multiple records in the CUSTOMERS table based on SUM (AMOUNT) in the PAYMENTS table then you might try something like: UPDATE CUSTOMERS SET BALANCE = amount_sum from customers a inner join ...Show All

• DeamonX Why am I getting 0 results???

  Very odd... my NOT IN is not working: --------- create table tbl1 ( region varchar(10) NOT NULL, district varchar(10) NOT NULL ) INSERT INTO tbl1 VALUES('000','AB1') INSERT INTO tbl1 VALUES('001','AB2') INSERT INTO tbl1 VALUES('001','111') INSERT INTO tbl1 VALUES('002','111') create table tbl2 ( region char(5) NULL, district char(7) NULL ) INSERT INTO tbl2 VALUES('xxx','121') INSERT INTO tbl2 VALUES('yyy','141') ------------ select * from tbl2 where CONVERT(varchar(10),LTRIM(RTRIM(district))) not in (select distinct district from tbl1) From the example, the results should give me everything from 'tbl2'. I'm converting on the fly, and it still doesn't work. Can anyone help Thanks ...Show All

• nhaas reading pdf files with SSIS 2005

  hello to everyone, i would like to ask u if you know how can i import pdf files in sql server integration services 2005 does anyone have a script thank u Do you just want to import the PDF file into a BLOB, Image or Varbinary(Max) column in SQL If so, you can use the Import column transform to read a directory and suck them into SQL or another RDBMS. To push them out of the DB, use the Export column transform. Wrting PDF files with SSIS 2005 may have been a better subject line. How about reporting services, it is there in the box at no extra cost, and can produce PDF files. PDFs after all are presentation layer, so SSIS isn't really the ideal place for that. kats wrote: wh ...Show All