Accessing SSRS from a Web server
We have a Web server at our collocation site with public access. On the server, there is a simple menu with links that call SQL Server Reporting Services. We also have another server — with SQL Server 2005 — that contains our database and reporting services. This one is only on the internal network — [...]

Answer Question   |  July 9, 2009  3:22 PM
SQL Server 2005, SQL Server Reporting Services, SSRS, SSRS Access from a Web Server, VPN

Mirroring from a production environment to a DR environment
I have a production environment and a disaster recovery environment and each of them have two SQL 2005 servers in a cluster. We have two LANs — the first one is our standard/everything LAN and the second is a Service LAN. We are looking to mirror from our production environment to our DR environment. Is [...]

Answer Question   |  July 9, 2009  3:03 PM
Disaster Recovery, Production environments, SQL Server 2005, SQL Server 2005 mirroring, SQL Server backup and restore, SQL Server Mirroring

Data integration
I want to import a table from dbase III to Sql server 2005. I also want to automate this process and run it after ever one hour. Is there a simple way to do this task.

Answer Question   |  July 7, 2009  4:10 PM
Data integration, dBASE III, Importing dBASE to SQL, SQL Server 2005

Issues rebuilding system database on SQL Server Express 2005
I am having some trouble rebuilding the system databases on my SQL Server Express 2005 instance. While I have had a total system failure, the backups have been good. I have restored the operating system but obviously there are no SQL system databases present (they were open at the time of the backup). So now [...]

Answer Question   |  July 7, 2009  2:32 PM
SQL Server 2005, SQL Server database, SQL Server databases, SQL Server Express, SQL Server Express 2005

Deadlock issue in SQL Server 2005
I have encountered a deadlock issue in <A href=”http://searchsqlserver.techtarget.com/topics/0,295493,sid87_tax301323,00.html”>SQL Server 2005</a>. According to the trace flag 1204 report, the following two queries are causing the deadlock: 1. Simple insert statement INSERT INTO TABLE1 (FIELD1, FIELD2, FIELD3) VALUES (@INTVAL, @NTEXTVAL, @CHARVAL) – Provide IX lock 2. Simple select statement with READPAST SELECT FIELD1, FIELD2, FIELD3 FROM [...]

Answer Question   |  July 24, 2009  5:30 PM
SQL Server 2005, SQL Server 2005 error messages, SQL Server errors, SQL Troubleshooting

Error backing up with SAP transaction DB13
The following error message occurs when I attempt to backup with SAP transaction DB13: ***************************** SQL Job information ****************************** Jobname: SAP CCMS Full DB Backup of master,RPD [20090620094326-6-094326] Type: TSQL DB-Name: RPD For Run: 20090620 09:43:26 **************************** Job history information ***************************** Stepname: CCMS-step 1 Command: declare @exeStmt nvarchar(2000) exec rpd.sap_backup_databases @dbList= “master,RPD”,@r3Db=”RPD”,@bDev=”R3DUMP0″,@expDays= 27,@jobName= “SAP C [...]

Answer Question   |  July 6, 2009  5:21 PM
DB13, NTBackup, SAP Transactions, SQL Server 2005, SQL Server 2005 backup, SQL Server backup

Restoring a deleted table in SQL Server 2005
How do I restore a deleted table in SQL Server 2005?

Answer Question   |  July 15, 2009  4:51 PM
SQL Server 2005, SQL Server Management, SQL Server tables

Is it possible to connect from the SSIS Analysis Services task to SQL Server 2000 Analysis Services?
Using the Analysis Services Processing Task in SSIS 2005, we are trying to connect to SQL Server 2000 Analysis Server cubes. While we are able to successfully create an Analysis Services connection, when we try to configure the task and specify the connection created above, we receive the following error: TITLE: Analysis Services Processing Task [...]

Answer Question   |  July 6, 2009  4:41 PM
SQL Server 2000, SQL Server 2005, SQL Server Analysis Services, SQL Server Integration Service

SQL Server 2005 Processor Licence
Hi All, Just wondering what happens when an additional licence is purchase for a SQL Server 2005 that is currently running with one processor. IE. How do we purchase the processor licence for our clients, what to do when we purchase this licence? Thanks in advance.

Answer Question   |  July 6, 2009  6:39 AM
Microsoft licensing, Processor Licence, SQL Server 2005, SQL Server licensing

