Answer Questions

• ruju Concatenating 2 text boxes

  Hi, How do we concate a normal text with an underlined text eg: I would like to concate : textbox1 = my email address: and textbox2 = xxx@hotmail.com into a new textbox3. expected result: textbox3 : my email address: xxx@hotmail.com Really appreciate your help. Thanks You will not be able to do this with a single textxox, because we do not currently support rich text (mixing fonts and font styles) within t ...Show All

• MHenke sql server management studio nov ctp

  I have vs2005 prof. installed along with sql express RTM I installed management studio nov ctp when I try to launch it, nothing happens any Ideas Thanks deleting the key worked for me too Thanks Me Again. Deleteing the Key on my work machine worked. Maybe it was left behind by one of the SQL Express Beta Programs, as I had many of them installed on my machine over the last year. Anyway, it's working now :-) ...Show All

• zdfowler Print Button

  Print button is disabled for some users. Don't know why it is doing so Works fine for most of the users in the same group. Any help is much appreciated. SQL SERVER Reporting Services 2000 Win XP Also check the RSPRINTCLIENT control in the C:\WINDOWS\Downloaded Program Files folder. I they ran on the beta then this dll could be very old. It doesn't seem to get updated when the server does. You can remove it and RS will downlo ...Show All

• Jayaram Ganapathy MsiInstaller Errors: SQL 2005 Express with Advanced Features

  My machine environment is as follows: - Windows Server 2003 Standard with SP1 - IIS 6.0 with some "classic ASP" applications running under it (not ASP.NET) - SQL Server 2000 Client (Enterprise Manager, Query Analyzer etc) - .NET Framework Runtime 1.1 & 2.0 - Visual Studio.NET 2003 & 2005 I've never installed (or even trusted) any beta/CTP version of either Visual Studio or SQL 2005 (or any other MS trial products for that matt ...Show All

• VaniK Recover after a Raid-5 disc fault

  Hi, My raid-5 server failed because one disc, some folders and files are lost, but I have recoverd whit some software for the propuse. I have reinstaled the SQL server and attached the database, but when I try to open the tables I recieve a error message saying : internal consisty error... somethihg like this. How can a restore the databases OK, several things here. A failure of one disk in a RAID-5 set shouldn't cause any da ...Show All

• zhangg3 Getting Started walkthroughs

  Hi all, I was wondering if anyone knew of any good walkthroughs to help me get started with SQL 2005, SSIS in particular. I have checked through the newsgroups and Blogs but they all go way to far above myhead. I found a Teched 05 one which was good, but cant seem to find any more Does anyone know of a place for begineers to go Or even any books I could get. Im not trying to do anything complicted, all I want to do is cre ...Show All

• Joel914 MSSQL Server 2005 Replication Step by Step

  MSSQL Server 2005 Replication Step by Step http://blog.csdn.net/longrujun/archive/2006/06/09/783357.aspx ...Show All

• Mark.Stockton Creating a double entry book keeping system

  Can anyone please tell me how to create a basic double entry book keeping system database using SQL Server or Access. I need to know what tables amd fields I need to create, and what relationships need to be defined. I just need to know the db structure here. Also how should I go about designing the forms ( I use visual Basic 2005 Express and SQL Server 2005 Express, and Access 2002 ), the front end user interface for creating journal entries, h ...Show All

• Galit Attachement generated by xp_sendmail

  Hello folks, I am sending a email from sql server that consists of results of a query and that's working perfect. When I open the text file generated by xp_sendmail in notepad it's OK, but when I open it in MS Word or WordPad, I see garbage characters in form of squares added to the content. Those sqare are unicode spaces equivalent to Nchar(140) or Nchar(0020) in SQL. I tried to replace them using the replace function : declare @foo varchar(80 ...Show All

• Shok Money conversion

  Hi! When I write: 'SELECT Amount FROM tTransaktion' I get returnvalues such as '12000.0000'. Instead, I want it to return '12 000'. The Amount column is of datatype money. Is this possible! Thanks! If you need commas you can use this declare @value money set @value = 12000.00 select convert(varchar,@value,1) Denis the SQL Menace http://sqlservercode.blogspot.com/ ...Show All

• bmcneill0 Affecting performance?

  I have a table with 23 columns.  8 columns are not always filled by users and so valued to default.  Would this affect the overall performance of querying this table   Should I separate those 8 columns and link with a one-to-one relation Thanks From a database design point of view I would seperate them. Any idea ...Show All

• Sahil Malik SQL Server 2005 fails while installing on a cluster.

  I'm building an SQL Server 2005 cluster on a Windows 2003 cluster. Windows 2003 cluster and MSDTC service are all up and running properly. No problems there, but when I try to install SQL Server 2005 as a cluster service, it fails. The installation goes past the stage where it validates both the nodes and doesn't find any issue there, but when it tries to install fiels it fails. It fails on node 2. When I checked the scduled installer job it cre ...Show All

• SQL_DATA Unable to use Books Online search function

  I am unable to use the search feature in Books Online.  Every time I click the "Search" button, I get this error message: Package "Visual Studio Common IDE Package" failed to load Anyone have any ideas on what might be causing this error Hmm, this is strange. I know that you have already gone through an uninstall/repair/install cycle and I am sorry for the trouble it has caused. Is it possible to uninstal ...Show All

• FM52 "Prediction steps" has no effect for "Microsoft Time Series" algorithm

  I am using "Microsoft Time Series" algorithm.  When I view the charts under "Mining Model Viewer", I see only the predicted points of only one step.  When I change the "Prediction steps" value, the scale of the time axis extends, but the actual curve does not change at all (i.e. no points after one step).  I must be missing something rudimentary. Could anyone help Thanks, H Thanks! BTW, I am using real data, not ...Show All

• Chila sql2005:Cannot use SAVE TRANSACTION within a distributed transaction

  Error returned when trying to commit the transaction to a database that is a replication distributor. (sql2005 ctp16) the error I am seeing: Msg 627, Level 16, State 0, Procedure sp_MSmerge_altertable, Line 305 Cannot use SAVE TRANSACTION within a distributed transaction. Anyone encounter transaction problem with replication Thanks. Replication is not involved...sorry for posting here (I was just p ...Show All