Answer Questions

• prashanthmscis1227 Cube Browser FAILS to open. It HANGS

  Hi, I am working on the Analysis Services Tutorial. When I am in Business Intelligence Studio and I right-click on the cube and I choose browse to open the cube-browser, the Cube-Browser HANGS FOREVER. it never finishes opening. I always end up using the taskmgr to kill off Business Intelligent Studio. How is this HANGING problem fixed AIMDBA Try to see if re-installing Analysis Services will solve the p ...Show All

• jorrit5477 "The statement did not return a result set" error on SPs with exec

  I'm trying to modify our application to use the SQL Server 2005 JDBC driver. After making the appropriate changes most stuff seems to work OK, except for any stored procedures that contain an exec statement and return a result set. When the stored procedure is called with executeQuery it throws a SQLServerException with the error "The statement did not return a result set". Other query SPs that don't have an exec work just fine. It doe ...Show All

• Neshhra Sql EX 05 can't view dB and Tables

  Hi, I’m new to sql ex 2005 and have a couple of questions I can’t find the answers to.   Q.1    I am working with VS web dev ex 2005 and I’m trying to backup my db,   is it as simple as copying the .mdf file Or should I create a text file, or something else   Q.2   How do I view the content of the db in my web programs in the sql server 2005 ex   I can’t figure out what to do, to view the content. ...Show All

• Gu1234 Error 9104

  Why does the server return Error 9104 "auto statistics internal" I can't find an error description in BOL, MSDN or through a groups/forum search either. We running Sql Server 2005 (no sp yet) on Windows 2003 server. Thanks Hi Mark, I only have the severity level, 16. I don't capture the state in my error trace. We migrated to 2005 in mid-March and this error has been returned twice. ...Show All

• Ray1127 Convert Date Format of 00-XXX-00 to NULL

  Let me start by saying that I'm brand new to SQL Server 2005 and SSIS. I'm using the import wizard in SQL2005 to import from a flat file into a table and everything works fine except for dates. A typical date in my flat file is 01-JAN-06. 01 represents the day of the week, JAN represents the month and 06 represents the year. The flat file also contains date values of 00-XXX-00 which represent no date. For example a column containing last purch ...Show All

• Keandre Computer Memmory Resources consumed after generate MAAS Cubes (SQL 2000)

  Dear All, I have created some cubes with Analysis services (sql server 2000 Personal edition)  After processed the cubes if I restart the computer seems like the memory resources are being consumed by the msmdsrv.exe and the msmdvldm.exe, it takes about 30 minutes to the system becomes available;  I would like to know how if theres a way to configure my OS and the MASA sides to have better response. SQLSERVER 2000 Personal E ...Show All

• Omar Naeem Setting up a Content Manager

  I have inherited an application that calls RS via the web service. The security on the Report Manager appears to be such that the previous developer was the only person who could upload reports. This person is no longer with my organisation. Is there a way to add myself as a Content Manager I am in the administrators group on the server and running the Report Manager locally still only allows me to view the General information and not to cha ...Show All

• ProwlingPanther XML type - OK replication and mirroring ?

  Do XML columns work OK with all types of replication, and with database mirroring There aren't any gotchas in those areas are there Thanks, Andy Mackie Not that we aware of. If you find any, would you please let us know ;-). Best regards Michael ...Show All

• marek_matonok Incorrect Results with t-sql Query in SQL Server 2005

  I'm seeing some change in behavior for a query in SQL Server 2005 (compared to behavior in SQL Server 2000).  The query is as follows: ------------ create table #projects (projectid int) insert into #projects select projectid from tblprojects where istemplate = 0 and projecttemplateid = 365 Select distinct tblProjects.ProjectID from tblProjects WITH (NOLOCK)       inner join #projects on #projects.projectid = t ...Show All

• amilate Script to add groups and register servers in those groups

  We have several different environemnts with several servers in each. We now want to share SQL Server Admin around the group. I would like to create a script that would add each server group and register each server in the appropriate group Something Like exec sp_addservergroup 'Dev' exec sp_registerserver 'Dev', 'AccountingDev' exec sp_registerserver 'Dev', 'MarketingDev' exec sp_addservergroup 'Test' exec sp_registerserv ...Show All

• AJ_101 SQL 2005 Very Slow on Itaniam 64bit

  Hi, I am facing a very wierd problem with SQL 2005 Itaniam 64bit with 4 processor machine. A simple SQL Select Statement: Select * from table The statement takes almost 45 minutes on a table of 7 million records, while on SQL 2000 32bit 2 processor machine it takes 10 minutes. The checked the index, and rebuilt it several times and still the problem persists. I tried the database fine tuning wizard but still no effect. Tried ...Show All

• WSantos set context_info

  I have req: where i need store a string value and retrive it later on. And it should be session specific. Hence I thought of using "set context_info". But when I set the value and then retrive it the values are not similar. Here is a sample where the length are different: declare @context_info_var varbinary(128) select @context_info_var = cast ('test' as varbinary) print len(@context_info_var ) //5 IS PRINTED set context_info @context_info_var ...Show All

• bbanks How can I detect which version of sqlServer I am connected to using smo?

  Hi, I have a quick app to do few scripts and generate sps.However some stuff which is new to sql 2005 dont work in sql 2000 as not supported. Basically. I choose a server from a combobox and connect to the database. now at this point i need to know if I am running a sql 2005 server or 2000 . Is there a call I can make is SMO to achieve this thanks a lot in advance Hi, try this one here: ...Show All

• Howard555 Failed to access IIS metabase???

  Please help! All of sudden, I cannot connect to the reporting services through MS SQL Server management studio. error message is "Failed to access IIS metabase". As I checked the system: 1. reporting services is working properly (status is "started") 2. cannot access http://localhost/ReportServer$SQL2005  , the same error 3. Run:"C:\>cscript metaacl.vbs IIS://localhost/w3svc", it shows: Microsoft (R) Windows Script Ho ...Show All

• wayne62682 Deleting Parameter From Preview Pain

  Product: Reporting Services 2005 Visual Studio 2005 I've added parameters to my query in the Data Tab.  Then removed one.  The preview pane still shows the deleted parameter even though it does not exist in my query.  I've tried opening the dataset settings and re-adding the parameter, saving, then deleting.  This ghost parameter will not disappear from the Preview Pane.  Is this a bug or am I not deleting it& ...Show All