Answer Questions

• mknecht SQL CE & @@IDENTITY

  If I perform an insert from my Vb.NET and then user select @@IDENTITY to return the identity, the query returns DBNull, even though the row has been inserted and an indentity created. If I perform the same insert from CE Query Analyser followed by the @@IDENTITY then it returns the correct identity value. If I perform the insert from my Vb.Net app, and then go to query analyser and select @@INDENTITY then it returns DBNull. Can anybody ...Show All

• Wellnow Analysis Manager: Cannot connect to repository. Analysis Server: <server name>.

  While trying to connect to a remote Analysis Server using Analysis Manager, I get the following error in a pop up window: ================================================= Analysis Manager: Cannot connect to repository. Analysis Server: <server name>. Error: Provider cannot be found. It may not be properly installed. ================================================= Can somebody help Thanks, John T Ad ...Show All

• Peter Larsen Error Handling with Execute Package Task

  I have a main package that calls several other packages using Execute Package Tasks. I also have OnPreExecute, OnPostExecute, and OnError event handlers at the package level to audit the beginning and completion of each package. I want to prevent each task from bubbling up to the package event handlers as well as prevent each task from bubbling up to the main package event handlers. I've tried setting the Propagate variable for each of the event ...Show All

• Philippe Trottier Can This Be Accomplished in My Time Dimension in my AS2005 Cube?

  In my AS2005 cube, I have a time dimension with the following attributes: year, quarter and month. Also, there is currently no hierarchy by design. Is there a way to make a custom attribute/time period that reflects the last 12 months (R12M) and work in the same manner such as year, quarter and month The time dimension would then have: years, quarter, month and R12M. As a result, a user can drop a measure such as Sales Amt and then add ...Show All

• Par Hedberg Referencing field by name in code

  I have a field (Fields!myfield) that I would like to pass in the name as two parts(Code.GetField("my","field") and dynamically return either a reference to myfield or the value itself. I'm getting Reference to a shared field requires a shared reference error when I try to return Fields!Myfield.Value from the function. I would like the ability to pass in the name of a field to a function and return the actual field name ...Show All

• Rich Tebb Database file and log

  Hi, I am just about to get familiar with SQL-Server 2005. Since I created a database and played a little with it I recognized that the database file has grown up to 150 MB as well as the log file. I used the shrink task to resize the database file. After doing so the .ldf remained as it was (150 MB). Since I would not need log information stored there, is it possible to shrink the ldf-file as well Thanks for your help! ...Show All

• John Ericson174499 Problem in Installing 64-bit Reporting Services

  Hi, Trying to install 64-bit SQL Server 2005 RTM on Windows 2003 x64 Server with SP 1. The Reporting services option is not enabled in the installation steps. The installation process gets completed, but the Reporting Services is not installed. The server does have IIS installed, the .NET framework 2.0 is installed by SQL Server 2005 RTM itself. Am I doing anything wrong. Can anyone help/suggest Thanks in advance. ...Show All

• ePeter T-sQL questions

  Hi: Some basic T-SQL questions please: 1) When I make changes to a stored proc (drop and recreate ) I have to reissue EXEC permission to users. Is there a keyword that helps to avoid that 2) In a SP I have multiple select statements. I'm only interested in the results of the last statement. When I run the SP from Query Analyzer it returns a result set for each select statement and When I call it from ASP.net I get .rowcount = 0. What am ...Show All

• ablmf Customizing Report Manager

  As I recall, in RS2000 there was no way to customize the appearance of Report Manager. I see that RS2005 has stylesheets which permit some customization of the appearance (maybe these were available in RS2000 also, but I never looked for them), but it appears that the source code for the web pages is still not provided. Is that the case, or is it possible to obtain the source code for Report Manager so that more extensive page customizations can ...Show All

• JedG Business Scorecard Manager Export ro RTM SSRS

  Anyone know how get Reporting Services Export Component of BSCM Server installed with RTM SSRS It was Ok with CTP 16 SSRS, but now failing the reporting services pre-requisite check. Cheers in Advance, David ...Show All

• roy_wang How do I get overall package duration?

  I'm developing a web app that displays the running packages and the total elapsed time. I'm calling GetRunningPackages() method and using the ExecutionDuration property of the returned package. The duration seems to be only for the currently executing container and not the entire package. Is there a way to get the duration of the entire package Thanks. Thanks Jamie. It appears I was mistaken. The ExecutionDura ...Show All

• Thomas_K XML DOM Document

  Hi, I created some DTS packages in sql server 2005 and this morning I am getting errors. I am able to open the packes to edit. Following are the errors: Error 1 Error loading MCDMS_Load_Key_OCRepair_Extract_TST.dtsx: Unable to instantiate XML DOM document, please verify that MSXML binaries are properly installed and registered. E:\SCRIPTS\MCDMS_Scripts_System_Test\MCDMS_Load_Key_OCRepair_Extract_TST.dtsx 1 1 Error 2 Error loading MCDMS_Lo ...Show All

• honclfibr "Login Failed" for sqlcmd using integrated on Vista Beta 2

  When logged in as a member of the admin group on my box, I cannot connect to my localhost server (SS2005 SP1) using sqlcmd. sqlcmd -s localhost Server logs say: Error: 18456, Severity: 14, State: 11. Login failed for user 'NORTHAMERICA\davigust'. [CLIENT: <local machine>] I can connect via Management Studio, which triggers the User Access Control stuff. How do I get sqlcmd to connect when running as a ...Show All

• norm74 Excel pivot table

  Hi, I have created an OLAP Cube in SQL Server 2005 CTP2 and can browse it fine in the Analysis Studio / Browse tab. When I use the pivot table feature in Excel (2003) I get: XML for Analysis parser: The LocaleIdentifier property is not overwritable and cannot be assigned a value. Any help is appreciated. Cheers, Adam Yup, me too.... WinXP sp2, SS2005 sept ctp, Office 2003. Any help would be appreciated. Re ...Show All

• SanderV Users for encrypt and decrypt purposes only

  Hi there, Using symmetric keys and certificates in SQL2005, can one assign users permission to only decrypt or encrypt data Reason would be say data capturer and data reader type roles. I tried to create some with the GRANT CONTROL and GRANT VIEW for certificates and definitions on Symmetric keys, but havent been to successfull. Would be great if someone here can offer some advise on it, and if it's possible using SQL rights. thanks ...Show All