Answer Questions

• Andrea Williams Display Boolean parameter LABELS

  I tried to put a boolean parameter on my report with values (True, False) and Labels (Yes, No). On Visual Studio it displays the labels, but when exported on the Report Server it diplays the values (True, False). Is there a way to tell Reporting Services 2000 to display the labels of boolean parameters instead of the values Hi Remi, I had the same problem in Reporting Services 2005, where in the report preview in Visual Studio the par ...Show All

• srishu Wildcard Searches

  I have a number of functions that require the input of parameters in order to ultimatly create a report under Reporting Services by making use of a Stored Procedure. All the functions etc work as does the stored procedure, but it only works if I specify data that I know exists e.g. DECLARE @return_value int EXEC @return_value = [dbo] . [spWTRalldatareportsummary] @dt_src_date = N '04/28/2006' , @chr_div = N 'NE' , @v ...Show All

• Eric Feng table or view doesn't exist

  Hello I am trying to run a select statement in Java against SQL Server 2K. But I keep getting an error saying that the table doesn't exist. Is this a problem with my SQL statement select * from counting I also tried select * from dbo.counting my connection url is jdbc:microsoft:sqlserver://IS-0081526:1433;databaseName=bail; I can run these queries from Query analyzer I am able to run them with the same account and login. ...Show All

• R3N3G4D3 SSMS Express: Creating Parent-Child Table via LEFT OUTER JOIN - Error Message 156

  Hi all, I got an error message 156, when I executed the following code: ////--SQLQueryParent&Child.sql---//////// Use newDB GO ----Creating dbo.Person as a Parent Table---- CREATE TABLE dbo . Person ( PersonID int PRIMARY KEY NOT NULL, FirstName varchar ( 25 ) NOT NULL, LastName varchar ( 25 ) NOT NULL, City varchar ( 25 ) NOT NULL, State varchar ( 25 ) NOT NULL, Ph ...Show All

• Dileep Agarwal Error in Documentation (.NET stored procedures in sql express and Workgroup)

  Hello All, I believe that there is an error in the documentation at this link http://msdn2.microsoft.com/en-us/library/ms143761.aspx  It says that .NET stored procedures feature is not supported by sql server 2005 express and workgroup. While this link: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx  says it is supported. Ahmed I can't find anything on the second link that says ...Show All

• VaishaliAmonkar Linked Server to Informix

  I have set up linked servers before but not with INFORMIX. I was wondering what criteria goes into the product name and data source fields in the new linked server window when connecting to an INFORMIX server. I have SQL Server 2005 installed on my machine and have also installed the informix drivers on my machine. Has anyone had to do this before Any help is appreciated. Thanks, Matt Not sure if you go ...Show All

• error maker SQL Server

  I would like to know how to upload files to my SQL Server With a hosted website the usual way I do it is to use FTP. Would this work for you Allan "Visual Basic Nov.@discussions.microsoft.com" wrote in message news:f9e6cc0c-b987-460b-a59e-e00f54cdd902@discussions.microsoft.com: > I would like to know how to upload files to my SQL Server 1.       Make sure yo ...Show All

• Xanthius ODBC connection failing on 64 version of Windows 2003 server

  I have an application that talks to a SQL backend using an ODBC DSN connection. It works fine when running on a 32bit machine but fails in the 64bit environment. The DSN is setup properly on the 64bit box and the Test Connection returns sucess. However when my application tries to use the DSN to connect to the database I recieve the following error. IM002 - Data source name not found and no default driver specified. The data source nam ...Show All

• shermaine Problem opening UDF

  Hey, I am using SQL Server 2005 client tools on a 2000 server. Everything works fine except ................ WHen I try to open (Modify) a user defined function, an error msg appears saying "QuotedIdentifier property not available for the function" Anyone having same problem and found solution Thanks a lot! This sounds like the following bug, which is sched ...Show All

• sixmileal How do I get the script to create a table & all the Indexes

  In SS2K I could go to task and it would script the table, indexes and any other script that was set for that table. How do I do it with 2005 Thanks You might want to check out this tool:   http://www.sqlteam.com/publish/scriptio/   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     < VonSch@discussions.mi ...Show All

• Rodrigo Landaeta full text index is exist or not

  Hi, How to find full text index is exist in the table or not like that how to find normal index is exist in the table or not Thanks in adv. ---> Murali <---- Please refer to Books Online "Obtaining Full-Text Property Values using Transact-SQL Functions" http://msdn2.microsoft.com/ms142579.aspx In your case you should use OBJECTPROPERTY function and TableHasActiveFulltextIndex property. OBJECTPROPERTY(table_id, ' ...Show All

• Jeff Micro Problem with attaching database

  I try to attach a db by running the following command: EXEC sp_attach_single_file_db @dbname = 'test' , @physname = 'C:\Documents and Settings\renee.wilson\My Documents\PD DD 2.nvp' But I get the following error message: File activation failure. The physical file name "C:\Documents and Settings\renee.wilson\My Documents\PD DD 2_log.LDF" may be incorrect. The log cannot be rebuilt because the database was no ...Show All

• Mike Mathis Connect to Remote Analysis Server

  Hi, How do I connect to a remote Analysis Server using SQL management studio on my local machine. Thanks in advance.. What is the name of the physical machine you want to connect to Also when it was installed was the instance given a name If the instance was not given a name then you can just put the machine name in the server edit control, if it has a name then it should be servername\instancename in t ...Show All

• Earl Bonovich The connection manager 'OLEDB' is not properly installed on this computer

  Please help someone from MSFT! I've just finished installing the Sep CTP on my laptop.  I previously had the April CTP and June CTP.  I followed the instructions for removing a previous installation of SQL 2005. Now, when I try to create an SSIS package, I get a message that says: TITLE: Microsoft Visual Studio ------------------------------ The new connection manager could not be created. ------------------------------ ADDITIONAL IN ...Show All

• never_again Information/ErrorCode from FireInformation/Error

  Hi, Very low priority this one... Is there a "free" number range that we should use for the InformationCode/ErrorCode parameter to the FireInformation/FireError methods Currently I just use 1 and -1 respectively. On a similar note...I remember someone from MS (might have been Matt) once saying that a list of all the rror codes would be published at some point. Is this still the plan and if so, where will it be Thanks Jamie It's my unders ...Show All