Increasing Processors of SQL Server 2005 in VM
Hi, We are about to increase the number of processor on a Virtual Machine from 1 to 2 for one of our clients, will this affect the SQL Server 2005 which installed on the Virtual Machine, just wondering if are any issues to look out for, and if anyone has done this before? Thanks.

Answer Question   |  July 6, 2009  6:12 AM
SQL Server 2005, Virtual Machines

Problem with Download-only Articles in New Subscription of Merge Replication
Hi, I have a Publication in a SQL Server 2005 Merge Replication with Mobile Devices. To explain my problem follow this example: I have an Article in Download-Only with 100 rows. When I start new subscription I look, in the Replication Monitor, that Process start with “Insert 300 rows” for this article and end with [...]

Answer Question   |  June 29, 2009  3:38 PM
Merge replication, SQL Server 2005, SQL Server 2005 merge replication

Which version of SQL will work best?
We have a small but critical application that is accessed by about 30 – 40 users on our network. We want to set up a SQL environment to run the database, but the application accessing the data is locally installed on each users machine. Users will access the db over our network using an ODBC [...]

Answer Question   |  June 29, 2009  5:40 AM
SQL 2005, SQL Express 2005, SQL Server 2005, SQL Server Express

Migrate User & Permissions SQL 2000 to SQL XXXX
Hello, I need to a new windows server, but too install MS SQL Server 2005. Who know or have a code to do this job. Tank you so much.

Answer Question   |  June 25, 2009  4:26 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server migration, SQL Server permissions, SQL Server User Accounts, SQL Server user permissions, Upgrade from SQL Server 2000 to SQL Server 2005

Failover issues in a SQL Server 2005 mirrored database
I have a SQL Server 2005 mirrored database with a witness. Everything seems to be working OK but I am having problems in the instance a failover occurs. Once the primary server goes down, my access to the database continues normally once both servers are back up and running and the old mirror is left [...]

Answer Question   |  June 25, 2009  4:23 PM
Database mirroring, DSN, Failover, SQL Server 2005, SQL Server 2005 connectivity, SQL Server Database Mirroring

Adding processor to SQL Server 2005
Hi All, We are about to add an additional processor to one of our SQL Server 2005, just wondering if there are any downside to doing this and if this a low risk task to do, i.e. we won’t encounter any problem after doing this? Thanks.

Answer Question   |  July 2, 2009  3:45 AM
CPU, Processors, SQL Server 2005

SQL script to disable views after a demo period.
Hi, I have a sql view that I created for someone on a test basis. I want to create something (stored procedure, trigger, etc) that will delete or disable this view after a 30 day trial period. I prefer to make the view unvisible even to the “sa” administrator so that the view can not [...]

Answer Question   |  June 23, 2009  3:25 PM
SQL, SQL scripts, SQL Server 2005

Retrieving System information
I need to retrieve logins and users for all databases by server for SS2000 – 08. Querying the system tables sysservers, sysdatabases, sysloginns and sysusers provide the information. But how do I collect all that information with one query hopefully that I can run against all serves in the enterprise.

Answer Question   |  June 18, 2009  5:53 PM
SQL Server 2000, SQL Server 2005, SQL Server 2008

Are there any specific considerations we should be aware of as we attempt to migrate applications to a Hyper-V virtualized machines?
We have major applications (Exchange 2007 and SQL 2005) that we have in a mission critical configurations “clustered.” Are there any specific considerations we should be aware of as we attempt to migrate these applications to a Hyper-V virtualized machines? Are there any resources available online for this? This question is from the 5/14 Microsoft [...]

Answer Question   |  June 18, 2009  2:02 PM
Exchange 2007, Hyper-V, Hyper-V Virtualized Machines, Microsoft virtualization, Microsoft Virtualization Chat 5/14, SQL Server 2005, Virtual Machines, Virtualized Applications

MS SQL SERVER (BKUPEXEC) Services wont start
Hi ALL, Background: Windows 2003 Server returned the error missing or corrupted file after the server was found OFF due to possible power problems (Server is on a UPS). Ran a CHKDSK on the server and it fixed the missing or corrupted file problem and server now up and running. Is seems that my SQL [...]

Answer Question   |  July 13, 2009  2:22 PM
CHKDSK, MSSQL$BKUPEXEC, SQL Server 2005, SQL Server backup, SQL Server Services

Transaction Log – SQL Server 2005
How do i find out what transaction log file was last applied to a database?

Answer Question   |  June 23, 2009  4:11 PM
Backup & recovery, SQL Server 2005, SQL Server backup, SQL Server transaction logs