Answer Questions

• jack in box Spelling error

  BackupPhisycalDestinationType Found this on the Backup DataBase Task property page. Report it here: http://lab.msdn.microsoft.com/productfeedback/default.aspx if you feel it is important. -Jamie ...Show All

• Juan Pane Indirect config through SQL table ?

  Hi, How would you set up an environment variable to do indirect config from a SQL db table I couldn't find any clues in the BOL or on the net. Basically, we have one variable but it must contain three things: 1)Connection to DB 2) table name 3) filter (config name in table). Right What is the syntax to specify these Thanks I posted the smae question in a reply to an old thread. Sorry. Please use the following format: connection-mana ...Show All

• Lifeng Remote Access To Report Manager Failed.

  Hi All, I'm using Express Edition with Advanced Features. All working fine except I'm not able to access the Report Manager from client pc. When I type http://xxx/Reports$SQLExpress in the machine where the Express Edition with Advanced Features is install, I can get to the home page of the Report Manager (xxx being the machine name). However, if I type the same address in the client pc, I got the "Page cannot be displayed" error. ...Show All

• Jim CaJacob How to Config Virtual Directory for HTTP Access to Achieve XML Template Query in SQL Server2005??

  Hi, I have built a system with xml template query using SQL Server2000. Now ,I want to update it with SQL Server2005. The problem is how to config the virtual directory In SQL 2005 the SQLXML ISAPI virtual directories are no longer being shipped. Instead we have things like SOAP endpoints and ASP.Net that can provide you HTTP access to your data. If these do not work for you, your SQL 2000 virtual dir ...Show All

• guyfe Removing duplicates

  Hi all,       I have a table like        UserNo        UserName          1               Ajit          2              & ...Show All

• Dan Suceava Does Full-text extract searchable metadata (Properties) from documents?

  When I create a full-text index on a word document for example. I want it to load metadata (property) fields that can be search independently from the word list. For example, queries like: cat and dog and (Author <contains> 'Mary Jones') This quarantees that Mary Jones only occurs in the word docs author metadata field and not within the document itself. The property fields for an email document would be: to, from, cc, bcc ...Show All

• bas31 Adding custom property to custom component

  What I want to accomplish is that at design time the designer can enter a value for some custom property on my custom task and that this value is accessed at executing time. I thought this would involve adding a IDTSCustomProperty to the ComponentMetaData.CustomPropertyCollection and the right place to do this to mee seemed be in the ProvideComponentProperties() method: IDTSCustomProperty90  property = ComponentMetaData.CustomPropert ...Show All

• amitatbangalore How can we deal with unknown member in cubes for data mining?

  Hi, all here, I currently have a question about unknown member in cubes (as we know, there is always an additional member called unknown in an OLAP dimension)for data mining. I mean is there any way for us to deal with unknown member in cubes when mining cubes Thanks a lot in advance for any guidance and help. The unknown member maps to the missing state when you build a mining structure based on an OLAP cube and this is usually th ...Show All

• _daz No tool to upgrade Access databases

  sql server 2k has a tool to upgrade Access databases.  I can't find any similar tool in sql server 2005.  Am I missing something dennist Do you mean the Import/Export Wizard This will copy some of the schema and the data from an Access Database. Right click on a Database in SSMS and select import. If you mean the Access Upsizing wizard this is part of Access and we are still closing those plans. -Eua ...Show All

• Ira at AIB Performance of multiple charts on a report (RenderStream issue with RS2000)

  I have a 'questionnaire analysis' report. The report consists of approx 25-30 questions and each question has a bar chart next to it to show the average score out of five for each multiple choice answer within a question. The report ends up containing 25-30 bar graphs all contained within a List control. The report performance is acceptable using URL access but is exceptionally slow (well over 1 minute) when using SOAP access. The perfor ...Show All

• StuGautz Advice on a database Replication

  Hi, I.m trying to find the best practice for my solution. This is the situation. My application has two databases and 2 client interface. One with a windows forms having a database (sql server 2000) running in an office (on a static IP but on a slow connection). the second one is an web application running on the net with an online database. Both these databases have to have same information. Users can add records to both databases ...Show All

• macv3x Retrieve info (alerts, Custom Error Messages etc) from off line master and msdb databases

  Hi, Well, we have spent a happy weekend building a new server as our old one had a terminal hardware crash, and repeatedly rebooted. All OK as the user databases were on a SAN, so we just pointed the new server at the san, attached the user DBs and off we went.... We also use alerts extensively to run jobs. We are now in the situation where the old server will come up, but SQL server will not run as the system DBs are on the SAN. I need to ...Show All

• Prashant Utekar Unable to restore SQL Server 2005 Beta 2 databases in SS 2005 Final

  I'm in trouble. We moved to MS SQL Server 2005 Final release after using Beta 2 release. I switched the installations. When I tried to restore the database backups, I got following message. System.Data.SqlClient.SqlError: The database was backed up on a server running version 9.00.0852. That version is incompatible with this server, which is running version 9.00.1399. Either restore the database on a server that supports the backup, or use a b ...Show All

• madhusrp Query/View Question

  I am trying to create a view that returns data from three tables and can't seem to get it to return the data that I want. I am no SQL expert, so hopefully someone can give me some insight into what I need to do. The tables are basically set up like this: TABLE 1 PrimaryKey Textfield1 Textfield2 Textfield3 TABLE 2 PrimaryKe ...Show All

• MichaelP_Oxy Data types Differences

  I've recently installed a new server for an aplication we used at work. In the old server we had SQL Server 2000; for the new one we bought SQL Server 2005. Everything is ok till now, the aplication has worked ok; all ok except one thing. I have a report in excel, all the format of the report is saved on one table, that table has fields bit, smallint, tinyint, varchar. Now if I try to make the report all the information is ok but the format i ...Show All