Answer Questions

• Steph Wilson How i could connecting to Analysis Services from BI Intelligence Studio with server authentication?

  Hi: I have been working at client work station with BI Intelligence Studio but i want deploy the project in server machine, but my windows credential don't have sufficient privilege for do it. However i know the server credential for do it but i can't find the project settings for do that. The account you connect to the AS server as will need permisions to deploy the database. In the Windows Start menu ...Show All

• SamuelNguyen diploying reports on browser with custom assembly

  Hi friends, We are using SQL Server Reportin Services 2005 (SSRS) for development of our reports instead of Crystal Reports. As per our clients requirement we want to make all reports dynamic eg. whatever background color user select should appear for that report etc etc. So for this we have written one function and created DLL for that. Now we are refering that DLL in all our reports as Assembly Name in Reports \ Report Properties \ Refe ...Show All

• David Dong Where can I download SQLServer 2005 Express SP1

  I have followed the link to download SP1 of SQLServer 2005 Express Edition, but, on that page nowhere it is mentioned that downloads offered are of SP1, it simply says that SQLServer 2005 Express edition. What is the correct link and am I really on the correct page of SP1 I guess you were right, see the instructions to update your SQL Server Express installation under point 3.1 on this link HTH, Jens ...Show All

• bonza TransactionScope

  Hi, I am trying to use transactions as below: using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope()) { //some code here // Throw an exception to roll back the transaction. // Call the Complete method to commit the transaction } I can't seem to get it working though. Have trided several things like Security Configuration on the MSDTC tab, restarted “Distributed Transaction Coordinator” S ...Show All

• George W Bush Page number doubt in RS2000

  Hi,     I have created a report which has a Table of Contents and two other sections say Sec1 and Sec2. Sec1 and Sec2 have tables which are populated from the database. The page numbers of Sec1 and Sec2 are not known at design time. In the Table of Contents, I need to show the page numbers where Sec1 and Sec2 start. How can this be accomplished Regards, Asim. Were you able to find a solution I ...Show All

• Nenad Vicentic how to save/publish cube results from analysis services 2005

  We can't figure out how to publish cube results from analysis services 2005 management studio. We can't find a way to save work in progress or save results sets other than in excel with the cube analysis add in.  Some of our data sets are too big for excel. Has anyone done this Do you mean "How to save the views that I create in the Browser tab of Cube in  BIDS " If thats, the question ...Show All

• Todd Peasley 00 Query Tool from SQL Server 2K Missing in 2k5 Edition?

  My favorite tool ever in SQL 2000 was a little utility, a front end if you will for querying the system tables. It was under the tools menu and if you typed say 'account', you could find all objects containing the name 'account'- stored procs, tables, columns, etc. A GREAT little tool that few people seemed to use. Now I have 2K5, can't remember its proper name to google it by, and can't seem to find it anywhere, though I suspect it is burri ...Show All

• Rick van de Laar Database is read-only.

  Hi I have been learning on how to use the new features of the .NET 2.0, and Well I using VS2005 and everything is pretty straight foward. I did a Membership webform where you log in and create users and roles etc. I installed the SQL Server 2005 express as my Data provider and thats where my Tables are. I used the aspnetsql_reg comand to integrate the server to this application. Anyway my problem started when i decided to copy my project to my ...Show All

• krazysmile Import/Export data with SQL Server 2005 Express

  Hello folks! I have installed SQL Server 2005 Express and SQL Server Management Studio Express. Everything looks ok and works fine, but I can't find the Data Import/Export Wizard.  Can anyone tell me how to Import/Export data Thank you!!! Hello, Try: C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe Worked for me! I totally agree, SQL 2005 Express is u ...Show All

• Bradl Replication Error 28559

  We have a PDA application (Net CF 2.0) which uses sql mobile and synchronises to a SQL Server 2000 database (merge replication). We were using SQL CE 2.0 on the PDA earlier and moved to using SQL mobile recently. Since this move we are getting error 28559 (SQL Server Mobile encountered problems when opening the database - says in the documentation). The error does not happen regularly. When it occurs the device needs a soft reset to re ...Show All

• mech55 Cannot Display result or Submit SQL statment contains Thai Character via ODBC

  Hi there, I am developing a web based application using ASP.NET. The current application developed using VB 6 with ODBC connection, Thai character can be shown correctly. But in ASP.NET with same ODBC connection, the display result characters become " " This also happened when I tried to include some thai character in my SQL statement. The Thai character also converted to " " The ODBC I am using is through IB ...Show All

• James Boman insufficient access rights error when doing backup

  Im using dbo schema for ABC SQL Server 2005 Enterprise database on my laptop. I would like to deploy the ABC into a server running on SQL Server 2005 Standard database. The server database is using abcuser schema. I can do attach/detach and backup/restore on the server. I got error so I generated sql script and install into the server. So now I see all the tables are created with abcuser schema. Once I tried to generate a backup from the ser ...Show All

• briisek Accessing Cube from Excel 2003

  Analysis services Cube is created using SQL Server 2005 (CTP June). Server is in Prod domain. There is no problems accessing and playing with Cube in the same box or within PROD domain. While trying to access Cube from excel 2003 from a computer in other domain QUAL gives the following error "an error was encountered in the transportation layer" Any suggestions I'm not exactly sure how IE Security setti ...Show All

• Ever Change query issues

  I am trying to take this statement: Select Total = SUM(gt) FROM (Select Distinct CustomerName, CustomerNumber, FeeGoal_AZ AS FG, FeeSchedule, (cast(FeeGoal_AZ as numeric(30,10)) / FeeSchedule) * 100 AS gt from DCR WHERE branch='00002' group by CustomerName, CustomerNumber, FeeGoal_AZ, FeeSchedule ) as dTable and change up (cast(FeeGoal_AZ as numeric(30,10)) / FeeSchedule) * 100 AS ...Show All

• Chill Phil RS 2005 Custom Security Extensions problem

  I have upgraded to the September CTP of SQL Server 2005 and I was looking into writing a custom security extension for the reporting services project I am working on. I downloaded the latest .NET Framework SDK but it turns out that it is based around the 2.0.50215.44 version of the .NET Framework and the september CTP uses 2.0.50727.26 and they aren't compatible. Is there anyway I can write and compile a custom security extension for the Septemb ...Show All