Answer Questions

• spawninc SQL 2005, multiple instances - what about ports?

  When multiple instances of SQL 2005 are installed on a cluster or standalone server, is it best to have each instance configured to listen on a different port or will one port for all do We don't use port 1433 and the port we do use is blocked at the firewall. I'd like to standardize on one port for all instances but I'm not sure of the ramifications. Any thoughts Thanks. We are a very large shop. Over 100 ...Show All

• osofuchi Merge Replication - native exception

  Hi! Here are the details: - Merge replication is set up between SQL Server 2000 SP3 <-> SQL CE clients - It is expected for the system to have 100-150 PDA users - About 80-90 tables are being replicated. About half of the tables are for documents  that PDA users create. These tables have to be filtered by SUSER_SNAME() to minimize data transfered and not to allow users to see each others documents. For filtering we us ...Show All

• drourke Query Log File and Usage Based Optimization

  Hi I have successfully created a QueryLog.trc file but when I enter the Usage Based Optimization wizard it complains that I have not configured the server parameter QueryLog\ QueryLogConnectionString. Does the wizard support the use of a file rather than a table Im using the RTM version. Cheers The Usage Based Optimization wizard expects to find a SQL Server table. Here is whitepaper on how to setup a Query Log: http://www.m ...Show All

• hooosiers123 How to integrate many authorization database in one RS

  I can‘t figure the best way to do this: I have many web applications with their own authorisation mechanism. I have one Report Server containing all reports of all my applications. I want to extension Reporting Services security to integrate our own authorization. The problem is: Inside the security extension, how to know which security to use (the one for the web application 1 or the one for the web application 2) Imagine I have the same use ...Show All

• moronikos Unhelpful error message

  I've just got the following error message from a script component: "The value is too large to fit in the column data area of the buffer". How difficult would it be to get the name of the column in question. Seeing as its metadata of the component surely it can't be that difficult I'm making an assumption here I admit! -Jamie Jamie, Yep, not a very good error. This one sounds like it could be easily improved, but that may be deceiving. W ...Show All

• Unknown Name Sending one message to multiple consumers

  Hi Remus What if I need multiple clients to read (RECEIVE) the same message Would it be possible Thanks No. A message can only be received once. Normally the first RECEIVE statement removes it from the queue, so no other RECEIVE can find the same message. Also there is no way for the clients to specify the message to be received. With a WHERE clause the RECEIVE statement at most can restrict ...Show All

• PChandra Problem conecting to the same DB from two applications

  Hello, I'm new to VB and SQL server. I have a windows forms application and a Web application that need to connect to the same database (Named WebCenter). But when I try to connect to it from the Web app while running the windows forms app this error message apears: Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\WebCenter_Data.MDF". Operating system error 32: "32(The process has n ...Show All

• Jonathan Fife "Launch Database Mirroring Monitor" is not an option

  Good morning all... I would like use the "Database Mirroring Monitor" to track what's going on. All three of my servers have SQL Server 2005 x64 edition installed with SP1. Server A is mirroring to Server C Server B is mirroring to Server C Following the instructions at http://msdn2.microsoft.com/en-us/library/ms365786(d=ide).aspx : On Server A and C, "Launch Database Mirroring Monitor" appears. On Server ...Show All

• Ebbe Acces to a file that is locked by another process

  I am writing a package to process perfmon logs. The issue I have come across is that the perfmon process holds onto the log file and SSIS fails because it wants to exclusive read access. Is there any way of getting SSIS to not take an exclusive read on the file. I can read the file in notepad fine but not SSIS. check by changing the isolation level of package by default its serialiazable ...Show All

• Andrew Niemann Formatting part of a text box

  hey all, does anyone know of a way to format part of a text box in sql reporting services 2005 i am creating a form letter and need to concatenate static text with a column and need just the column value to be bold. like this: "This letter is confirmation that Acme Agency has been chosen..." my expression to build this is: ="This letter is confirmation that " + Fields!agency_name.Value + " has been chosen... ...Show All

• Spartan "No Mapping between Account Names and Security Ids was done".

  I am trying to process a dimension. After four attributes are processed successfully, it gives an error saying "No Mapping between Account Names and Security Ids was done". What could be the possible reason I found it myself. The Data source shall be registered with Windows Authentication. ...Show All

• Colin Meek - Microsoft How to change a field's type?

  Hi, How could I change the field type through T-SQL I have tried Using the ALTER:          ALTER TABLE tblName ALTER COLUMN myID int It didn't work... And also, how could you rename a fieldname cheers, Paul June A. Domag Hi, Sad to say, it didn't work. I searched the BOL of SQLServerCE and the IDENTITY_INSERT switch isn't available. Guess, I'll have to find other means to solve this proble ...Show All

• Sampy Converting Integer values to datetimes

  We have inherited an appointments database that has a table tblAppointments Within this table there are 2 fields, ApptFrom & ApptTo, these are the appointment start & finish times. My problem is, the values in these fields are held as integers ranging from 0 - 288. I have worked out the scale for the integers, it is based on a 24hr clock with each segment representing 5mins Eg: 0 = 0:00 12 = 1.00 24 = 2.00 36 = 3.00 ...Show All

• Syed ghani Create New SQL Server Mobile Edition Database

  Hi, I follow the instruction to install SQL Server 2005 Mobile Edition, but when I try to change the Data Source to add a new connection, I don't find "Create New SQL Server Mobile Edition Database". Does anyone know how to fix this Thanks Paolo Giorgio In the early beta days of " Microsoft SQL Server 2005 Mobile [ENU] Developer Tools" was registered as "Microsoft SQL Server 2005 Mobile [ENU] B ...Show All

• Robert C. Bennett Generic staging design of data warehouse

  I have a question about staging design using SSIS. Has anyone come up with an ETL design that would read table names from a generic table and dynamically create the ETL to stage the table. 1. Have a generic table which would have table name and description and whatever else that was required. 2. Have a master ETL that would enumerate through the table and stage all the table names found in the generic table. This way I wouldn't have to ...Show All