SQL client number
If I have 500 clients in an environment, does that mean I need 20 servers with SQL 2005 Enterprise–each with only 25 client availability?

Answer Question   |  August 6, 2008  4:48 PM
SQL Server 2005

Creating Alert/Email when Automatic Failover Occurs In Sql-Server 2005
Hello All, I want to send email alert when aotomatic failover occurs in in Sql-Server 2005. I mirrored my database using High Safety with Automatic Failover option.

Answer Question   |  August 6, 2008  6:34 AM
Automatic failover, Database mirroring, High-Safety Mode, SQL Server 2005

Limitations on databases per instance in SQL Server 2000 and SQL Server 2005
Is there any limitation on the numbers of databases per instance that can run in either SQL Server 2000 or SQL Server 2005?

Answer Question   |  August 4, 2008  2:26 PM
SQL Database, SQL Server 2000, SQL Server 2005

Setting the ODBC in SQL Server 2005
I use SQL Server 2000, and I am in the process of upgrading to SQL Server 2005. However, when setting the ODBC, the database option for SQL Server 2005 does not appear. Is there something I have to set first before the ODBC?

Answer Question   |  August 4, 2008  2:23 PM
ODBC, SQL Database, SQL Server 2005

Giving login and database permissions to a group in SQL Server 2005
I am running SQL Server 2005 Workgroup Edition on Windows Server 2003 Standard Edition. I have created a global security group called ACSSales and I would like to give login and database permissions to this particular group, rather than individual user permissions. How do I do this?

Answer Question   |  August 4, 2008  2:20 PM
SQL Server 2005, SQL Server permissions, Windows Server 2003

rtf text in SQl Server
We need to migrate a column of rtf-encoded text in SQL Server 2005 to a plain text field in a different table. Using Access, I can save the encoded text in a .rtf file, then open the file in Word and save it as a .txt, then read the .txt back into Access – Word [...]

Answer Question   |  July 30, 2008  8:22 PM
Microsoft Access, Microsoft Word, Rich text, SQL Server 2005

SQL Server 2000 to SQL Server 2005 migration
Hi, I am pretty new to the SQL Server DB. We are working on a project where in the db is migrated from SQL Server 2000 to SQL Server 2005. I was told that the migrated databases will consume more disk space on SQL Server 2005. Is that true? If so, what is the reason [...]

Answer Question   |  July 29, 2008  6:36 PM
SQL Server 2000, SQL Server 2005, SQL Server migration

Explaining features in SQL Server 2005
I have a presentation to give on business intelligence using SQL Server 2005. Can you assist me by explaining the features Data Integration, Data Analysis, Data Reporting and Data Mining in SQL Server 2005?

Answer Question   |  July 28, 2008  3:42 PM
Data analysis, Data integration, SQL Server 2005

Copying databases in SQL Server 2005 and SQL Server 2008
In SQL Server 2005 and SQL Server 2008, the CREATE DATABASE function creates a new database and copies all the tables that are present in the model database. Is there a function where I can do the same from a template database?

Answer Question   |  July 28, 2008  3:39 PM
SQL Database, SQL Server 2005, SQL Server 2008

Saving the results of a SQL Server 2005 table query in a XML file
I have data in a table on a SQL Server 2005, and I need to query this table and save the results in a XML file that conforms to a given XSD. Is there an easy way of doing this?

Answer Question   |  July 23, 2008  5:08 PM
Query, SQL Query, SQL Server 2005

export sql server 2005 to dbf
I have problem with exporting a table to a dbf format file in sql server 2005 Has anyone done it before? Thanks!

Answer Question   |  March 21, 2011  2:16 PM
SQL Server 2005

How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.
How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.

Answer Question   |  July 21, 2008  6:06 AM
SQL Mail, SQL Server 2005, SQL Server Integration Services, SSIS

CASE sintaxis error in SELECT
In the middle of a large storage procedure I have a working SELECT 01 (see below) which at a couple of points uses CASE statement. I need to expand the most inner CASE to get SQL Server check for several values instead of one. Currently CASE I am talking about looks like (it is in [...]

Answer Question   |  July 19, 2008  7:46 PM
CASE statement, SELECT statement, SQL Server 2005, T-SQL

Error in the installation of SQL Server 2005 (64-bit)
We are trying to upgrade our installation to SQL Server 2005 (64-Bit) Edition, but we cannot get past the following error reported in the Event Log: *********************************** Event Type: Error Event Source: MsiInstaller Event Category: None Event ID: 11706 Date: 17/07/2008 Time: 14:01:43 User: KELTONJames.Marley Computer: SQL-SRV-1 Description: Product: Microsoft SQL Server Native Client — [...]

Answer Question   |  June 1, 2010  6:45 PM
Event log errors, SQL Server 2005, SQL Server 2005 (64-bit)

SQL Server
What is a tempDB in SQL Server?

Answer Question   |  July 19, 2008  8:50 AM
SQL Server 2005, TempDBs, Visual Studio 2005, Windows XP

Password policies for SQL Server 2005 (Yukon)
What are the password policies within SQL Server 2005 (Yukon)?

Answer Question   |  July 17, 2008  4:44 PM
SQL Server 2005, SQL Server permissions, Yukon

How do I write the code to connect an .aspx webform to a MS SQL server and database
This was done in VS 2008 the web forms are registration and log in forms with aspx controls. I created the database and the tables ( but am having issues with the constraints for 3 columns). I am trying to find out how to connect the 2 and where would I put the code. I [...]

Answer Question   |  July 17, 2008  1:47 PM
Server errorlog, SQL Server 2005, SQL Server errors, VS 2008

SQL Server 2005 Reporting Services (Web Service)
I have installed SQL Server 2005 reporting services, its works fine but the web service is not working. my web service is running under network service and its as priviledge to run. When i browse it after a few minutes it says page cannot be displayed. Any help would be appreciated.

Answer Question   |  July 18, 2008  8:48 PM
M-Business Anywhere, SQL Anywhere Studio, SQL Server 2005, SQL Server Reporting Services

Running a lengthy query on SQL Server 2005
We are running SQL Server 2005 and Windows 2003 Server. I ran a query in SQL on a PC with one dual code processor and 4GB and it took six hours. However, we ran the same query in SQL on a brand-new server that has 4 quad core processors and 32GB of RAM, and it [...]

Answer Question   |  May 28, 2009  8:21 PM
Query, SQL Server 2005, SQL Server performance, Windows Server 2003

SQL Server 2005 Maintenance Plans – overwrite vs. append
I am trying to create a maintenance plan, but when I use the backup database widget, it defaults to ‘append existing…’. I want ‘oversrite existing…’. Can anyone help me find where that is set? Thank you Carla

Answer Question   |  July 16, 2008  3:50 PM
SQL Server 2005, SQL Server administration