Answer Questions

• Predator14567 Setup question: ASP.Net Version Registration Requirement warning message

    Hi there, I have only this warning message during the System Configuration Check: ASP.Net Version Registration Requirement (Warning) Messages ASP.Net Version Registration Requirement 64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit). Does this mean that I can't install Reporting Services or should I pay no attention to it and continue to install I'm running on Windows 64-bit Pro. edition. Thanks, Eric Starting a command prompt with UAC probably means that if you are using Vista you elevate the Command prompt to have evelated priviledges using the "Run as administrator" option. Jens K. Suessme ...Show All

• Gumbatman is there any way AMO app can get information from data source without reprompting user for user name and password?

  I'm writing some code that will use AMO to access an AnalysisServices cube. I've found that some information that I need doesn't appear to be available from the AMO interfaces directly, so I need to get the information from one of the data sources. I tried using ADO.NET to connect to the data source, but I found that the Microsoft.AnalysisServices.DataSource.ConnectionString has the authentication information (i.e. username and password) removed. So... is there any other alternative that will allow me to get information from the data source (i.e. issue SQL command to the data source and retrieve the result), that does not require me to prompt the user for the authentication information Can I somehow go through the AMO and have it issue th ...Show All

• progames25 Extended Procs using C#

  What is the procedure to create a extended stored procedure using C#. Actually we have created a dll file using c# and it was added to the bin folder of mssql server. Also dll file is added to the sql server using "xp_extendedproc" But while executing the extended proc we got this error "ODBC: Msg 0, Level 16, State 1 Cannot load the DLL xp_TestSql.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.)" You can use C++. Check out this sample article on how to create an extended stored procedure There is no procedure -- using a .NET language to create an XP is not supported.    http://support.microsoft.com/kb/322884   ...Show All

• JIM.H. Can OWC and ASP.NET be used to connect to an OLAP cube running on SQL Server 2005 ?

  Hello, I'm from Romania and I have a small problem. I recently found on MSDN an articol and an ASP.NET project showing how to browse an OLAP cube from a web page, using OWC controls. The cube was built using Analysis Services for SQL Server 2000. My question is can the same be done with a cube running on SQL Server 2005 (browse it from ASP.NET page using OWC) If so, can anyone please give a link to an tutorial or sample project Or if not, please offer a solution on how to browse an OLAP cube from SQL Server 2005 from ASP.NET. Thanks. Hi. It's me again, I have downloaded and installed all necessary stuff, and project runs seems to run fine, but the Office Web Control says it cannot find the object specif ...Show All

• Dámaso SQL Package Configurations

  Hi, Within the SSIS package i am currently developing I have a number of variables relating to folder locations. I have added these to a SQL configuration package as i'd like to be able to change these prior to the SSIS package being executed. I plan to launch the package by calling a SQL Agent job from a web page. On this web page i'd like to be able to change the values in the SQL database so that the package runs with User specified folder locations. If anyone has done this before i'd appreciate if you could suggest how best to accomplish this. At present i'm thinking of just interogating the created database but as there are no keys etc set up this may not make updating the table easy. Many thanks, Grant ...Show All

• Ron Rice Can you install SQL Server 2005 on Vista Ultimate Edition?

  Ive been told that you cant install SQL Server 2000/2005 on anything but a server OS (such as Windows Server 2003). How are people installing this into vista then as Longhorn is far from being released When i try and install it into Ultimate, i only get the option to install client tools... which makes sense as the machine isnt a server. Surely people can install SQL Server 2005 in Vista though All of the features are green ticked except the OS which has a compatabilty warning (which i expected). I feel im missing something really simple here.... Cheers Rob Macnair Hi Rob, Terrence, I have both 2000 and 2005 installed. 2000 runs fine as long as Vista User Account Control is turned off. Good luck! By ...Show All

• Robert Barnes SQL Server 2005 Installation Failure on Vista

  Help! I'm trying to install SQL Server 2005 on 32-bit Vista RTM. Have tried several editions (Developer, Standard, Enterprise). Have tried installing while logged in as domain user account in machine administrator group as well as built-in Administrator user. Running SETUP program with elevated privilges. Certain portions (Analysis services, Notification services) install correctly, but never the database engine. Always fails consistently with the same error reported. Machine has Visual Studio 2005 installed already, but NOT SQL Server 2005 Express Edition. Error logs reports are below ({computer name} is the name of my machine) UI error reported: TITLE: Microsoft SQL Server 2005 Setup ------------------------------ SQL Server Set ...Show All

• csLearner How can I format the Date in the SQL Table using a SQL query

  Hi I have a SQL table that contains date in this format :- 2006-07-02 16:20:01.000 2006-07-02 16:21:00.000 2006-07-02 16:21:01.000 2006-07-02 16:22:00.000 2006-07-02 16:22:02.000 2006-07-02 16:23:00.000   The date above contains seconds that I dont want, how can I remove those seconds so that the output looks like :- 2006-07-02 16:20:00.000 2006-07-02 16:21:00.000 2006-07-02 16:21:00.000 2006-07-02 16:22:00.000 2006-07-02 16:22:00.000 2006-07-02 16:23:00.000   Your help will be highly appreciated. Hi, You can do as.. update tablename set datecolumn = select dateadd(s, -datepart(s,datecolumn), datecolumn) Shallu wrote: Hi, You need to remove Select Key word.. UPDA ...Show All

