Answer Questions

• Don Cameron Querying tables without schema prefix

  Hi all, I'm using SQL Server 2005 Express Edition, and I have restored a database that was using SQL Server 2000 previous. All of that went fine - sprocs and tables/data all made it. However, when viewing the tables in the object explorer in the management studio, all the tables are prefixed with the schema name (testuser - so the table names are like: testuser.pn_user). Now, all of the code I have queries the tablename only without prefixing testuser to it - but this doesn't work anymore (invalid object name.) I've tested, and if I prefix the table names in my code with "testuser.", it starts working again, but would rather avoid doing this. Is there something I can do within Sql Server I've made the "testuser" accou ...Show All

• Sébastien Nunes No available values in Report Builder parameter

  In a Report builder report I have runtime prompt filter on a field. But I am not able to see the available values in the dropdown for this field. My filter is on a "New Field" with the formula : IF(LENGTH(FieldName)>0,FieldName,("Blank")) However if my filter is on the FieldName directly and not on the New Field with the above formula I do get the available values. Is there any way I can get the available values in a dropdown for the New Field True any field which is present in the Model can be shown in the dropdown. I was exploring if a new formula field that is not actually present in the model, might also have 'Available values'.Thanks for your response. ...Show All

• codetale I can't seem to find exactly what my problem is in the following

  I have trying to figure out where the error is exactly. The error message shows a '/' and there isn't one of these in my stored procedure at all The error is: Msg 102, Level 15, State 1, Line 5 Incorrect syntax near '/'. Here is the rather lengthy code. set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo] . [TEST] @StartDate DateTime , @EndDate DateTime AS BEGIN SET NOCOUNT ON ; DECLARE @sql varchar ( 8000 ), @select_clause varchar ( 8000 ), @from_clause varchar ( 8000 ), @gift_clause varchar ( 5000 ), @is_welcome bit , @pckg varchar ( 100 ) declare @bk_id int , @it_id int , @qty int , @desc varchar ( 100 ), ...Show All

• Pisces How To Uninstall MS Reproting Services 2005

  Hi, I'd like to know if there is a documentation on how to uninstall MS Reporting Services 2005.  Currently, SQL Server 2005 and Reporting Services are installed in my box. I'd like to have RS 2005 uninstalled without unistalling SQL Server 2005. Is this possible   Yes, sure. Navigate to the Add/remove Software in the control panel, choose modify SQL Server 2005 installation and deselect the Reporting Services installation. This won’t uninstall the SQL Server, only Reporting Server. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• toddhd What happens at midnight ?

  Everyday at just gone midnight, my MSSQL server won't accept connections. About 25 minutes later, it seems to be OK. There's no third party backup software running on this machine which is MSSQL server aware. Has anyone any suggestions as to why this might be happening The client app trying to use the db reports 17/10/2006 00:02:04 Email2DBServer Cannot open database "Email2DB" requested by the login. The login failed. From OpenLocalDatabase and there's an entry in the event log Event Type: Failure Audit Event Source: MSSQL$EMAIL2DB Event Category: (4) Event ID: 18456 Date: 17/10/2006 Time: 00:02:04 User: NAVIGATOR-BATH\navigator-service Computer: NAVIGAT2A Description: Login failed for user 'NAVIGATOR-BATH\navigator ...Show All

• JoeHand Instances

  How to see the no of instances created for my server. yes. They give the list of sql servers in the list. But what i want is the instances created for my server only. Launch the services console: services.msc - it should list a separate SQL Server service for each instance. You can also check the registry: HKLM\Microsoft SQL Server\Instance Names. Thanks Laurentiu if it is sql server 2005 sqlcmd -L : it will list all the instances in the network , you can identify by machine name what all the instance in your machine for SQL 2000 osql -L ...Show All

• F.Costa Installation Error Sql Express 2005

  When I open the installation, everything is fine. The report says that I do not meet the reccomended hardware requirements, but I checked and I am above the minimum requirements. This is the report: System Configuration Check - WMI Service Requirement (Success) Messages WMI Service Requirement Check Passed - MSXML Requirement (Success) Messages MSXML Requirement Check Passed - Operating System Minimum Level Requirement (Success) Messages Operating System Minimum Level Requirement Check Passed - Operating System Service Pack Level Requirement. (Success) Messages Operating System Service Pack Level Requirement. Check Passed - SQL Server Edition Operating ...Show All

