Answer Questions

• Malebolgia rsAccessDeniedToSecureData

  I've installed a fresh load of SQL Server 2005 onto a Windows 2000 server, including all the trimmings with SS2005. Reporting Services 2005 is the main thing I want to initially check out, but I can't get it to work. In the 'Reporting Services Configuration' it shows the 'Web Service Identity' as a blank grey box which can not be edited. I can't help but think this might be where the issue is. I looked at this thread, as it describes the exact same problem, but the solution did not work for me. The RS service will start up, but then when I navigate to http://localhost/reportserver or http://localhost/reports it gives me the following error: Reporting Services Error Hi, Thanks for your reply. ASP.NET version = 2.0.50727 There is ...Show All

• Bret Grinslade How to use SQL Svr 2005 Express in Excel 2003 VBA code?

  Hello, how can I use SQL Svr 2005 Express as database engine in background through VBA code in Excel 2003 I want to CREATE and DELETE tables and SELECT, INSERT and UPDATE data. Is it possible to use ADO or other database objects to get in contact with SQL Svr 2005 Express Thanks a lot. Christian Yes, ADO is still supported... but... ADO 2.0 will take care of the new sophisticated features of SQL Server 2005 where ADO 1 doesn’t have a clue of, but at the end, ADO is still supported. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- Sorry, I was meaning ADO.NET 2.X not the old ADO. This means VBA only supports ADO 1.0 ...Show All

• Ron L Can't connect to sql express 2005

  I have an very big application written in vb6 running on msde 2000. I tried to change it to sql express 2005 and I cannot connect to the database. I wrote a sample app in vb6 using adodc and it works fine. From the other app I get no connection. I copied the same connection string!. I do not use the adodc control.I connect with a connection object.I have enabled pipes and tcp/ip. Any ideas or suggestions more than welcome. Which error do you get HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- The error message is -2147217843 Login failed for user 'Master'. I detached the databases from msde2000 and attached them on SQLExpress 2005.   ...Show All

• markm75c crash recovery (huge rollback) going on over 24 hours! How can I stop it?

  Crash recovey is going on over 24 hours! I want to stop it! One of the databases in our server is in recovery mode after a huge delete job (started as a job) did not complete ( I suspect due to lack of transaction log sapce.) the log file size is 120 GB. Whenever the server restarted the recovery for this database starts. After 20 hours, analysis done 100% and recovery done up to 76%. Then after “the percentage of recovery done” went down to 16% and it is still running. How can I get rid of this database without damaging the master database and other database in the same instance I don’t mind to lose this database. There are 4 user databases in this instance and msdb and the recovery mode database are not operationa ...Show All

• Kamarey Installing SQL Server 2005 on Windows VISTA ULTIMATE

  Hi, Trying to install SQL Server 2005 on Windows VISTA Ultimate, received following error: - SQL Server Edition Operating System Compatibility (Warning) Messages SQL Server Edition Operating System Compatibility Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online. Please help. Can you use your domain account for the installation (after making yourself a local administrator of the machine) and keep it connected to the network during the installation Or else, is it possible you are using a test version of Vista Or perhaps you ha ...Show All

• Link9228 Rank function

  hello, this the MDX for my calculate measure in AS2005 Rank([SL_Territory].currentmember, order([SL_Territory].members,([Measures].[Sales],[SL_InvoiceDate].currentmember), bdesc),[Measures].[Sales]) the problem is...I get the Rank=1 on the Grand Total instead of on one Territory dimension as it should be. Am I doing something wrong Thx Hi Guys, I think you are trying to get to the following query! try it.. With Member [Measures].[SalesRank] as Rank ([Geography].[State-Province]. CurrentMember , Order ([Geography].[State-Province].[State-Province]. Members , [Measures].[Reseller Sales Amount], BDESC )), NON_EMPTY_BEHAVIOR = '[Measures].[Reseller Sales Amount]' ...Show All

• PeterJMoore Dynamic query

  Hello I have a problem with writing a query.Let me give an example: Table: ColA , ColB , ColC , Col1 , Col2 , Col3 , Col4 , Col5 Ok.I must write a SP and it gets a parameter,say @param. if @param=1 then in the select statement I will select Col1,if @param=2 then I will select Col2 and so on. How can I do this Thanks. Joey gives an answer how. You could also do: declare @query varchar(max) set @query = 'select col ' + cast(@param as int) + ' from table' Or if the column names aren't actually numberd, use a CASE expression to pick the columns. The question I have is why do this If all columns are only useful one at a time, this is probably a design issue. If this is to support some u ...Show All