• maarga Simple Date Formatting Questions

  Hello all, Need some help formatting a date.. Simple but I am not sure of how to do expressions in SQL report service, new to the product. So here it is.. In my expression box I have =Fields!ServiceDt.Value this returns mm/dd/yyyy HH:mm:SS I want it to return YYYYMM any help would be great. Just need to know the code for the expression box!! Help! Thanks everyone, you guys are always great help Also for anyone else here's an article on setting default dates in reporting services: http://jhermiz.googlepages.com/defaultdatemsrs thank you for the help and the resource! Hey George Thats a simple one :). Here you go: =Format(Today(), "yyyyMM") All you have to do is replace Today() with your field so it becomes =For ...Show All

• SB1 Partitioned View Pruning Issue

  I'm using Sql Server 2000 Standard Edition, service pack 3. I'm fairly new to partitioned views and merge replication. We have a 3-year set of monthly tables with about 1 million rows per table from some code we inherited. To ease development , I'm trying to create a local partitioned view. We wanted it to be UPDATE-able and be able to select data by a date range or by id without incurring very much cost. The problem is that my SELECT statements correctly prune the unneeded tables while my INSERT, UPDATE , and DELETE statements do not. Here's our basic structure: CREATE TABLE [dbo].[Call_2004_01] ( [id] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [callStartedOn] [datetime] NOT NULL , [rowguid] un ...Show All

• shyma SQL Server 2005 - Transactions

  Hello guys! I am working with SQL Server 2005 a few months, and i need your help about transactions topic. In first, i hope you are patient with my english, i will try to explain it the best i can ;-)) and now... my question and thanks you in advance. I am trying to set the transaction option of a foreach loop container task in run time using the Expressions option. There, I have configured the transaction option of this task with a variable value (var type int) and this variable is informed at the beginning of my dts using a script task (values: 0 for Not Supported, 1 for Supported, 2 for Required). The problem is the transaction option gets the variable value but... the variable value by default. After, during the dts executi ...Show All

• JUANCARLOSR Secondary server in log shipping

  Hi, We have SQL Server 2005 configured with mirroring to protect from physical errors. We also have a need for an (out of sync is ok) reporting server and we'd like to reduce our downtime in the event of a logical error. The primary database is already being backed up (full and t-logs) to a shared network drive. Can I implement the second half of log shipping (i.e. the stuff you do to the secondary) so that I don't have to change the current backup schedules on the primary server Specifically in the list of sp's below, can I start halfway down at sp_add_log_shipping_secondary_primary (Transact-SQL) Without having to run the primary sp's sp_add_log_shipping_primary_database (Transact-SQL) sp_add_jobschedule (Transact- ...Show All

• alienated How to set Multiple Active Results Sets (MARS) enable in ODBC

  hello all there can any body tell me how could i set the Multiple Active results Sets (MARS) option on/yes in case of the ODBC. The thing is i create the connection using the SQL Native(sql sqrver-2005)wizard, i got following when create the DNS Microsoft SQL Native Client Version 09.00.1399 Data Source Name: DM_N Data Source Description: Server: vsnet1 Use Integrated Security: No Database: DM Language: (Default) Data Encryption: No Trust Server Certificate: No Multiple Active Result Sets(MARS): No Mirror Server: Translate Character Data: Yes Log Long Running Queries: No Log Driver Statistics: No Use Regional Settings: No Use ANSI Quoted Identifiers: Yes Use AN ...Show All

• Eyvind Getting an identity column value returned from an insert trigger on a view referencing multiple tables

  I have a view employing multiple tables with the same ID. The master table has an identity column (REG_ID) as its primary key and that key is used as the primary key for the other tables in the view. I have the insert trigger working except for one item. New records are properly written to all the tables in the trigger, but the value of the just inserted record is not appearing in the "Open Table" View from SQL Enterprise Manager when I insert a new record in the table. What am I doing wrong Code Follows: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER Trigger [View_1_INSERT] ON [dbo] . [View_1] instead of INSERT AS BEGIN SET NOCOUNT ON ; Declar ...Show All

• Matt Bell Connection manager or Data Source

  For seting up the connection should we use Connection Manager or New Connection From Data Source The advantage of using Data Source is that we have the connection avalilable at project level but I've studied it somewhere that Data Source is used for SSAS not SSIS. But I don't have enough explanation to give it to my team, that why I am not using Data Source. We are working on VSS, do we have to reset the connection managers if want to test our packages on some other machine(else than the one on which it was developed) Paarul wrote: For seting up the connection should we use Connection Manager or New Connection From Data Source The advantage of using Data Source is ...Show All