Answer Questions

• _phil https & setting ServicePointManager.ServerCertificateValidationCallback

  Hi, In my CLR stored procedure, I made a https request. To by pass the security check, I change the property of ServicePointManager: ServerCertificateValidationCallback . But SQL server 2005 does not allow me to do this and gives me exception related to security. It seems the CLR assembly does not have permission to set the property of ServicePointManager: ServerCertificateValidationCallback . What kind of user should I use ...Show All

• Mubashir Ali Generating XML based on XMLSchema in a SQLSERVER2005 Stored procedure

  Can a stored procedure in SQLSERVER 2005 generate XMLdata based on the schema Are there any features in SQLServer2005 to achieve this Please suggest me in this regard. Thanks vaishu thanks for the reply. vaishu Yes this is possible. Michael Rys' article about FOR XML support and the Xml datatype shows examples of this: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnsql90/html/forxml2k5.as ...Show All

• Mike Kidd Left Join Merge problem

  I am having a problem getting the left join merge to work when I attempt to join data that was staged from an Oracle database using the Microsoft OLEDB provider for Oracle with data from an SQL Server 2000 database.  I'm sorting and merging on 2 varchar columns and they never join.  Visually, the data looks like it should join and I can successfully join it in an SQL statement from Query analyzer.  Any ideas ...Show All

• billy_bob123456 Parent Child Dimension Attribute Hierarchy

  I hope I described that right! I have a dimension attribute that describes a self referential hiearchy in the dimension.  I have this setup and working with one exception.  When I use this hierarchy I only want members which have children to be displayed at each level instead of all members regardless of whether they have children.  How do I do this Thanks, Chris Hey Chris, If you don't display childless members at each lev ...Show All

• the_stig RTF Text in a SQL Server Report

  Dear All, I have tryed to insert a textbox in an SQL Server Report. With normal text it is easy to show the text from an access database with the help of a dataset in the report. But in my database I have text as RTF. Is it possible to show the formated text in an Report Hopefully anyone have the answer or an idea how it is possible to show rich text formated text in a report. Thanks stefan ...Show All

• protugy IF statement with BEGIN END block

  I'm working on a stored procedure which includes an IF statement at the end of the procedure which appends my sql call with two lines. But I'm getting an error that probably comes from the fact that I have a nested BEGIN END block in my overall procedure. Can anyone tell me if my assumption is correct and help polish of the syntax The error I'm getting is: Msg 156, Level 15, State 1, Procedure payments_sp, Line 55 Incorrect syntax ne ...Show All

• lueethefly NS 2.0 and SQL Server 2005?

  Will NS 2.0 work with SQL Server 2005   Or does it require SQL Server 2000 for the database components Dave Fackler Hi Dave, No, it is not possible to have NS2.0 work against the SQL server 2005 without upgrading. You can install SQLserver 2000 and SQL server 2005 side by side though. Thanks, Rama Hi Joe, Per the readme for the new Business Scorecard Manager, BSM ...Show All

• stanleyqian Error message "Interface not registered"

  Hi  I got the following error message when I make a new integration service project  Failed to save package file "C:\Documents and Settings\Administrator\Local Settings\Temp\1\tmp2B.tmp" with error 0x80040155 "Interface not registered". Can someone help Me Hi there, di you get a reply to your query as I am experiencing the same problem. Please e-mail me & let me know. Many thanks Try registering MSXML: regsvr32 ...Show All

• aaguilarch85 dimension records exceeds 64000

  I am facing a problem in SSAS, unlike Analysis service 2000 , I cannot find any grouping under level properties for a dimension. Actually one of the dimension is too big, some 1600000 records are there and no hierarchy as such. only way is to club by first alphabet,which we were using in 2000. i.e. by using the grouping property. but in SSAS 2005 I cannot find any, how do i overcome this, otherwise beyond 64000 records its not showing The ...Show All

• Ruud Baars SQL Date

  Hi, I am trying to cast or convert the datevalue (from varchar) to date type and compare the date and get the records of last 3 days onwards and ignore previous records. The current date format is 'yyyymmdd'. I used the following statements and compare value to -3 days to current date. So want the dates which are above -3 days to current date, so I used the following: (cast ('yyyymmdd' as datetime) >= dateadd(day, -3, getdate())) or (convert( ...Show All

• ThePope Unable to mix non-MDX parameters with MDX data

  All of my reports use time in some way. I have used the SSAS out of the box system generated time dimension. This generated table is joined to all of the tables I use in building cubes. Everything works well - fiscal year, month info, etc. when I use parameters that are generated from MDX queries. This however can be much too cumbersome when using finite sets of data. For instance, I have a fact table that it populated monthly (monthly snapsh ...Show All

• Aranda MSSQL 2005 JuneCTP Install Issue

  Any help on this: Win2003 STD server With SP1 MSSQL June 2005 CTP Enterprise version: During install i am getting this error: Failure adding user NT AUTHORITY\NETWORK SERVICE to local group SQLServer2005MSSQLServerADHelperUser (1388) Yes it is Domain Controller Hi, I have been able to successfully install the June CTP on a Win2003 with SP1 machine. Are you installing on a Server which is a domain controller Regards, Vikram ...Show All

• NZ_RGB XACT_ABORT

  What is the default value of XACT_ABORT  Assume I set it ON in a stored procedure named A, and other stored procedures has no explicit setting on it, what will happen on a client program that calls A and other stored procedures Thanks oj. But I still wonder whether setting it on in a stored procedure will only affect the stored procedure or it will affect the whole program. ...Show All

• CSHALL SQL 2005 Enterprise June CTP Installation Error

  Tried to install several times (on Win2003 Ent. SP1) but I always get the following error: Failure adding user NT AUTHORITY\NETWORK SERVICE to local group SQLServer2005MSSQLServerADHelperUser (1388) The user varies (sometimes NT AUTHORITY\SYSTEM) and so does the local group (sometimes SQLServer2005SQLBrowserUser). Any tips Regards Roger I, also, except the message I get is consistently this: Failure adding us ...Show All

• Juan Wajnerman Question on Report Builder/Designer

  I have Visual Studio 2005 Team Developer. I don't need SQL2005 since I have SQL2000. How do I get Report Designer/Builder for VS2005 I would like to use the Report Designer/Builder to build reports for Windows applications. Do I HAVE to buy SQL 2005 Thanks. I don't want SQL2000 I already have SQL2000. What I want to find is the Report Builder/Designer to use with VB programs within Windows. It is suppo ...Show All