Answer Questions

• ergb10 Errors reported by uninstall tool for SQL Server 2005 (Tools) Express Edition CTP

  Over time I've updated VSTS through a couple of versions and finally want to uninstall the RC1 to install VS 2005 Pro (RTM).  Ran the uninstall tool a few times (reboot included), but I keep getting a failure only on two items-- any ideas Microsoft SQL Server 2005 Express Edition CTP The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is :Failed to read property "InstallIds" {"MachineCon ...Show All

• Tommi Pitkala can database name be assigned as a variable?

  I need to have a query like below to run to select all the fields from different databases that each database have a table named 'table1' select * from test...table1 select * from test1..table1  I have the following code sample: declare @dbname varchar(50) set @dbname='test' select @dbname select * from @dbname..table1 However I received the error messge when I ran this code. Can anyone help to resolve this   Thank ...Show All

• KurtD Remote Connection to SSIS

  Hello. I am trying to remotely connect to SSIS from my PC using windows authentication in SQL mgmt studio and I keep getting the following error message: --------- Cannot connect to <server> Additional Information: Failed to retrieve date for this request. (Microsoft.SqlServer.SmoEnum) Connect to SSIS service on machine "<server>" failed: The RPC server is unavailable. --------- I do not get the ...Show All

• VolkerWill how to solve Syntax error or access violation?

  Hi, any one can help me to solve this problem i run sql statement in RS to get the dataset i want. but it show me this error. below is the sql statement that having error (1). --------------------------------------- SELECT MAX(Weekday) AS Mweekday, MAX(AveScore) AS MScore FROM (SELECT DATENAME(dw, dtAnswer) AS WeekDay, AVG(bScore) AS AveScore FROM Answer WHERE (iMinutes BETWEEN 570 AND 1020) AND ( ...Show All

• Matt Masson Selct from a table and insert in other

  Hi I have these two tables.... CREATE TABLE [dbo].[TELEFONICA] ( [DATA_HORA] [datetime] NULL , [NRTELEFONE] [varchar] (255) COLLATE Latin1_General_CI_AS NULL , [TEMPO_SEGUNDOS] [real] NULL , [TIPO_PABX] [varchar] (2) COLLATE Latin1_General_CI_AS NULL , [LOCALIDADE] [varchar] (255) COLLATE Latin1_General_CI_AS NULL , [VALOR_TEMPO] [money] NULL , [VALOR_TARIFA] [money] NULL , [CLASSIFICA_PABX] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , ...Show All

• bri189a sql expree instalation error

  Hello my big problem for today. I downloaded sql express advanced with reporting services and when I try to install it on step: "sql server database services" I recive the error below: TITLE: Microsoft SQL Server 2005 Setup ------------------------------ SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa' ...Show All

• MyRavi Running query in SQL 2005 stored procedure against table on SQL 2000

  I'm trying to set up Service Broker Services on SQL 2005 x86.  I've got two services set up, and a stored procedure associated with one of them. The stored procedure is going to execute a query against a database on another server running SQL Server 2000 SP3. I can get the stored procedure to activate by using ALTER QUEUE WITH ACTIVATION...EXECUTE AS USER My problem is that the execution of the query within the stored procedure ( selec ...Show All

• paul9955 dumb question...

  After configuring exactly as specified in reporting services custom security, when I try to hit report manager, I keep on getting the error: Invalid URI: The format of the URI could not be determined. It does not redirct me to UILogin.aspx page but forwards me to Pages/Folder.aspx and gives this error. Please if possible let me know ASAP. I have the following in "rsreportserver.config" file <UrlRo ...Show All

• sjb permissions for developers not working after 2005 upgrade

  Prior to our move to 2005...permissions were granted to developers by adding them to the following fixed database roles...db_ddladmin, db_datareader, db_datawriter, and db_securityadmin. They created their objects using 'dbo' as the owner. After upgrading to 2005, suddently they are having difficulty accessing their objects with this same security. Do they need permissions on the dbo schema db_datareader gr ...Show All

• Dinesh.s SQL Server Cluster on SAN storage

  What if any effect does it have on SQL Server performance to have the database spread across several drive letters (LUNs) on a SAN as opposed to having it all reside on a single drive letter. I have heard that the OS can take advantage of the multiple data paths even when the data will all end up on the same spindle and would like some other opinions on the matter. Hi... If I would make the work to split up the DB files onto severa ...Show All

• Leoyoo Can Object Explorer filter on databases?

  The object explorer filter works fine at the database level, but I'd love to be able to filter out the hundreds of other databases on my dev server and see only the one I'm currently working on. Is this possible To my knowledge, if the filter button does not become enabled on a particular collectio node in Object Explorer then NO. If you find otherwise, please post it. Fil ...Show All

• UserVBA Can OWC 11 work with SSAS 2005 cubes?

  Office Web Components 11 problem with SQL Server 2005 Apr 05 CTP Can OWC 11 work with SSAS 2005 cubes When using the Business Scorecard Manager 2005 builder   - added a Report View - set the data source for the OWC pivot table (Used the MS Ole DB provider for Analysis Services 9.0 provider) - Test connection succeded, but cannot get a listing of the cubes under "Use Data from" Cannot get the dimension & measures in the Field list The P ...Show All

• Blacata Gantt chart in SQL reporting service

  Hi all, I need creat a gannt chart for project server report in SQL reporting service. Is somebody know some good third party tool can help to implement or how to creat by hand Thanks in advance! I downloaded the Dundas Chart for Reporting Services and try to create a Gantt chart. I found it's very difficult to do, as there're many settings on it. Is there any tutorial provided Thanks! ...Show All

• Langoti EXCEPTION_ACCESS_VIOLATION when installing June CTP

  Hi - I'm trying to install June CTP on Win2k3 SP1. Setup failed when trying to start services for configuration. In log files I found the following Computer type is AT/AT COMPATIBLE.                                            &nb ...Show All

• BlueJay07 SMO and Thesaurus

  Hi Is there a way to manipulate the thesaurus files using Sql Server 2005 SMO Craig No, SMO does not support changing these files (I suppose you refer to FullText). ...Show All