Error message while implementing mirroring between two databases on separate servers
I’ve attempted to implement mirroring between two databases on separate servers. The database names are exactly the same but I’ve been receiving the following error: Alter failed for Database ‘databasename’. (Microsoft.SQLServer.Smo) An exception occurredwhile executing a Transact-SQL statement or batch. (Micrsoft.SqlServer.ConnectionInfo) The remote copy of database “databasename” does not exist. Check the database name and [...]

Answer Question   |  November 25, 2008  7:57 PM
Database mirroring, SQL Server databases, SQL Server errors

Accessing a mirror database without main database failover
How can I access my mirror database on a SQL Server without a main database failover?

Answer Question   |  November 25, 2008  7:53 PM
Database Failover, Database mirroring, Failover, Mirroring, SQL Server database

Hiding Columns in Report in SSRS
How can I hide or show columns based on a parameter in SQL Server Reporting Services.

Answer Question   |  November 21, 2008  8:51 PM
SQL Server Reporting Services, SSRS

Backing up and copying a database across SQL Servers
I have SQL Sever 2005 on both servers A and B, although I do not have SQL Studio Manager on server A. I would like to backup a SQL database from server B onto server A, and then copy it over to server B and restore it to the same database. How would I go [...]

Answer Question   |  November 21, 2008  8:05 PM
SQL Server 2005, SQL Server backup and restore, SQL Server databases

Adding columns and updating a SQL table in a reporting database-
My SQL table contains about 80 columns; it is a reporting database, so I update this table data daily from an application database. I need to add 20 more columns, but when I add for the present job, it is not completing. The present job logic is using a permanent table to get all the [...]

Answer Question   |  November 21, 2008  8:01 PM
SQL Server database, SQL Server tables, SQL tables

Reducing CPU usage on a SQL Server application
I have Windows Server 2003 and with SQL Server 2005 installed. I run my timesheet software on that SQL server, but CPU usage reaches 70% to 80% when the program is running on many consoles on the client side. Is there a solution to reduce CPU usage?

Answer Question   |  November 21, 2008  4:28 PM
CPU usage, SQL Server 2005, SQL Server performance, Timesheet software, Windows Server 2003

How to schedule SQL query to run in Microsoft SQL Server
I have a query that I want to automatically schedule to run daily. How do I do this?

Answer Question   |  September 17, 2012  4:19 PM
Automated SQL Query, Microsoft SQL Server, Scheduled Tasks, SQL Query

ReportServerService restarting after app domain cant unload
SQL Server Reporting Services (MSSQLSERVER) service terminated unexpectedly. We are rs2005 Version 9.00.3239.00. What is causing this error to happen when in the ReportServerService_Main log there are 11 attempts to unload the app domain from 14:16:18 to 14:19:04 and then this error => e ERROR: Unable to unload app domain, terminating process and the ReportServerService [...]

Answer Question   |  November 20, 2008  9:14 PM
Reporting Services 2005, SQL Server 2005, SSRS 2005, SSRS reports

SSRS Memory Performance
Microsoft SQL Server Reporting Services Version 9.00.3239.00 We are experiencing problems with memory and other performance related issues. This is a scaled out deployment with ssrs installed on 2 server web farm (used to be 3) with windows 2003 sp2, 32GB RAM. Customers run 100s of subscriptions (some quite long running) and we are running [...]

Answer Question   |  December 2, 2008  9:03 PM
Microsoft SQL Reporting Services, Reporting Services 2005, SQL Server 2005, SSRS 2005, SSRS Errors, SSRS Performance, SSRS reports

deployment
While running the setup on client machine, An error Number 5 occurred telling – “An error has occurred while establishing a connection to the server. When connecting to SQL server 2005., this failure may be caused by the fact that under default settings SQL server does not allow remote connections. (Provider: Named pipes provide, error:40 [...]

Answer Question   |  November 20, 2008  1:58 PM
SQL error messages, SQL scripts, SQL Server 2005

Two programs with separate SQL Databases
I have one program that uses an SQL database and I want to install a different program that also uses an SQL database on the same machine. Will this cause a problem? Why or why not?

Answer Question   |  November 21, 2008  11:07 PM
Database, SQL, SQL Database

Limit SQL Admin Access to a single DB
I need to set up admin access on a MS SQL server but limit the access to a particular db.

Answer Question   |  November 21, 2008  10:09 PM
SQL 2005 admin, SQL Security

Improving the performance of a SSRS report in SQL Server 2005
How can I improve the performance of a SQL Server Reporting Services (SSRS) report in SQL Server 2005?

Answer Question   |  November 19, 2008  7:13 PM
SQL Server 2005, SQL Server performance tuning, SQL Server Reporting Services

Error message while restoring the a SQL database onto a mirror database
I took a backup of my main SQL database, and I have created a new database with the name of MirrorDB. When I tried to restore the main database with NORECOVERY, MirrorDB is constantly listed as “Recovering,” and it won’t stop. I am getting a message that it is in the middle of the restore [...]

Answer Question   |  November 21, 2008  7:12 PM
SQL Server database, SQL Server restore

Configuring a password message prompt on SQL Server 2000
On SQL Server 2000, how can I make it so that the server will prompt me for a password when I am click on my database through Enterprise Manager?

Answer Question   |  November 21, 2008  7:09 PM
Enterprise Manager, SQL Server 2000, SQL Server permissions

Error message in the Copy Database Wizard in SQL Server 2005
I am attempting to make a copy of a database using the Copy Database Wizard in SQL Server 2005, but I am receiving the following error: TITLE: Copy Database Wizard —————————— The action you attempted to perform on a remote SQL Server instance failed because the action requires a SQL Server component that is not [...]

Answer Question   |  November 19, 2008  3:15 PM
Copy Database Wizard, SQL Server 2005, SQL Server errors

Testing when primary and mirror SQL Servers are the same
My primary SQL Server and mirror SQL Server are the same. Is this allowed for testing?

Answer Question   |  November 19, 2008  3:12 PM
Mirrored Server, SQL Server, Testing

Advantages and disadvantages of certain SQL commands
Where can I find information about the advantages and disadvantages of using SQL commands like BCP, BULK INSERT, SELECT INTO, etc.?

Answer Question   |  November 19, 2008  3:08 PM
SELECT statement, SQL commands, SQL Server

Installing SQL Server 2000 Enterprise Edition on Windows XP
When I try to install SQL Server 2000 Enterprise Edition on Windows XP Professional Edition, it is giving me an error message that says my operating system is not supported. How can I install SQL Server 2000 Enterprise Edition on Windows XP Professional Edition?

Answer Question   |  November 19, 2008  3:00 PM
SQL Server 2000, SQL Server installation, Windows XP Professional

Comparing views, user-defined functions and stored procedures in SQL
How do views, user-defined functions (UDFs) and stored procedures work in SQL, and what conditions are there on their usage?

Answer Question   |  November 19, 2008  2:55 PM
SQL Server stored procedures, SQL Server views, UDF