• Ivan.Drew Query datetime and its performance

  Hi all, I know I miss something very obvious here, but I can see it at the moment - I am very appreciated if someone could help. Why am I have a table scan when I run the query below - note created_date is indexed. DECLARE @LastDate datetime SET @lastDate = (SELECT DATEADD(hh,-1,getdate()) SELECT * FROM Report WHERE Created_Date >@lastDate However, I don't have table scan when I do the following query SELECT * FROM Report WHERE Created_Date > (Getdate()-1) Thanks in advance Thanks for replying Ronald but nope, tried that - I still have table scan. :-( BTW I am using SQL 2000 Philly: I think that the answer is in two parts.  First, your SELECT * query requires a bookmark loo ...Show All

• ChrisErven Matrix Report Not Showing All Columns

  I have a matrix report that I am using with MonthName(Fields!Month.Value) across the top of the report. However, when there is no data under the column, the month is skipped. So, for example, I get this: January March Actual Goal Actual Goal 25 25 30 35 I have tried adding iif(Sum(Fields!Total.Value, "DatasetName" )> 0, Sum(Fields!Total.Value, "DatasetName" ), "N/A" ) But it still is not showing up. Any ideas Thanks, SHP Thanks, Ham. Yeah, I set up the month table in the stored procedure and then returned isnull(datafield,0) and that took care of the problem. Thanks for your help. I found a similiar ...Show All

• LuckyL number in words

  Hy, I use Reporting Services with Visual Studio and in my report I have to write the numbers of my data base in words. For example : "55" has to be written "fifty five". I have to do that in two other langages: french and dutch. But I don't know at all how to do that. I never used reporting service before. Can you help me Regards This code is perfect Thank you The requirement you present is not a simple one and certainly is not something that supported out of the box. Your best option is to create a table with the range of numbers you wish translated and a language code column and get some resource to generate the translations manu ...Show All

• Whoisit Connecting to SSIS in Management Studio.

  Hi: I have 4 named instances of SQL 2005 running on one of our sales server (dont ask me why I have 4 instances.Its a beefy box btw). All the instances have SSIS Packages (around 6-7 in each instance) saved to the SQL server and not to the file system. The issue is every time i need to look at the packages or export the packages from SSMS I have to edit the MsDtsSrvr.ini.xml and type in the named instance name within the <ServerName></ServerName> tag . I then have to restart my SSIS. I dont see an easier approach to this method. This is causing me a lot of unnecessary time waste. is there anyway this can be automated where in i can pass the instance name dynamically to the ini file or even more best, can I have all the in ...Show All

• clueless in chicago Concatenate strings after assigning text in place of bit strings

  I have a whole bunch of bit fields in an SQL data base, which makes it a little messy to report on. I thought a nice idea would be to assigne a text string/null value to each bit field and concatenate all of them into a result. This is the basic logic goes soemthing like this: select case new_accountant = 1 then 'acct/' end + case new_advisor = 1 then 'adv/' end + case new_attorney = 1 then 'atty/' end as String from new_database The output would be Null, acct/, adv/, atty, acct/adv/, acct/atty/... acct/adv/atty/ So far, nothing I have tried has worked. Any ideas I solved my own problem: select fullname, case when new_accountant = 1 then 'acct/' else ' ...Show All

• noob_vber Join multiple tables

  I'm trying to join 3 tables: EMPLOYEE - empid SKILL - empid, skillid, skill SKILLOPTIONS - skillid, option An EMPLOYEE will always have at least 1 SKILL but each SKILL may or may not have any SKILLOPTIONS. I do an INNER JOIN: EMPLOYEE->SKILL->SKILLOPTIONS but I only get a record if there is actually a SKILLOPTION. I want a record with EMPLOYEE and SKILL even if there are no SKILLOPTIONS. In Oracle it is the (+) symbol in the WHERE statement in conjunction with the JOIN. Am new to this so I'm sure the answer is simple. Try left join, like EMPLOYEE left join SKILL on EMPLOYEE.empid= SKILL.empid left join SKILLOPTIONS on SKILLOPTIONS left join SKILL on SKILLOPTIONS=skillid=SKI ...Show All

• tolily Issue of Blank Emails , When checking for free disk space and mailing DBA

  Hello I have got a script which checks the percentage of free space on the drivers of the servers and mails the DBA when it falls below a certain percentage , which can be set according to our requirements. But I am getting blank emails even when , there is no issue of low free space. Please help me out. The code , 1st part of it is: use master go SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO create PROCEDURE usp_diskspace @Percentagefree int, @error2 varchar(8000) OUTPUT AS SET NOCOUNT ON DECLARE @hr int, @fso int, @drive char(1), @odrive int, @TotalSize varchar(20), @MB bigint , @COUNT int, @Maxcount int,@error varchar(700), @errordrive char(1),@errortotalspace varchar(20), @errorfreespace varchar(20), @free int, @date varchar(1 ...Show All

• JohnSLG Hierarchy Parent-Child

  Hi. I have a parent-child relationship in a table, by making use of an ID, and Parent ID. Firstly how do I manually change, or setup this hierarchy. Secondly, how do I do a rollup, along this hierarchy, sothat I can retrieve the aggregate values, using MDX I thank you in advance for your feedback. Hi. After a more thorough look, I determined that BI Studio seem to have sucessfully determined the hierarchies. I can say this, based on the 'levels', that is shown under the parent view. The problem that I now have, is that for two tables, of exactly the same structure, BI is showing me the ID's of one table, and the 'name' values for another. I have already tried to set the 'NameColumn' ...Show All