Creating Alert/Email when Automatic Failover Occurs In Sql-Server 2005 and 2000
HI]] I want to send email alert when aotomatic failover occurs in in Sql-Server 2005/2000.  Specs: Active/Active  NO DR solutions

Answer Question   |  August 3, 2010  8:07 PM
Automatic failover, SQL Server, SQL Server 2000, SQL Server 2005

Transactional Replication: Publisher & Subscriber size mismatch
Hello, We have implemented transactional Replication[Push] on our SQL Server 2005 DB. The Distributor is the Publisher. The publisher is on one server and the subscriber on another. After synchronizing the DB, the tables count and the no of recs per table are identical on both the servers, however the actucal db size on the hard [...]

Answer Question   |  August 5, 2010  12:26 PM
Hard drive space, SQL 2005, SQL Database, SQL Server, SQL Server 2005, SQL Server 2005 Database

SQL-Using count and inner join in a single query
Hi Trying to retrive a report from the DataBase using left join on two tables. To get the count of resultant table, I’m using count. But the output shows error. If I comment count statement then the query executes successfully. I feel there is some error in the syntax of the count that I’m using. [...]

Answer Question   |  July 27, 2010  11:13 AM
SQL 2005, SQL 2005 Database, SQL generated files, SQL Query, SQL Server, SQL Server 2005

Duplicate SQL Server 2005 database
What is the best way to duplicate a SQL Server 2005 database to another server as a standby machine? Can I do this with another installation and some scripting? I have a separate box with SQL 2005 already installed. Can I backup and restore from one machine to the other using scripts and no human [...]

Answer Question   |  July 26, 2010  1:59 PM
Backup, Backup and restore, SQL Server 2005, SQL Server 2005 backup, SQL Server 2005 Database

SQL SERVER 2005 Security use Kerberos instead of NTLM
How can I setup sql server 2005 to use kerberos authentication instead of NTLM?

Answer Question   |  July 27, 2010  8:53 PM
Kerberos, SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server authentication

Help upgrading from SQL Server 1997 to SQL Server 2005
When upgrading from SQL Server 97 to SQL Server 2005, what needs to be done? Can I restore 97 backups to 2005? Do I need to install any other software? Is this an easy process? We have 6 databases with about 300 GB of data currently.

Answer Question   |  July 23, 2010  8:01 PM
SQL Server, SQL Server 2005, SQL Server 2005 upgrade, SQL Server migration, SQL Server Upgrade

SQL Server 2005
What exactly does SQL server05 does and if i am looking out for a job in this field is there any exam which i have to give. Iam new in this and have less knowledge about sql. Plz help.Thank you.

Answer Question   |  July 23, 2010  7:04 AM
SQL, SQL Server, SQL Server 2005, SQL Server career advice, SQL Server certifications

error in SQL workbench
ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 2 SQL Statement: CREATE  TABLE `cape codd`.`SKU_DATA` ( )   Does anyone know how to fix or workaround this? thanks Whitney Ferrante

Answer Question   |  July 21, 2010  1:29 AM
MySQL, SQL, SQL error messages, SQL Server, SQL Server 2005, SQL Syntax

cannot connect vb program with sql server 2005 in local machine
the simple program of fetching the data of table through vb.net program. i am retriving the data into DatagridView . i am writing following String str for connection :  Dim str As String = ” Data Source=COMP1SQLEXPRESS ; Initial Catalog=Atuldb; User Id=COMP1comp11;Password= ” my database name is “Atuldb”, I am using SQL SERVER MGT STDIO. [...]

Answer Question   |  January 21, 2012  2:34 PM
SQL Server, SQL Server 2005, SQL Server Management Studio 2005, VB.NET 2008, Visual Basic, Visual Basic .NET, Visual Basic 2008

Read Excel from Sql Server 2005/2008 SQLEXPRESS
How to read the excel data’s from Sql Server 2005/2008 SQLEXPRESS

Answer Question   |  July 20, 2010  11:30 AM
SQL Express, SQL Server 2005, SQL Server 2008, SQLEXPR

Calling stored procedure in a database to query data in another database
Hello, I am writing a stored procedure that will query data from another database, but the database name is variable. Do I have to use a dynamic query? We dont want to use dynamic queries because of performance loss. But is there a way to do it without a dynamic query? Example GetData ‘some_remote_db_name’; and [...]

