Answer Questions

• Bingo Boy Returning resulsets between procedures !!

  Hello, I need to do the following, But I receive an error: CREATE PROCEDURE dbo.EJEMPLO_A AS BEGIN SELECT TOP 10 NAME, ID FROM SYSCOLUMNS END -- and Later use the one above... like this... CREATE PROCEDURE dbo.EJEMPLO_B AS BEGIN DECLARE @temp_lista TABLE (NOMBRE VARCHAR(500), IDENT NUMERIC(5)) INSERT INTO @temp_lista execute dbo.EJEMPLO_JULIAN END Pd. I just have to capture the dbo.EJEMPLO_A resulset... and I can't modify It jortiz wrote: Hi Dave, thank you so much for your answer... The problem here Is that I can't modify the dbo.EJEMPLO_A procedure, I just can change the second one... I mean ... I have to do in the second procedure something like SELECT dbo.EJEMPLO_A Thanks I got to Do ...Show All

• SP_Tom Excel export without table formatting?

  Hi - Is it possible to get the Excel renderer to just render the table data and not the table formatting I’m having the same trouble as a few other people here: our customers tell us Reporting Services 2005 SP1 is generating a huge Excel file that Excel won’t open. They're only interested in the raw data so any way to simplify the file would help. The data includes long numeric serial numbers with leading zeroes that don’t survive a CSV export and our customer is asking for something better than the CSV I've already provided. I’m guessing the answer is no: I’ve found a few old posts and the consensus seems to be use OfficeWriter if you’re having trouble with Excel export. But no-one’s asked about omitting the formatting, so maybe ...Show All

• TheViewMaster Debugging stored procedures

  I have complete error handling and printing the error after every insert or update statements or after calling another procedure. But somehow when executing the proc it is not printing the error. The query analyzer shows a general message 'Query batch completed with errors' All the logic seems to be working properly, but this message is bothering me. Why is this message displayed if everything is run correctly [or] is something wrong Example: [code] /************************************************************* ** Error Handling **************************************************************/ SELECT @rowcount = @@rowcount ,@error = @@error ,@short_msg = 'Error Creating MCTM. ...Show All

• lnkaye ::FN_VIRTUALFILESTATS doesn't work in Sql2k critical

  Hi everyone, I perfectly know that this post is bad allocated but it's a critical one. We've a cluster and there it don't get rows. I'm trying this sentence: SELECT * FROM ::FN_VIRTUALFILESTATS and from our production server doesn't return results. Why the hell not However from other servers it returns data. Thanks for your time, Have you tried examining query execution with SQL Server Profiler That's a good idea. ...Show All

• NeilCFD ASP.NET session has expired

  I am having a problem with displaying my reports. The report viewer control would display a "ASP.NET session has expired" error message after trying to load the report. I am using web parts and personalization for my application. The report viewer control is also embedded inside a custom web part control. This problem is intermittent and a refresh of the web page will sometime solve the problem. I have tried suggestions posted on the forums but none has helped. I am deploying soon and need a solution.. TIA ...Show All

• Aqua General Why there are no tables listed under AdventureWorks_Data in SQL Server Management studio

  Hi, I downloaded AdventureWorks DB from http://www.microsoft.com/downloads/details.aspx FamilyID=e719ecf7-9f46-4312-af89-6ad8702e4e6e&DisplayLang=en In one of the sample WinForm application, I find a few SQL queries retrieving data from tables like [Person].[Contact] , [HumanResources].[Employee] . The sample application is working fine.But the same query doesnt work in Sql Server Management studio and there are no tables in AdventureWorks_Data DB. Can anybody tell me what is wrong and where AdventureWorksDB.msi is a case-sensitive database. Check to make sure the schema/objectname is correctly spelled. Are you sure this is the same database (not because they have the sa ...Show All

• daimaku Named Calculations for measures with formula

  Hi, The details of background are avaliable in this prev post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=550862&SiteID=1 After edward melomed's advice I tried to create a named calculation for the respective Fact table. The problem is, let us say I have a two measures M1 and M2 in a cube. Now I want a named calculation say 'NM3' , that contains the formula M1 + M2. So I write the following SQL in the named calculation: (select M1 + M2 from fact table) although the query is right, while processing I get the error that the query returns multiple values. So now how do I specify the current row or how do I specify something similar to a cursor I know that I can achieve this using calculated measures instea ...Show All

• Teddy79 Unable to browse data in Dimensions or cube

  The error I get says the provider cannor be found, it may have not been properly installed. I've re-installed Analysis Services, and still get this error. The Connection to the server (data sources) tests sucessful. What version of Analysis Services are you using What client application you are using to browse your cubes Edward Melomed. -- This posting is provided "AS IS" with no warranties, and confers no rights. I'm using AS 2000, and using AS2000 to browse the cube and dimensions. Looks like the installation got corrupted somehow. Try re-installing your AS2000 installation. I remember seeing similar problems reported by people in the communi ...Show All

