Hello, I have successfully set up linked server from sql server 2005 (sp2) to a lotus notes database ( using NOTESSQL ver 8.0 ) and can query the...
Hello, I migrated one of our main databases from sql 2000 to sql 2005. This query worked well in sql 2000 but fails in 2005 ( giving the error NAME...
In report builder , is there an option to show the page numbers on each page in the report generated. There is no report header and footer options as...
Hi, In reporting services , Is there an option to avoid drill thru when the value of the column is zero. Thanks, Shivi
Hi, I am creating a Matrix report and I need to perform few calculations on the columns that are dynamically created....
Hi, When the report is exported to excel, data appears in different sheets with the default sheet names - Sheet1, sheet 2….. But I need the...
Hello, I have a simple report which displays the values from a sql server table thru reporting services. We have used a 'table' report item. One...
Hello, I am trying to import a text file to sql server. Flat file has date, text and int columns. There is an erroneous row where the text qualifier...
I have 2 issues when using reporting services 1) Intermittently I get memory error Event code: 3005 Event message: An unhandled exception has...
Hello, In my report I am getting the 'FROM' date and 'TO' date as parameters .Is it possible to validate the 'TO' date to check if it is always...
Hello, We need to create a report which has many sub reports as follows 1) Get the customer and the bill date as a parameter 2) report 1 should...
We have a database that contains very confidential information and only 2 users in our company are allowed to view the data. Even the system...
I am new to reporting services. We have installed 4 sql 2005 servers and I have removed the following new logins created by the default set up....
When using the query select user , in one sql server it gives the 'user name' and in another it gives 'dbo' for the same user with same permissions....
Is there a way to find the maximum number of SERVER license available and the number of license that has already been used from a SQL SERVER...
Hi, There are 2 DTS packages that uses different source tables from sql servers and Oracle databases to populate few tables in one destination sql...
Hi, When I browse a table using enterprise manager that has TEXT column, I can see only few rows remaining rows are displayed as <long text>. But...
One of the applications is throwing below error [sqlserver 2000 driver for JDBC ]The requested instance is either invalid or not running User is...
In SQL server 2000, I want to change the owner of few userdefined DATATYPEs to 'DBO'. At the moment they are owned by one of our developers.Because...
Hello, My request is similar to the one in the forum link given below http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=7090 My...
Separate names with a comma.
