Answer Questions

• Chuck S. I think i killed Analysis Services (05), need a reset button

  Hi, I'm a cube rookie and have been deploying funky cubes while i'm cutting my teeth on AS. Unfortunately, AS has completely stopped responding, connecting to it in SQL Server Management studio or BI Studio just results in a hang. The service will stop and start without error in the Event log, but i can't interact with it any more.  Restarting the PC doesn't help... I tried to uninstall it, but setup is forcing me to uninstal SQL server with it, which isn't a good idea for me at this point. Is there any way to 'reset' AS Thanks! Edited To Add: Well, i've blown away any file i could find under this directory that appeared to have anything to do with my cube and i can now connect to AS...wish me luck! C:\Program Files\Microsoft SQL ...Show All

• RickGaribay.NET Package with WinZip hangs

  Dear Folks, I have a package that calls winzip to extract files(command line usage) in an Execute Process task. The package runs fine if I am logged in to the server. It hangs on the winzip task otherwise. The package is stored on the server (as opposed to the file system) & is run under a proxy account using the SQL Server Agent. I tried adding folder and WinZip32.exe permissions for the domain user who the proxy account was created under to no avail. Any Ideas Thanks for your help! Log into the server as the MS Service accout running the job and run WinZip and click the "OK" button accepting the licence. If you never login, it generates a prompt and waits forever waiting for someone to click ok. ...Show All

• iansbrainstorm Unable to communicate with report server

  When I browse to http://localhost/Reports/Pages/Folder.aspx I am getting "Unable to communicate with report server. Please verify that the report server is operational". The http://localhost/ReportServer runs fine in the browser. Also the config files have the correct urls. Any ideas Thanks Mark DO you have some other service like Sharepoint installed on the machine HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• cherriesh Trying to call the function a Web Service from Transact-SQL

  I currently have the fllowing Stored Procedure. When I pass the the Url of the web service in the parameters, I'm having a sp_OAMethor read response failed error . I don't know how to pass the parameter as well as the name of the function in the Web Service I'm calling. Maybe I'm all wrong here with this code too Thanks for any help. ALTER PROCEDURE [dbo] . [pTAPServiceWeb] @sUrl varchar ( 200 ), @response varchar ( 8000 ) out AS DECLARE @obj int DECLARE @hr int DECLARE @status int DECLARE @msg varchar ( 255 ) EXEC @hr = sp_OACreate 'MSXML2.ServerXMLHttp' , @obj OUT IF @hr < 0 BEGIN RAISERROR ( 'sp_OACreate MSXML2.ServerXMLHttp failed' , 16 , 1 ) ...Show All

• Ed77 Primary Key Question

  I have been developing a .NET Web app with an SQL Server 2005 Express database. Since I've been testing insert and delete code with a large data source, the Primary Key column which is also an autoincrement integer column is now at very large numbers (starting at over 40,000 now). I've tried doing a shrink on the database, but other then reducing the database size, it has done nothing to reduce the Primary Key numbers. Is there a command way to reduce the starting number back to 1 or do I need to completely reconstruct the database from scratch TIA No dice. Neither of those options does it. That I want is, for example, a way of changing the lowest Primary/Identity Key value from 40,000 to 1. T ...Show All

• dumian scheduled subscription

  I always confused about scheduled subscription what does scheduled subscription can work for me how to use this thanks in advance Well, that's a very good question. Maybe I can turn it into a blog in the coming days. In the meantime, as you well know, an event driven subscription is rather straightforward. When an event occurs, notify the set of subscribers who are interested in that event. For example, I want to be notified when a certain stock exceeds a threshold that I set. A scheduled subscription is similar; it notifies subscribers of certain event data. However the primary difference is that it does so at an appointed time. For example, I want to be notified at the end of each day with ...Show All