Answer Question   |  February 14, 2012  3:20 PM
SQL 2005, SQL Query, SQL Select, SQL Server, SQL Server 2005, SQL Server 2005 administration, SQL Server stored procedures, T-SQL

Migrating from Microsoft applications to Oracle
How can I easily convert my SQL 2005 databases to Oracle’s latest iteration? We are moving away from Microsoft applications and want to migrate to Oracle. What do I need to do to prepare?

Answer Question   |  July 15, 2010  6:10 PM
Oracle Application Server, SQL 2005 Database, SQL Server 2005, Windows Application Server

moving an existing active/passive 2005 SQL cluster onto an existing active/active SQL 2008 cluster.
I have been tasked with moving an existing active/passive 2005 SQL cluster onto an existing active/active SQL 2008 cluster. The active/active 2008 SQL cluster consists of two nodes that are running Windows Server 2008 Enterprise edition. These nodes connect to an EMC SAN which has been operating flawlessly for about one year. The active/passive 2005 SQL [...]

Answer Question   |  July 15, 2010  3:33 PM
Active/Passive SQL Server 2005 Cluster, Cluster management, SQL Server, SQL Server 2005, Windows Server 2008

SQL server SP3
Security Update for SQL Server 2005 Service Pack 3 (KB970892) .. i cant get this update to work on my comp..soemthing about hotfix.exe error

Answer Question   |  July 13, 2010  12:21 AM
SQL Server 2005, SQL Server 2005 Service Pack 3, SQL Server 2005 SP3, SQL Server Updates

SQL Server view column conversion problem
I have a view with a column SWID. The source column is Varchar while in the view creation it has been cast to INT. The source table has a non-numeric value “CITY”, while during the view creation, this record have been filtered out. When I select all records from the view, it’s working well. However, when [...]

Answer Question   |  July 7, 2010  5:12 PM
Data conversion, SQL Server 2005, SQL Server Query, SQL Server View

Web based application not uploaded ON SERVER sometimes
We are having the Web based software which is uploaded on our server on technology of front end: PHP & backend: MS SQL Server 2005. Some times this application can not uploaded, so plz give the solution to solve this problem. Actually this application is developed by third party and they update this application remotely [...]

Answer Question   |  July 14, 2010  7:44 AM
Network applications management, Networking services, PHP, SQL Server 2005, Web application development, Web based Applications

I’m interested in creating a web form that will deposit information into a SQL Server database.
I’m interested in creating a web form that will deposit information into a SQL Server database. What’s the best way to do this and what software exists to accomplish this? I have experience creating Access forms that connect to a SQL Server back end.

Answer Question   |  July 1, 2010  12:12 PM
Forms Design, SQL Forms, SQL Server 2005, SQL Server 2005 Database, T/SQL

Can anyone tell me the best way to query Active Directory in SQL?
Can anyone tell me the best way to query Active Directory in SQL? I’m using SQL Server Management Studio Express and want to add the LDAP server for AD as a linked server to query. I’m not sure what the best way to do this is.

Answer Question   |  June 22, 2010  12:15 PM
Active Directory, Active Directory query, LDAP, SQL Server 2005, SQL Server Management Studio 2005, T/SQL

SQL Server 2005: Improving performance of Multiple Databases & LUNS
I am looking at ways to improve performance of our databases. We have 4 large databases (ranging between 50gb and 200gb each) on a single SQL Server 2005 Cluster. Currently they are split 2 on one LUN and 2 on another. I am looking at ways to improve the IO performance of the databases as [...]

Answer Question   |  June 22, 2010  5:25 PM
Cluster management, LUN, RAID 10, SQL Server 2005, SQL Server clustering, SQL Server performance, Storage in 2010

Improve performance on Insert rows into DB2 400 table from SQL server
Using INSERT OPENQUERY and a linked server on SQL Svr 2005, to insert rows to DB2 table on AS400. To a local AS400 runs very quickly. Performance on a remote 400 is very slow, and seems to be out of proportion to the change in line speed. Is there anyway to improve the performance for [...]

Answer Question   |  October 29, 2010  2:58 PM
AS/400, DB2/400, Linked servers, SQL Server, SQL Server 2005