Answer Questions

• ewren Parentheses in SQL Server 2005 Management Studio

  When writing queries in the query editor of SQL Server 2005 Management Studio, I would like the matching parentheses to be highlighted whenever I have my cursor over an opening parentheses. Obviously this functionality is there. If you delete and retype and existing opening parentheses, the matching closing paren will be highlighted. How do I turn this on all the time Thanks, Hi Brian, Sounds like this is a possible bug. Check out the p ...Show All

• r.cicca OPENQUERY throws Error 7357 when the source SP uses temporary table.

  Hello Everybody / Anybody, Sorry but exiting problem! The Problem : OPENQUERY throwing error [Error 7357]when the source SP uses temporary table. Description : Need to validate data against master list. My combo on UI has a source Stored Proc(contains a temp table in it). I'm importing data from Excel. Before import, I want to validate it against my master list values. [say field Priority has master values "H ...Show All

• Harini Error 404 when opening reportserver

  Hi, On a new WinXP Pro SP2, I've installed VS2005 Pro, IIS 5.1, and SQL SRV 2005 Dev Ed (in that order - in stalled accepting all default settings). Although the State of the Default Web Site is "Running", I can't open http://localhost/reportserver (not in IE6, nor with IIS manager). Even worse, http://localhost/ nor http://localhost/iisHelp/ won't open either. The IIS reply is "HTTP Error 404 - File or directory not found& ...Show All

• Tony N SSRS 2005 Export to Excel without redundent white space

  Hi Is it possible to export reports to excel without all the redundant columns I have tried the deviceInfo settings in the url and config file /Reports/Pages/Report.aspx ItemPath=ReportServerProject1/Report1&rc: RemoveSpace=0.5in and <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"> <Configuration> ...Show All

• Gene Webb Select last record for a subset of users

  How would I select all of the people that are currently in a particular group Suppose that I have a few tables in a database that look (abbreviated) like this: TGroups groupid TUsers userid TGroupAudit groupid userid datetimejoined You know that a person is in a particular group because it is the last group they joined. When a person joins a group, a new record is created in TGroupAudit to record the e ...Show All

• marceloudi Incremental loading

  Hi Friends please let me know how can we incrementally load a destination table with source table. bearing in mind that we need to track that there are no duplicates in the destination table. I need to load only changed or new data in the final load. Please give me some examples also. I am tryin this from last 2 days as I am totally new to SSIS. Sachin, I dount there is a link covering what Richard has described. Just follow his instru ...Show All

• Tony Danby where can I find Wrapping or truncating property of values in a Textbox!

  Hi All, I developed a report with some values in textboxes. I want the output not to wrap around to the next line but to be truncated if it is more that the size of the textbox. Is there any setting that i can do b/c values are going to the second line when their size is more like printing name and last name will cause last name to go to the second line  Thank you in advance. Hello, If you set the CanGrow property of the Te ...Show All

• SithKitty Absurdal affair in trigger file

  Hi! I found a bug in my trigger and i don't know why it is error. See small report: After executing following code's fragment in my trigger:   print '************** koszt sadowe *****************' + str(@orzecz_koszty_sadowe) print '************** koszt mks *****************' + str(@orzecz_mks_przyznane) print '************** koszt korespondencji *****************' + str(@orzecz_zasadzona_zaliczka_na_koresp)   -- Potrzebne d ...Show All

• richard12345 SQL Server Mobile Stored Procedure?

  Does stored procedure functionality exist in SQL Server Mobile 2005 From looking at the books online I'm thinking no since I can't find a reference to a Create Procedure command. Thanks. thanks! No. SQL Server Mobile does not support stored procedures. The 'next best thing' is to use the Prepare method in your SqlCommand object, so that the sql statement only needs to be compiled once by your application: http://msdn2.microsoft.c ...Show All

• OX Invokation of a stored procedure from an Integration Services package

  Is it possible to execute a stored procedure from an Integration Services package I see that its possible to enter sql commands that can be run but when a command to execute a stored procedure is entered the system cannot find the stored procedure (eventhough 'use mydbname' preceded it. thx, Marilyn You certainly can execute a stored procedure, but we'll need some more information to help. Are you usi ...Show All

• TSZ How to view MDX query from Excel report

  Hey guys, I generated OLAP report from SQL Server Analysis server using Excel. When you are using Excel to generate a report from OLAP database, excel will take care of generating the required MDX query behind the scenes. That means you don't need to hand-write MDX queries yourself. So, my question is pretty simple, i.e. Is there a way to view the MDX query that is generated automatically by excel Thank you for taking your precious time. ...Show All

• rambili What does TimeStart and TimeEnd signify in the ExecutionLog table

  I'm trying to determine where my performance issues are and need some definitions of these fields and what they are indicating in the Execution log file.. I have an applicaiton web server that connects to the reporting servcices web server that generates a pdf. It takes 5-10 seconds to get the download pdf screen on the application but when i look at the log the difference between start and end time it is 3 seconds. In addition if you add ...Show All

• Frank De Koninck SSIS: Fpreach Loop Container- Execute SQL Task with ReturnValue Parameter

  Here's the set up: ForEach Loop Container: Collection: Foreach File Enumerator Variable Mappings: Variable = User::DailyFile, Index = 0 Execute SQL Taks: Connection: OLEDB ResultSet: None SQLStatement: EXEC spGetFile ParameterMapping: VariableName = USER::DailyFile, Direction = Input, DataType=VARCHAR, Parameter = 0 This works great it iterates through a file and looks at all the files checks to see if they ha ...Show All

• TonyZhen Jdbc connection to sqlserver 2000 failing

  I have a java application whihc is running on a Solairs machine trying to connect to sql server 2000 database. The java application is usinga J2SE 1.4.2 jdk. The application has all three of the required jar files (msbase.jar, msutil.jar, mssqlserver,jar) on the classpath When I try and connect to the database I receive the following exception java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error opening /loading com.m ...Show All

• PPtrueno Installation of SQL server 2005 Developer Edition Sep CTP

  Hi, I am trying to install SQL server 2005 Sep CTP on my laptop... I have installed VS.net 2005 beta 2, my OS is XP Pro SP2. It always get hanged at "Detecting Installed IIS". Please help... thanks SQL's a better location than VS General. Sorry for not able to reply before... yes... that norton security center created the problem... i did the same thing and it is working fine now... thanks for you reply... Moving the thread ...Show All