• Chun Siong How to increase SSIS performance

  Hello again, I'll just throw my question: how could I increase SSIS-performance I have a really heavy job with thousands of records my base selection, then I perform some lookups (I replaced most of them by sql) and derived columns (again, I replaced as much as possible by sql). Finally, after a slowly changing dimension task, I do update/insert on a given table. Is there a trick to speed up lookups and inserts (something like manipulating the buffer sizes - just asking). Fact is that I replaced a script task by pure sql-joins and gained 6 of the 12 hours this job took. Any ideas Greets, Tom Hi Jamie, Great, I've read the whitepaper and discovered a lot! Greets, -Tom Tom De Cort wrote: Hello again ...Show All

• GlenAtMotorola The best Data Transformation tool to Update/Insert (EDIT)

  Hello, I have some data coming up from an SQL Server source, I have to add it to another SQL Table on the basis of what destination table already have. For instance, if there is already an entry there for particular record (based on matching primary key value), then I just need to updated 3 columns, otherwise need to insert. The problem is, I know how to do it by using script component, but I am wondering if there is a better tool that saves me writing code Any idea Thanks, Fahad Fahad, If the two tables reside on the same SQL Server or on servers that can see each other you can use plain SQL: Update first: UPDATE TableD SET col1 = TableS.col1 ... FROM TableD INNER JOIN TableS on TableD.pk = TableS.pk WHERE TableD.col1 & ...Show All

• Coroebus How to set a specific font (not family) of a report element ?

  Hi all, I wonder if we can set font of a report element to a specific font, rather than a font family. Like, Arial TUR instead of Arial ...Show All

• Vic02 How to call report via url in RSReportHost.exe

  I am calling my reports via URL, but it presents the report in IE with the url so the users might change the parameters value in IE addressbar. but i see RSReportHost.exe does'nt show the url at all. Is it possible to show or call a report via URL using RSReportHost.exe I am using VS 2003 with SQL RS 2005, i don't have a reportviewer control available to use. Please help guys. Thank you fery much. True. You have different options to address this depending on the security risk. 1. If you think that hacking the report URL goes beyond the skills of your users, you may be fine with the ReportViewer parameter hiding. 2. You can use the user identity (User!UserID) to filter the parameter ...Show All

• TomPearson SQL2005 Performance problem with updating subscribers with identities

  Since we've upgraded to 2005 we've had major performance problems with updating subscriber tables that contain identity PK columns set to manual or auto range management. If a table has identity range management set to 'None' (the "old" 2000 way), the peformance is fine. Below are sample tables: CREATE TABLE [dbo].[ID_RANGE_TEST]( [ID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [DATA] [int] NULL CONSTRAINT [PK_ID_RANGE_TEST] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO CREATE TABLE [dbo].[ID_NONE_TEST]( [ID] [int] IDENTITY(1,1) NOT NULL, [DATA] [int] NULL CONSTRAINT [PK_ID_NONE_TEST] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KE ...Show All

• khs202968 Getting the Location parameters from SSRS 2005

  hi, I am calling the web-service ReportingServices 2005 and for the function GetReportParameters() I am getting all the parameters without any issues.. however I want All the control values (not the defaultvalues)... I tried calling the valid values function .. which is returning null Is there some way I can get them Thanks in advance rohit ...Show All

• ofer ebert Importing related data

  I need to recreate a SQL 2005 db in a SQL 2000 server. So far I was able to recreate database schema, but I don't know how to import the raw data. I tried copy-pasting table data to the new db using SQL Server Management Studio Express, but there's a problem - the identity columns do not retain the correct values. For example: Old db table ID Username ------------- 15 Peter 45 James When pasting the same data to teh new db, I would get this: ID Username ------------- 1 Peter 2 James You can see the ID field values become different (since the ID attribute is an identity and the table in the new db is empty, the db picks the values 1 and 2 for the two records) and now when pasting data into related tables, I get the error because table ...Show All

• Bart1 SQL serveur Express

  I have downloaded SQL serveur express and I can not start the program. I have this error: (see at the end of log file: What can I do 2006-09-21 20:28:11.21 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2) 2006-09-21 20:28:11.21 Server (c) 2005 Microsoft Corporation. 2006-09-21 20:28:11.21 Server All rights reserved. 2006-09-21 20:28:11.21 Server Server process ID is 2456. 2006-09-21 20:28:11.21 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG'. 2006-09-21 20:28:11.21 Server This instance of SQL Server last repo ...Show All