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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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