Answer Questions

• SreeAtPru sp_columns in SQL2K5 gives no rows for function that return table

  Some automated tools use sp_columns to find out the columns for a table, view or UDF that returns table. In SQL Server 2000 it gives columns back but in SQL Server 2005 it does not, compat level set at 80 and 90. Does anyone have an idea what id going on here Repro script below. I expect the script to return information about the two columns in the table defined in fnTestColumnsFromFunctions(). if exists ( select 1 from s ...Show All

• CWC1980 Multiple details sections, possible?

  In a table the details section is called "table1_Details_Group". Is it possible to add a second details group so that I can have the two groups have different group properties I'm trying to avoid creating a second table and using an expression to only show one at a time. Again Thanks. possible poss bile poss-bile possibler possibly Edit... Revert to "possbile" Thanks but the detail ...Show All

• Gidjett how to modify stored procedure to achieve objective

  Can we modify the sp_datatype_info stored procedure to return datatypes >=3 only in sql server 2005 Is it possible with SQL Server 2000. If it is not possible to modify/drop the procedure, is it possible to change the name resolution logic to be able to call the procedure in another (for example dbo) schema Any other possible way to achieve this What is the true objective of what you are trying to accompl ...Show All

• DannoMontano How to use Fields or ReportItems value in charts

  Hi, all. I am doing a financial report needs to show last 10 yrs history data. The end year is the last year of the current year. How can I set the minumum and maximun with Year(Now) fucntion for the x-axis, to represent the years Is there any way to use Fields value for the chart minumum and maximun Yes this is possible in RS 2005 (but not in RS 2000). Axis settings such as min/max/crossat/major interval/mino ...Show All

• Grant Carthew SQL Impesonate Logon Problem

    Hi. I am currently working on an ASP.NET application which has to log on to SQL using a specific windows user account. As far as I am aware the only way to do this is by adding the Integrated Security=true ; property to the connection string. If you specify a user id and password then it will try to log you in as a SQL user. Is this all correct   To be able to login to the SQL server we explicitly call the LogonUse ...Show All

• Greg Brady Best Project Template & "The View of the event class could not be materialized"

  Can someone explain this statement to me.  "The View of the event class could not be materialized".  I get it when I try to do a build of my Instance. Also, yesterday I used CopySample to prepare an instance for my project.  I'm not sure if this is the right way to go.  Is there a better template to use or process to follow to create a complete project (including Visual Studio Build Scripts, etc...) Thanks ...Ray Ra ...Show All

• tomjanssen Someboy help me to receive the status of cubes's metadata info via SQL Query.

  Someboy help me to receive the status of cubes's metadata info via SQL Query. I've been analyzing this problem for two weeks and found several solution for example ActiveX (ADOMD.Catalog) or other programing solution, bat I want faund SQL solution this problem. Information Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service ...Show All

• shaggymog Optimization issues with a Database Maintenance Plan

  Hello all: I need some help with what the Reorganize data and index pages with change free space per page percentage to 10% does. Scenario: I have a replicated database using transactional replication with another server. Whenever this part of the maintenance plan runs, our application malfunctions until this part of the SQL maintenance plan completes. When finished, our application runs just fine... After disabling this portion of ...Show All

• Shtan Returns Nothing, But Executes Fine

  SELECT tblWatchInstance.WatchID,tblWatchBrands.Description,tblWatches.Serial_Number,tblWatches.OwnerFName,tblWatches.OwnerLName, tblClients.Name FROM tblWatchInstance INNER JOIN tblWatches ON tblWatchInstance.Watch_Key = tblWatches.WATCH_KEY INNER JOIN tblWatchColors ON tblWatches.COLOR_KEY = tblWatchColors.COLOR_KEY INNER JOIN tblWatchBrands ON tblWatches.BRAND_KEY = tblWatchBrands.BRAND_KEY INNER JOIN tblWatchTypes ON tblWatches.WATCHTYPE_KEY ...Show All

• FrankUcla Reporting Services 2005 and XML DataSource (as WebService)

  I'm trying to build WebService to use result as DataSource for RS 2005 (XML DataSource). But I have a strange problem. I have WebMethod with parameters. When I'm testing my WS in browser then everything works just fine. But... When I'm trying to call this web-service from VS2005 environment then something strange happens. Looks like VS passing parameters incorrectly to my WS (not passing at all!) I've created very simplyfied version just to c ...Show All

• def0 Is it possible to use ssas as datasource for report builder in june ctp?

  Good afternoon, Is it possible to use ssas as datasource for report builder in june ctp I am trying to use analysis services as a data source for report builder without any luck. When I try to create a new data source, my only choice is sqlclient data provider   If I create the data source based on analysis services project, it succeeds; however, when I go to the next step where I need to create a data source view, bi studio reports that t ...Show All

• The Wind failure installing SQL Server 2005

  I am trying to install SQL Server Sept 2005 on Windows Server Enterprise Ed. 2003 which was just freshly installed on a new partition. I downloaded files from a DVD and when I click on install.exe it checks the system configuration: everything is OK (all checks passed) but then I get a window/message: "The installation package could not be opened. Verify that the package exists and that you can access it, or contact the application vendor t ...Show All

• Wert small scale (light weight) SQL search engine (basically a stored procedure) to search through Products Table

  Hi, I am attempting to build a small scale (light weight) SQL search engine (basically a stored procedure) to search through Products Table. I am passing a search string, which i break up by the ' ' (space) delimiter. next for each [value] (after breaking up) in the search string I want to be able to count the number of occurences of each [value] in the [ProductName] [ProductDescription] fields of the [Products] table. However I am confused as i ...Show All

• Ramraj Balasubramanian - MSFT Integer identity value handling in export / import

  Hi, I have a question regarding export / import when you have tables with  autonumber (identity) columns as primary surrogate keys. Does export / import retiain the values of these columns so that referential integriy is not broken Charles I am Hitesh. I have the same issue. While exporting/importing data (from SQL 2005 to SQL 2005) IDENTITY column values get altered..this way my referencial integrity gets broken that is not good ...Show All

• henry neo for loop container to process all Excel files

     I'm having a problem getting the for loop container to process all excel files in a folder.  I set the collection folder to where my .xls files are, and i set a variable in the for loop container to the FileName.  I then changed my source connection and added expressions for ConnectionString: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + @[User::FileName] + ";Extended Properties=" +  @[User::ExtProperties] ( ...Show All