Answer Questions

• db_guy Expression on hidden property

  I have param named Direction i would like to put on the hidden property of image this expression iif(Parameters!Direction.Value = "ascending" ,False ,True) But i've got error message .....my expression is not avalid value. why It’s like a said before... =iif(Parameters!Direction.Value = "ascending" ,False ,True) if everything's ok that should hide your image when the Parameters!Direction.Value is "ascending" and show it otherwise. Thanks, work grate :) Maybe Can you please write me the correct form you think it should be Hi, didn't you miss the "=" as in : ...Show All

• N3vik Not available in Object Explorer

  Im new to Sql Server CE and I am following the procedure in books online to create a new database. Through Sql Server Management Studio, I have version 9.00.2047, books online says to click connect through Object Explorer and then select Sql Server Compact Edition . I dont see this option. I see Sql Server Mobile . Is it the same thing or am I missing something Thanks, Jesse Thank you. SQL Server Mobile is the predecessor to SQL Server Compact Edition, ie version 3.0 and 3.1 To have the UI display "SQL Server Compact Edition", you must install SQL Server 2005 SP2. For more information on this, see the MS KB article: http://support.microsoft.com/ k ...Show All

• rulertbca EXEC in SQL Functions

  Hi, I need to pass a table name and id to a function and return a row count I need to use EXEC or SP_EXECUTESQL to run dynamic SQL It wont work in functions. Following is my function alter FUNCTION [dbo].[GetRowCount] (@TblName NVARCHAR(25) , @Itemid INT) RETURNS INT AS BEGIN DECLARE @RowCnt INT set @RowCnt = 0 DECLARE @Sqlstring nvarchar(2000) set @Sqlstring = 'SELECT @RowCnt = COUNT(*) FROM ['+ @TblName +'] WHERE Itemid = '+ convert(varchar(10),@Itemid) EXEC @Sqlstring RETURN @RowCnt END while executing this I get the following error .... "Only functions and extended stored procedures can be executed from within a function." and "Incorrect syntax near the keyword 'EXEC' " does anyone have any ideas of this Thanks ...Show All

• MikeBzz Upgrade - server 2000/sql server 2000 to Server 2003/ sql server 2005

  I am converting  about 50 databases from Windows 2000 and from SQL Server 2000  to a totally new 4 processor Server 2003 with SQL SErver 2005.  I used the Database Copy Wizard in SS2005 to do the transfer and I used the object method.  After making sure the databases were big enough to hold the new Masterdatabase everything went well... except none of the stored procedures from any of the 50 databases copied from SQL Server 2000 to SQL Server 2005.  What did I do wrong   And how do i fix it.  Also, even though I changed the default database, the wizard did not reflect the new SAN location for the Data and Log files.  I had to do each one manually. ...Show All

• DavidAWinter problems with web servces and data types

  Hello together, I am working on SQL Server 2005 and want SQL Server to provide to provide web services for a process management project. I was able to create a endpoint, but I the WSDL-File is very complex. There are much datatypes I do not need. Let me explain my situation and problems. 1. Providing web services For a first proof of concept I created a stored procedure which should be accessable through web serveices later on. I created the following stored procedure, which need to params and returns a list of stings (Names of Customers) set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo] . [GetCustomerView] @accountnum nvarchar ( 20 ), @dataareaid nvarchar ( 3 ) AS BEGIN SET NOCOUNT ON ...Show All

• moGun Incremental Processing does not work with WHERE clause

  I am trying to get incremental processing of a cube to work. Full processing works, but as soon as I add a WHERE clause, the query never seems to return any data during the processing no matter what options I choose. I run the exactly the same query directly against my database and I get ~ 30 million rows. I also tried pre-processing the affect dimension, (a date dimension) and still no incremental processing. I also get this beviour when I specify a where clause in any of my Named Queries. This is against an Oracle 10g Data Source. Is this a bug or am I missing something Ran the batch process XMLA as a query and got the following result: < return xmlns = " urn:schemas-microsoft- ...Show All

