Answer Questions

• henrybhavsar Unable to send MAil Alert using DatabaseMail

  Our configuration : SQL Server 2005 June CTP Enterprise Edition version : 9.00.1187.07 OS : Windows 2003   The Problem: After configuring Database Mail account and profile, maintenance plan or job generated with the maintenance plan Wizard is unable to send mail.   The SQL Agent error log contains those messages pointing on a bad profile name.   Error Messages [264] An attempt was made to send an email when no email session has be ...Show All

• lx_aka_alex Comparative training performance

  Recently I started evaluating and studying SQLServer2005 Datamining capabilities, I must say that I like the simplified integration between the database and data mining world. I was looking for any study on comparative model training performance between competitive products (SAS etc) and SQLServer2005 datamining algorithms. Thanks Rajeev Gupta We don't have any comparative studies (for many reasons), these kind of studies wo ...Show All

• Larry OBrien Use SMO with Sql 2000

  Hi can anyone tell me if SMO can be used with Sql 2000 I'm writing an app that is compatible with Sql 2000, but I also want to include Sql Express for offline scenarios. Thanks Graham Yes you will be able to use it with SQL Server 2000. See http://blogs.msdn.com/mwories/articles/dmofaq.aspx  as well. ...Show All

• Tim Haines Triggers and information through serial port!!!

  Hi to all, i have a trigger in sql server 2000 and i need to send some information through the serial port, i have an asp that do that, but i need to know how to link the trigger and the asp or the trigger and other component so i can send the data through the port, Thanks to all.... Regards... visit www.clubcorsachiwas.com.mx   The passion for the Tuning! You are not in the correct forum.  First this is a SQL Server 2005 ...Show All

• jezekjkr XML data sources in SSRS 2005

  I have a reports that are trying to read data from a public web service. 1) I couldn't get the report datasource to read the web service (it returns an XML document). I had the asmx URL in the data source and used the <Query><SoapAcition> in the dataset. 2) So I wrote an aspx page that writes the XML. So that it will write a secured, dynamic, page with text XML data. I got it to work once, but is not consistant. Now it give ...Show All

• Ray.B Commercial Application using MSDE or SQL Server 2005 Express

  Hi, I'm currently developing a commercial application in VS2005 that will catalogue hobbyist type data such as Music and Movies and I am considering using SQL Server 2005 Express for the client database. My question is how popular is MSDE and/or SQL Server 2005 Express in commercial software products I can't think of any application that I could buy off the shelf that uses the light-weight version of SQL Server whether that be MSDE or SQL S ...Show All

• David Dilworth Textbox spanning across columns

  Is there a way to make a longer message in a textbox span across several columns on a footer line similar to the Colspan in an HTML Table In report designer, if you select multiple table cells horizontally and right-click, you should have the option to "merge cells". -- Robert ...Show All

• Anders Dalvander Matrix column visibility

  Hello, I have one column group and three static columns. I'd like to control static column visibility property depending on a field value. I.e. Hidden: =Fields!GroupId<>5. But I'm not able to find visibility property in column object. Neither in properties explorer nor RDL documentation. I'm only able to set hidden property in textbox objects. I have RS 2005. Thank you for any idea. Jirka Nouza ...Show All

• Geoff Dean Can SSIS package be run from WebService?

  Dear, Can SSIS package be run from WebService P.S. SSIS package and Webservice are located in the same computer. Thanks much! Not sure why you aren;t able to see the following text in that URL Roles SSIS adds three new roles that affect the way you run packages in SQL Server Agent and access packages stored in SQL Server. The db_dtsoperator role is the most limited new role. Users in this ...Show All

• Mr.Mel Using images in database

  We are building mostly read Real estate web site where there are many pictures what users will see from their browers.We have come up with 3 ideas.But we need help,is there any alternatives to these. 1.Put them into the database we are using . 2.Seperate the images to another instance and record images to that instance . 3.Use the filesytem. What is the best way of storing and retreving images for a concurrent web application ...Show All

• toargul ISSCEStatusReporting interface - replication progress in C++

  Hi, I'm not sure if my previous post was in the right forum so, please accept my apologies if I'm doing "double" post. I have created 3 years ago C++ class wrapper -MFC like- for SQL Server CE 2.0. I migrated those two months ago to support SQL Mobile. Today, I would like to get notifications from Replication progression but I couldn't figure how to override ISSCEStatusReporting interface. If anyone could give hint or sam ...Show All

• Hema Chaudhry Pivot Issues

  Hello, So here's what I have in a table: CoNo RentalIncome OtherIncome Insurance 1111 200 500 100 2222 300 400 50 3333 100 600 200 .... ... ... ... ...And here's what I need to do: CoNo 1111 2222 3333 .... RentalIncome 200 300 100 ... OtherIncome 500 400 600 ... Insurance 100 600 200 ... I've played with a fe ...Show All

• MarkShep SQL 2005 SP1 installation hangs

  I am trying to install SQL 2005 SP1 on a Windows 2000 Server SP4 platform. I have repeatedly tried this, and have trashed and re-built the platform all to no avail. I keep getting the same problem. The installation hangs, using 0 CPU apparently after successfully extracting the files to disk. It leaves the HOTFIX.EXE running, and cancelling it ends the process. The HOTFIX.LOG looks like this: 5/31/2006 10:05:03.185 ======================== ...Show All

• Dancefire Export - Changing Text in Drop Down

  Is there any way to change the text of the export drop down (ex: change "Acrobat (PDF)" file to just say "PDF" I didn't see anything in the rsreportserver.config file in the Extension node. Thanks. Thats not possible, the names of the extensions are defined in the particular assemblies.. Actually it is possible to override the names in the dropdown ...Show All

• Pitipied SQL Server 2005 Newsgroup

  Could somebody please tell me where the SQL Server 2005 newsgroup has gone i can no longer find it anywhere and had a few posts going. Thanks in advance. news://msnews.microsoft.com/microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap with web access/view at: http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx dg=microsoft.public.sq ...Show All