Answer Questions

• Michael1956 Corrupt cubes in Analysis Services 2000 due to missing roles

  I have a Analaysis Services database with two cubes, shared dimensions and several roles defined (the cubes are small so the multiple roles do not use up all the memory). Unfortunatly I cannot open the cubes anymore. The editor gives an Error like: Unable to open the cube Financieel. An unexpected error occured. Please restart the application. I deleted all the rows, but still it didn't work. Then I tried to migrate the database to SSAS (2005). During the migration I got the error: The accountmanagers1 role referenced by the accountmanagers1 permission does not exist in the TestCube database. This role accountmanagers1 role is not available in the manage roles dialog. How do I repair these cubes ...Show All

• Shane Fatzinger Divide by zero error only with top

  In the following expression, the query executes with no errors (there are sometimes 0's and nulls in IRON and ENERGY): SELECT * FROM gff2vg WHERE ( gff2vg . ENERGY > 0 and gff2vg . IRON > 0 ) order by IRON / ENERGY desc but when TOP is added there is a divide by zero error. Is there a way to avoid this SELECT TOP(64) * FROM gff2vg WHERE ( gff2vg . ENERGY > 0 and gff2vg . IRON > 0 ) order by IRON / ENERGY desc Thanks. I only unmarked this as a solution because I am not sure of the nullif in the case ENERGY = null behavior and a null in IRON. The original intention is to get a recordset with no records that have IRON = nu ...Show All

• Necromantici Locking Due To Select Query

  Hello Friends, I am totally new to locking field so I need your help. Below are my environment details: OS = Windows 2003 + Service Pack 1 SQL SERVER= SQL Server Enterprise Edition + Service Pack 4 My Organization is using an application that is designed in PowerBuilder. The problem is so many times this application got hang due to blocking in sql server. I have diagnosis the problem in the below steps, Waiting spid = 192 Select * from sysprocesses Where spid = 192 Dbcc inputbuffer (192) Then Select blocked,* from sysprocesses Where spid = 192 Returns 201 I had repeated the steps till I got BLOCKED = 0 , STATUS = sleeping and ...Show All

• Zaex Error Processing Dimensions

  Hi, I'm getting an error when processing a Dimension (translated from german): Origin German Error Message: Fehler im Back-End-Datenbankzugriffsmodul. OLE DB hat den unbekannten Status '' fur die 1-Spalte gemeldet. Fehler im OLAP-Speichermodul: Fehler beim Verarbeiten des RATED CDR-Attributs der RATED CDR-Dimension aus der CubeTest2-Datenbank. Translation: Error in the Backend Data Access Module: OLE DB has returned the unknown Status '' for column 1. Error in the OLAP Storagemodule: Error in processing the rated_cdr Attribute of Rated_cdr dimension from CubeTest2 Database. We're trying to read the Dimension Data from an IBM DB2 Database. All Access rights to the database are given to the running user. I have no idea w ...Show All

• bikerchick 'Log' is not a member of 'Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptObjectModel'.

  I have been developing a large SSIS project and it uses scripts extensively. During development, i encountered no problems. However, when i tried executing them on a server (windows server 2003), i was given this error for all the scripts: Here is a brief log: PackageStart,servername,network\login,PkgName,{A6778813-1F3A-4133-A00C-6F02AC8CC8B1},{EA6E6337-8C07-428D-9E3B-CEEB4F95A185},3/10/2006 5:24:26 PM,3/10/2006 5:24:26 PM,0,0x,Beginning of package execution. OnError,servername,network\login,PkgName,Rename Error Files,{8d38e1b7-44e8-419e-963e-c689edd0be2c},{EA6E6337-8C07-428D-9E3B-CEEB4F95A185},3/10/2006 5:24:30 PM,3/10/2006 5:24:30 PM,7,0x,Error 30456: 'Variables' is not a member of 'Microsoft.SqlServer.Dts.Tasks.ScriptTask ...Show All

• maryz Wrong connection when switching computer

  Hi My C# application has a DataGridView which is bound to a DataSet. I used Visual Studio to add/configure the data source. Everything works fine on my computer. When I try to run the application on another computer I can't connect to the database, because it uses a wrong connection string. How can I make a specific connection/connection string permanent for a specific application Thanks. Sorry for responding late. The problem is not the connection string. My application works fine on my desktop computer, but it does not work on my notebook (at home). I used Sql Management Studio on the notebook to connect to the Sql Server and got the following error codes: 40 and 53. I even got another note ...Show All

• ideal24293 MSDE [SQL 2000] -- Server balks when web page loads -- select permission denied

  Hi folks, I'm having trouble getting off the ground with the Web application walkthrough "Walkthrough: Creating a Web Application Using Visual C# or Visual Basic" in VS.NET Pro 2002 [Academic] documentation. After a bit of fishing around, and consulting the MS Knowledge Base, I got the pubs database installed. I also got the connection to work well enough that the dataset would fill in the IDE. The problem is that when I try to run the web form, either from the IDE debug menu, or by accessing the .aspx file on localhost using Firefox, I get the error: SELECT permission denied on object 'titles', database 'pubs', owner 'dbo'. showing in the browser. My understanding is that this page is running as ASPNET, and I did already carry ...Show All

• Sugan Creating a Yes/No field in SQL Server

  hi, i need to create a yes/no field in a SQL Server database table. I know that i could previously do this in Microsoft Access and i believe that SQL Server now uses Boolean(0 or 1) for this. Does anyone have any ideas as to how to convert these 0 or 1 to yes or no with a default of yes I am taking the output from this table and displaying in Excel as yes or no not 0 or 1. Thanks If you want yes/no you either have to transform the data at the SQL Server side first, converting the data into VARCHAR columns with the static text yes/no or you have to use a expression in Excel which evaluates the value and displays the appopiate text. The default value can be change by putting a default constraint o ...Show All

• Sonia2 Problem with sql2005-kb918222-x86-enu.exe (cumulative hotfix, build 2153)

  Hello, I do experiment a problem when trying to install the mentionned patch on my Windows XP SP2 machine (fully patched). Interestingly, the patch works fine for the named instance, which is a "clean" install of SQL Server 2005 SP1, while it fails on the default instance, which is a SQL 2005 SP1 upgraded in place from SQL Server 2000 SP4. Both instances are Developer editions... The error is along the following lines: [snip] 08/10/2006 09:22:06.728 Unable to install MSP file: \\DHDHY0J\c$\1c7c01591e524f9a092159a233\hotfixsql\Files\sqlrun_sql.msp 08/10/2006 09:22:06.818 The following exception occurred: Unable to install Windows Installer MSP file Date: 08/10/2006 09:22:06.818 File: \depot\sqlvault\stable\setupmain ...Show All

• missbluebar user defined functions

  Hi everyone, Today while using user defined functions, I noticed that we must write dbo. before the function name which I did not conceive why it is used like that. Why are there an exception for functions Why do we not have to use the same thing while using SP or not user defined functions Thanks Hi, thakns for your clarification. However something still makes me a little bit confused about this is that is it possible to restrict some user about using UDF or SP Thanks restrictions are being made by managing security of your SQL server. if you want some user not to use your sp or udf you will need to give it a role of public or datareader for example. it depends what you want to achieve. i advice you to take a look at mic ...Show All

• Cathie 64 Which Server

  Hi Guys, I'm a beginner with Access and I set up a small database for a local charity project with a backend, front-end over a network drive. The database works well except that when too many people have the database open (there could be up to 6) at the same time it runs very slow. Someone said to me that if I put the tables on a server on one of the computers then it would improve the speed of the database but I would still like to keep the front-end as Access. Can anyone tell me if this approach would be a solution to my problem and if so which server would suit my needs, remembering that money is an issue Thanks R2DJ, Do you know where I could find out how to configure this to my specifica ...Show All

• StevenGreen OLE DB VS ADO.NET

  I think this is a question you could find on every .NET related forum. But I'm going to throw it: Which connection type should I use ADO .NET or OLE DB I know in the past ADO was just a layer on top of OLE DB so it was better to use OLE DB directly. Nowadays, with ADO .NET, that isn't the case anymore or am I totally wrong The reason why I'm asking this is because I'm considering to switch from OLE DB connection to ADO .NET because I have nothing but troubles with parameter mappings and wrong values inserted in the database because of data type conversions. When I use ADO.NET, everything works fine. What about performance A fable or the truth In my testing environment I work with small datasets but in production this won' ...Show All

• rdkelly SSIS SSUCKS

  I can no longer attach the OLE DB Provider for ODBC drivers as a data source. Thanks M$. You just broke backwards compatability with the rest of the world. I can't imagine how much rework this is going to involve for everyone and for absolutely no purpose. Besides, when you select anything in the buggy UI, the properties window does not refresh to display the properties of the currently selected object. You must select, right click, choose properties from the right click menu to force the properties pane refresh. Then the property you need to set is not there! Or the event that you needed is unavailable. Or the event is renamed to some obfuscated tag. VS 2005 sucks. SSIS sucks. My job just got a lot harder b ...Show All

• James Walsh Strange GROUP BY Statement Output

  I am currently straching my head as to why the following doesn't work as I expect. I have Three tables UsersManagers, Users and Bookings:- SELECT MAX(UsersManagers.UsernameUser) AS UserID, SUM(Bookings.HoursTotal) AS NumHours FROM UsersManagers LEFT OUTER JOIN Users ON Users.Username = UsersManagers.UsernameUser LEFT OUTER JOIN Bookings ON Bookings.Username = Users.Username WHERE UsersManagers.UsernameManager = 'testPM1' AND (Bookings.DateOfBooking BETWEEN '01 October 2006' AND '31 October 2006') GROUP BY UsersManagers.UsernameUser This statement returns only one username with the hours they have booked in my Bookings table. However the left outer joins (I would have thought) should return an entry even if there are no hours booked for a u ...Show All

• god_rr BCP Interactive - from script

  I have a script where I'm doing a bcp out - I need to have the script do the format file on export. Is there a way to run bcp interactively from script, accepting the defaults THat way it will make a format file for me. when you use bcp, a format file is not required, most of our scripts just use the native defaults, we never use format files. Is there a reason you need a format file You can generate a format file like so: bcp pubs..authors2 format nul -fc:\authors.fmt -Sservername -Usa -Ppassword yes, you can bcp in without a format file. We've never ever had to use a format file when bcp'ing in or out. Of course our datatypes always matched, and we always use -n, but I'm sure -c works ...Show All