• MrGenius should be simple - FLAT FILE - HEADER / DETAIL LINES

  I can't believe it's been a few days and I can't figure this out. We have a flat file (purchaseOrder.txt) that has header and detail lines. It gets dropped in a folder. I need to pick it up and insert it into normalized tables and/or transform it into another file structure or .NET class. 10001,2005/01/01,some more data SOME PRODUCT 1, 10 SOME PRODUCT 2, 5 Can somebody place give me some guidance on how to do this in SSIS The problem I see is that SSIS does not handle flat files with an uneven number of columns very well. Flat File and uneven number of columns: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1134754&SiteID=1 Perhaps you can use a flat file source with ...Show All

• Michael Pritchard How to print labels like label 1 of 1 and label 2 of 3....

  I have a report that will be a label and I need to print N number of labels depending on a certain number returned from the query. Let's say that number returned is 3. So, on my first label I want to print 1 of 1 and on the second label, 2 of 3 and the third, 3 of 3. All other information on the label will be the same for all 3 labels. All information used is from the query. One of the fields accessed through the query holds the number I need to use to do this. Is there a way to do that through the report designer using vs.net Is there a setting for this or is it a SQL thing I need to put in the query some how. Or am I completely off track Any help would be greatly apprciated. thanks I'm under ...Show All

• duck thing SQL Server 2005 Schema and Security

  Hi everyone, I'm currently investigating the security improvements of SQL Server 2005. I've got some problems with the schemas introduced in SQL 2005 and security settings. For my test I've created two schemas: UserManagement and Sales. A user "test" is attached to the UserManagement schema. There's a table Sales.Users containing a list of users (varchar) and a stored procedure named UserManagement.AddUser that can be executed by the UserManagement schema (GRANT EXECUTE, so "test" can execute the SP). UserManagement.AddUser simply inserts a new row into Sales.Users. Because the Sales schema doesn't contain any user, nobody (except the sysadmin, of course) can do a INSERT/SELECT/DELETE in the Sales.Users table. As expect ...Show All

• Rob Davis38041 Updating Proactive Cache in AMO

  Hi All This is a pretty basic question I'm sure but BOL have been of little help... I want to changed the Enabled property of the ProactiveCache object for a partition and then save that back to the cube. I can't see any other method that will save this other than updating the partition object, e.g. oPartition.ProactiveCaching.Enabled = False oPartition.Update() However this causes the whole partition to be processed which is not what I want. Now I know there must be a way becsuse you can do this very simply via XMLA, I just don't know what the correct method is to call after setting the Enabled property is in AMO. Any help would be much appreciated. Regards Rob. ...Show All

• OJacob Correlated subquery in UPDATE - Where am I going wrong?

  Hi, I'm sure I'm missing something obvious, but I'm trying to get the following update to work on SQL2000, but it keeps complaining about the where clause. UPDATE Table1 SET Col_A = t2.Col_A, Col_B = t2.Col_B FROM Table1 AS t1, (SELECT TOP 1 Col_A, Col_B FROM Table2 WHERE Col_C = t1.Col_C) AS t2 WHERE t1.Col_A is Null I'm fairly certain I can get it to work with a cursor, but that's not the best way to go, is it. Do I need to use a join TIA, Menthos Hi Geert, gave it a try and it's not working. I know my SQL knowledge isn't stunning, but doesn't your suggestion pull the top row from the whole of Table2 and then try matching Col_C against that row rather than creating a rowset of rows that match Col_C then taking the ...Show All

• K. Murli Krishna cpu quota / resource management

  Hello *, Is there a way to restrict resource consumption by user or connection If I execute some long running reports my complete server slowes down. I'd like to assign this reports only limited resources. Thanks, Michael Thanks for the hint, "SET QUERY_GOVERNOR_COST_LIMIT" is useful in this context. Additional question:- Is there a way to cancel running querries For instance by issuing a "cancel" call from a seperate thread Thanks, Michael You can configure database mirroring for the target database in your production SQL instance and create snapshot on the mirror server (your backup SQL instnace) on different machine. The principle sys ...Show All

• ACraigM119 SQL Server CE doesn't show in Reference dialog

  I already have VS2005 SP1 installed and after installing : SQLServerCE31-EN.msi SSCE31SDK-ENU.msi SSCE31VSTools-ENU.exe When I create a Smart Device project and and try to add a reference to SQL Server CE only the old version (3.0.3600.0) shows up. How do I get the new one (3.1) to show up Yes it does appear that you were referencing the wrong dll. The big issue is that because device and desktop projects have different framework dlls there needs to be different versions of the system.data.sqlserverce dll - the following FAQ that has been started at www.sqlserverce.org might provide a better explanation ( http://softteq.com/sqlserverce/blogs/faq/archive/2007/02/09/missing-system-data.aspx ) ...Show All