• MrBrilliant Transfer Database Task

  I am trying to run a transfer database task in IS. The tasks fails saying that a defined role already exists in current database. This occurs if I try a destination overwrite to an existing database and even if the database is not currently allocated with destination overwrite = false. Has anyone experienced these problems. I am just learning IS and have never experienced this type of problem with the old DTS version. The transfer database and transfer objects tasks appear to be full of bugs. I'm dealing with them right now. What I've discovered: Transfer Database does not transfer constraints, indexes, views... Transfer Objects only appears to work well on a clean / empty database (there are known is ...Show All

• Alistair4267 sp_executesql

  Hi There Is a table variable invalid for sp_executesql I am trying the following: SELECT @SQL = N 'WAITFOR (RECEIVE message_body, conversation_handle, message_type_name, message_sequence_number, conversation_group_id FROM ' + @callingQueue + ' INTO @msgTable WHERE conversation_group_id = ' + CAST ( @conversationGroup AS char ) + '), TIMEOUT 2000' EXEC sp_executesql @SQL , N '@msgTable TABLE output' , @msgTable out I get the following message: Msg 137, Level 15, State 2, Procedure CENTRAL_Queue_Processor, Line 92 Must declare the scalar variable "@msgTable". I have decalred the variable but it is a table variable, this leadds me to believe sp_execute sql only supports sca ...Show All

• heimdaloz COM objects under 64-bit?

  Hi everyone,   Primary platform is Framework 2.0 under 32-bit Production platform will be Framework 2.0 under 64-bit.   I'm concerned about what object should I use in order to launch DTS 2000/7.0 from our .Net service.   Currently it tested fine from a 32-bit environment (sql server 2005 as backend).   Reference: "Microsoft DTSPackage Object Library" Physical file:  dtspkg.dll   My wonder,   is there any limitation when it's gonna to work on 64-bit   Generally speaking, any limitation/issue/drawback for COM objects under 64 bit In my project properties appears Any CPU, x86, x64. I've got now Any CPU.   Thanks for your advices,   ...Show All

• David Luu Package Configurations - Using One config file for Multiple Packages

  Hi All, I am working on a project currently where we have many SSIS packages and we want to minimize the number of config files to be used. What I was thinking was using one master config file which will have Server/Database info which will be used by all the packages. Now the thing is there are multiple packages which are being executed from within a master package and I was wondering if this will be an issue. Is there anything else that I will have to keep in mind Any help is appreciated. Thanks Thanks Jamie If my memory serves correctly then you will get lots of warnings about references in your config file to properties that don't exist in your package. But it ...Show All

• aashta "batch size setting" ?

  Is there a "bacth size setting" or some such t-sql option that determines the number of records sql will hold before commiting them as a group to the database TIA, Barkingdog Not that I know of, but you can use marshalling by setting up a loop and tellng it to commit. ...Show All

• Henry Chan Same "Jump to URL" expression working on 1 reportserver but not another

  I have the following 2 "Jump to URL" expressions in a report: =void window.open('http://barn/apx/PortfolioDetail.aspx linkfield=749', '_blank')" and =void(window.open('http://www.google.com','_blank'))" Both of these expressions work on 1 reportserver but not another (within exact same report). Has anyone else had similar issues The reportserver that works is on IIS v5.1 and SQL 2005 on a XP SP2 machine. The reportserver that does not work is on IIS v6.0 and SQL 2000 on a Win2003 SP1 machine. The report is exactly the same (even the dataset sources are the exact same) and it is deployed on 2 different machines as above. Could the IIS version difference be the issue Or a SQL server version difference ...Show All

• hlj16 SQL server Groups

  Is it possible that i can create a SQL Server Group in sql 2005. Eg. in 2K when u right click (in Enterprise manager) on Microsoft Sql servers you can see "New Sql server Group". I am talking about this group. I have many servers in NYC and Dallas and in VA. I want to group them in the group names NYC DAL VA. is it possible. Yes, a screen shot would be MOST helpful. do you have a mail ID where i can mail u the screen shot Sure. You would do this is the Registered Servers section of Management Studio. Just create whatever groups you want and then register the servers into those groups. Press Ctrl+alt+G or View -- Registered Server . In this window u can group the servers Madhu My e-mail is in ...Show All

• bharathi_tunes Full text Index on US English String

  Hi, The following queries on a fulltext index is returning different results. select CustomerNameLocal from dbo . Customers where contains ( CustomerNameLocal , 'A.C.E' ) -- returns 1388 records select CustomerNameLocal from dbo . Customers where contains ( CustomerNameLocal , 'ACE' ) -- returns 1388 records select CustomerNameLocal from dbo . Customers where contains ( CustomerNameLocal , 'ace' ) -- returns 1388 records select CustomerNameLocal from dbo . Customers where contains ( CustomerNameLocal , 'a.c.e' ) -- returns 22 records Can someone let me know why the last query is retuning only 22 records. Since search on ACE and ace returns the same number of records - I guess there shouldn ...Show All

• AG Hunzian Printing Reporting Services Reports from a Access Report(VBA)

  Hello Everyone, I have a fun question here... We have a vendor which calls access reports only. I have moved 90% of our reports to reporting services and would like to move the rest. The users are complaining about having to go to 2 different places to do their work. (IE: The App and then the report server) I would like to able to fake out their system and have dumby reports call and print reporting services reports. Is there a way in VBA to call and print reports silently Thank You , Leo Place hyperlink control to call your report server report and write VBA code on click event of the control to dynamically create string for http address of the report server report and append nessesa ...Show All