Answer Questions

• SoftwareAndWhy Open Navigation Link in a new window

  I have a report with a hyperlink. When I go to the navigation tab, it does not give me any options to open the link in a new window. I have a link to show help and I do not want the user to actually move away from the reports Any ideas This is such a simple thing..I wonder how MS misses this Try this: ="java script:void(window.open('https://www.mysite.com/pdf/" & Fields!SurveyReportNo.Value & ".pdf','_blank') ...Show All

• AxelM Attach an aspnet or sql2005 database on a sql2000 server

  Hello I want to attach an ASPNETDB database (generated by the asp.net login wizard system), which is a sql2005 .mdf database I think, to our SQL2000 server. I tried to attach the file directly ; then to attach it to a sql2005 express server, "turning it" into a sql2000 database via the properties, then make a backup, then restore the backup on the 2000 server ; nothing worked out ! One of the method I tried (I don't remember which one) ...Show All

• Ben Alden AS/400 to SQL Server 2000 Replication

  Any suggestions on how to replicate from AS/400 to SQL Server 2000 Data is stored on a AS/400, but applications use a SQL Server 2000 DB. Currently, DTS packages drop the SQL DB, rebuild the tables from a script, copy the data, and then rebuild the indexes as a nightly batch job. Is there a better way to do this Also is there a clean way to replicate daily transactions as well Hi Replicating from AS400 ...Show All

• Per Dunberg Modern_Spanish Vs Latin1_General

  Could anyone tell me what's the difference between a Latin1_General CI AS and a Modern_Spanish CI AS collation I know both use the 1252 character set and thus it confuses me about what could be the difference between them. Thanks a lot ! Best regards, Alan I'm afraid I don't. Some of the rules are fairly obscure, also, such as when two-character combinations are considered a single letter (Hungarian Sz, for ...Show All

• rrrico74 TRUNCATION OR CODE PAGE

  I have a very nasty error on ssis, Text was truncated or one or more characters had no match in the target code page This can not be truncation because the field is empty, the second thing is that when i read the file it reads 62000 odd rows but there are 64000 rows. if i just read the entire file and write the entire file in a scipt i loose 13 rows I have tried different code pages and non have worked. Does anyone have an idea ...Show All

• cybercrypt13 Maximum number of partitions in AS2005

  Hi, Does AS 2005 have a limit to the number of partitions it can support I am sure some one out there must have asked this before, but I just can't seem to be able to find an answer in the docs or online. Regards, Alex Dave, Thanks a lot. Just wondering when the number of partitions grows to this level does it affect cube processing in any way Have you had a situation in Project REAL th ...Show All

• Dont want to smalldatetime type behavior

  Hello, i've noticed this smalldatetime type behavior: Passed value seconds are not truncated, but rounded. Could you be so kind and help me change this behavior to truncation, please Thank you. This is the default behavior. Accuracy of smalldatetime is 1 minute so if the seconds part is less than 29.998 seconds it will get rounded down to the nearest minute and greater than 29.998 seconds get round ...Show All

• Sarkar help with a max length table constraint

  Table File_Paths (physical system file paths) The columns represent parts of the path. How can I set up a constraint that the total concatenated length of all the columns within a row is less than 260 chars Thanks Right on target. Thanks For some reason, when it gets saved a bunch of unnecessary parentheses both square and round get added. The square brackets help if there are white space ...Show All

• Yurgen unable to install SQL server CE Server tool

  I am trying to install sql2kdesksp3/sqlce20sql2ksp4 on windows 2000 server with SP4 having MSDE 2000(SQL2000.MSDE-KB884525-SP4-x86-ENU) installed. I am getting compatibilty error message("SQL Server CE Server tools is compatible only with SQL Server 2000 SP1 and higher."). I am not sure if I have selected the right version of SQL CE Server tool. If not kindly advice on which version of SQL CE Server tool will be compatible with MSDE. I have ...Show All

• Igor Sukhov HELP plz solve some Queries

  Please Use SQL SERVER 2000 Query 1. REMAINING Is it effecient way to use @Somevariable in the where clause Query 2.. DONE . thanx Jens Using theNorthwind WHY THE RESULTS OF THESE 2 queries vary . declare @title1 varchar(20) set @title1='A' SELECT EmployeeID FROM Employees where @title1='A' SELECT EmployeeID FROM Employees REMARK: Both queries are giving all the EmployeedID but they Differ in their order ...Show All

• jhallen How to truncate the log file

  How do I truncate the log file using TSQL   My client's log file is 44 gig and there isn't enough HD space.  Thanks I had the exact same problem as above and this worked for me....thanks Darren I have found that the following will work in the "out of disk space" scenario: BACKUP LOG database_name WITH TRUNCATE_ONLY Then, after you run that comm ...Show All

• groovieblonde Do I need SSIS to process cube?

  There is a function called "proactive caching" in Analysis services. It can: ----Automatic synchronization with the relational database ----No more explicit "cube processing   But I cannot have the latest data in the cube even I set the proactive mode as "real time" Do I need SSIS to process cube in this case   Following is the procedures I have done: 1. test the data   1.1  use the bi dev studio to browser the cube, ...Show All

• GMG_NetCoder error number 1612

  I'm doing a reinstall of SQL 2005 Standard Edition but I get this cryptic error message in the installation log file when it tries to install Integration Services or Notification Services. How do I resolve this I've spent countless hours un-installing and re-installing the product. I looked at the log file and the message says 'The installation source for this product is not available. Verify that the source ex ...Show All

• kpthekiller Parallel activations with GET CONV GROUP

  Hey guys. I'll try to keep this as short as possible. Was testing out some thresholds with a simple service broker application and ran into something interesting that I'm trying to find a workaround to. I setup a simple service on a single instance, and am transmitting messages to/from the same instance. I assigned a procedure to be activated on the queue, with a max of 20 parallel activations. The procedure originally was reading messages ...Show All

• Jeff Knutson Where can I download SQLServer 2005 Express SP1

  I have followed the link to download SP1 of SQLServer 2005 Express Edition, but, on that page nowhere it is mentioned that downloads offered are of SP1, it simply says that SQLServer 2005 Express edition. What is the correct link and am I really on the correct page of SP1 I guess you were right, see the instructions to update your SQL Server Express installation under point 3.1 on this link HTH, Jens ...Show All