• EthelMary040 Defining a named set

  I have built a cube and I want to add a named set. Following dimensions are important: suscriber and handset. The set I want to create should contain only those subscribers for which the handset is different from the handset from the month before. I tried to use the filter function resulting in the following: filter ([Dim Subscriber].[Subscriber].[Subscriber]. members ,([Time].[Month],[Dim Handset].[Dim Handset].[Dim Handset])<>([Time].[Month]. prevmember ,[Dim Handset].[Dim Handset].[Dim Handset])) But deploying the cube returns the error message that "<>" cannot be used with sets... Can anybody help me Thanks in advance... Regards Joos You mentioned that [Dim Sub ...Show All

• pdxJaxon reportviewer in studio 2005 versus reporting services

  what advantages do i gain by the following: 1. if i access my sql db by binding a dataset using report viewer control in my application and generate my reports why would i need sql server reporting services if i donot need subscriptions i.e all my clients will be logging in to my application using their own login credentials and the stored procedures used in the dataset will only pull up reports pertaining to them. Not sure why one would want to invest in sql server 2005 reporting services in your scenario, local reports (dataset binding) may be everything you need. Report Server gives you enterprise reporting with the ability to share the report catalog with multiple users. ...Show All

• exal SSIS package execution error

  While executing the SSIS package from visial studio it is running. If we execute from Integration services - - -> stored packages - - - -> msdb - - - -package name, the package gets executed. But when scheduled through jobs it gives the following error in history "Execution as user. <user name > The command line parameters are invalid. the step failed" command line looks like this " /DTS "\MSDB\Maintenance Plans\Package1-HYUNDAI" /SERVER tvmwindev02 /CONNECTION "10.10.1.52.upsframis";"Data Source=10.10.1.52;Initial Catalog=upsframis;Provider=SQLOLEDB.1;Integrated Security=SSPI;Auto Translate=False;" /CONNECTION DestinationConnectionOLEDB;"Data Source=mscoe.db.ust ...Show All

• Hytham Displaying selected rows from a Fact table

  I have a fact table which stores data ( customer name, document type, editing start time, editing end time, editor, revision id etc) for each revision of a document. While displaying data however i need to take into account only the last revision of each document. What is the best way of doing this Do I need to create a separate dimension table with the document id and max revision id as fields or is there a better way of doing it Make them a real measures, and move whatever expressions you use for them to the Leaves(Revision) inside MDX Script. One idea would be to mark Revision dimension as of type Time, and use semiadditive measure LastNonEmptyChild - this will show data for the last revision only. In the p ...Show All

• PsychUK Cant's shrink tempdb in sql2k5

  Hi, tried to shrink 190gb tempdb but got following message: DBCC SHRINKFILE: Page 1:24027896 could not be moved because it is a work table page. Anyone know why The tempdb is almost empty, just doesn't release free space. hi rmiao, is your tempdb files set to autogrow regards jag If the database is still being used by an active transaction and the worktable locates at the end of the file, you can't shrink it. Consider taking at look at the following resources. http:// support.microsoft.com/kb/307487 http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx Yes, but don't think it's related. I personally have not seen thi ...Show All

• Boman Hide only export dropdown list and "Export" link button from report toolbar in sql report server 2000

  Hi All I want to hide export dropdown list and "Export" link button from reportviewer toolbar . because i create my own export function so , Please help me in this Thanks Alpesh I think that this url can be helpuff: http://blogs.msdn.com/bimusings/archive/2005/07/08/436887.aspx ...Show All

• dotnetwizkid How can i treate Huge DB size in sql server 2000

  Hi all, I have DB in operation its MDF size reached 8.38 GB and the system that work on the queries of insert timeout and the operation failed and many problems happens ... actually the reason of the huge size of the DB is just one table that contain image field which we store word files in it in each row in the table ......... so how can i solve this problem without affecting the structure of the DB ..... coz we don't wanna to make code changes in the application that use this DB thanks use DBCC DBREINDEX  to reindex all the tables and use sp_updatestats   to update all the table statistics and see the performance  also use sp_spaceused @updateusage = 'TRUE' to get the space used by the data... ...Show All

• j238 Access Database Synchronizer for SQL Express

  Hi Can anyone from MS please confirm if we can tweak the Sychronizer to hook into SQL Express rather than Access Access is not a database for the real developer and its beyond me and many in this forum why we are limiting the ability of developers to use SQL Express Using Access is not only tacky but limits the performance of a serious system and therefore the piblicity we can generate for MS I look forward to peoples thoughts on this Regards Touraj No this cannot be modified to work with SQL Express or SQL Server Everywhere on desktop. This solution is targeted for Microsoft Access only. We had a big ask for this feature from developer community. If you want to synchronize ...Show All

• Alle AS2K5. Internal error: An unexpected error occurred (file 'pffilestore.cpp', line 3267, function 'PFFileSto:HandleDataPageFau

  I have a simple query, that produce internal server error. Internal error: An unexpected error occurred (file 'pffilestore.cpp', line 3267, function 'PFFileStore::HandleDataPageFault'). WITH MEMBER [Product].[Product].Slicer AS [Product].[Product].&[ 214 ] SELECT ([Date].[Fiscal].[Fiscal Year ].&[ 2005 ]) ON COLUMNS, CROSSJOIN({[Product].[Days to Manufacture].[All Products],[Product].[Days to Manufacture].[All Products].children},{[Measures].[Internet Sales Amount]}) ON ROWS FROM [Adventure Works] WHERE ([Product].[Product].Slicer) Another MDX query produce wrong result. WITH MEMBER [Product].[Product].Slicer AS [Product].[Product].&[ 214 ] SELECT {([Date].[Fiscal].[Fiscal Year ].&[ 20 ...Show All