SQL SERVER 2005 Performance Monitoring
Hello, is there a free software tool to monitor sql server 2005 similar to Quest FogLight? Quest FogLight is just too expensive for my budget. I am an independent consultant and I want to be able to monitor my client’s sql server.

Answer Question   |  January 6, 2012  6:40 PM
SQL Server 2005, SQL Server performance, SQL Server Performance Monitoring, SQL Server performance tuning

Procedure cache ratio calculation in SQL Server?
Hi, Does anyone know how to calculate the procedure cache ratio in SQL Server 2005 by selecting specific table in SQL Server? Thanks.

Answer Question   |  February 11, 2010  2:21 AM
SQL Server, SQL Server 2005, SQL Server stored procedures

SQL Server – SSIS
what is SSIs in Sql Server?

Answer Question   |  February 18, 2010  6:03 AM
SQL Server 2005, SSIS

differences between SQL server 2000 & SQL server 2005
Hai  Can any one tell me What are the Main differences between SQL server 2000 & SQL server 2005. Thanks and Regards

Answer Question   |  January 29, 2010  10:21 AM
SQL Server, SQL Server 2000, SQL Server 2005

SQL server STD 05 between Sites
besides buying Enterprise($$$$$.$$), how else can I keep these servers (sych’d, mirrored, ???) via a network link between cities? Server1(win-sql-05)DB <> Server2(win-sql-05)DB

Answer Question   |  February 18, 2010  5:04 AM
sql link sycn, SQL Server 2005, SQL Server 2005 Standard Edition, SQL Server connectivity

Data transfer from DB2 (AS400) TO SQL SERVER 2005
Data transfer from DB2 (AS400) TO SQL SERVER 2005

Answer Question   |  January 25, 2010  11:39 AM
AS/400 data transfer, DB2, DB2 Data Transfer, DB2 to SQL Server Data Transfer, send any detail help please, SQL Server 2005

Restoring Database
I accidentally deleted contents of a table and is now trying to recover the deleted rows.  I do not have a backup (how stupid of me).  I do have a .mdf file, however I believe i copied that file while SQL Server 2005 was running.  Is there anyway to recover this deleted data?

Answer Question   |  January 15, 2010  6:17 PM
.MDF files, SQL Backup, SQL Server 2005

View t-sql SPID is executing
Is there a table that I can query to view what sql statements a spid is running? I do not want to use the dbcc inputbuffer.

Answer Question   |  January 13, 2010  4:20 PM
SQL, SQL Server 2005

Cannot INSERT data into table with identity column
In my program I have an EmployeeRegistry table which holds data of each employee’s work attendance. Every attendance record is uniquely distinguished by an IDENTITY COLUMN called “AttendanceID” which has an IDENTITY SEED of 1 and an IDENTITY increment of 1. However when I try to insert an attendance record to the table via my [...]

Answer Question   |  May 11, 2012  2:54 AM
INSERT statement, SQL Server 2005, SQL Server 2005 Express Edition, VB.NET 2005

SQL Server 2005 error log, could not read information for this log entry
Hi, There is a SQL Server error log entry in the SQL Server 2005 production box with the following.   “Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:”   Has anyone seen anything similar? Does anyone know what [...]

Answer Question   |  January 14, 2010  12:41 AM
SQL Server 2005, SQL Server error logs, SQL Server errors

Access Rights in SQL Server 2005
Hi,  I’m using sql server 2005 and in my application i have 2 DB say A and B , and 2 servers SR1,SR2 and DB A,B and present on both (SR1,SR2).now i want to give access to users entering my DB not to view any of the entries made in the DB, not even the [...]

Answer Question   |  January 7, 2010  6:29 AM
SQL Server 2005, SQL Server permissions, SQL Server User Accounts, Windows Vista

Where can I download SQL Server 2005? All trials are no longer available.
I desperately need to install SQL Server 2005 to learn it for a new job starting monday. Does anyone know where I can download a trial. Thank you tresortx@yahoo.com

Answer Question   |  January 7, 2010  4:21 PM
SQL Server, SQL Server 2005

bcp – clock time meaning
Attempting to BCP a large resultset using a view and the queryout option. I have been playing with the network packet size and the size of the batche using join conditions. When looking at the command line output file. What do the values in “Clock Time (ms.) Total” signify. I am trying to measure the [...]

Answer Question   |  January 6, 2010  3:55 PM
BCP Utility, SQL 2005, SQL Server 2005

Create Excel file on web server by using SQL
How can I create an excel sheet on web server by using a stored procedure in SQL Server 2005. I’m retriving data from sql select query and creating Excel file dynamically on we server of that data using asp.net. But I want to do this with the help of SQL stored prcedure. i.e. In a [...]

Answer Question   |  January 13, 2010  12:02 PM
Microsoft Excel, SQL Server 2005, SQL Server stored procedures

SQL Server Express 2005 Installation Failure
Here is a fix for SQL Server Installtion failure. And a fix for newly installed programs that cause memory faults. I encountered an issue after installing SQL Server Express 2005. Where I get a blue screen with c000021 0xc0000005 this is an install on a Dell PowerEdge 600SC Widows XP SP2. To correct the problem, [...]

Answer Question   |  December 23, 2009  7:07 PM
0xc0000005, SQL Express, SQL Server 2005, XP

32 and 64 Bit SQL 2005 on Same Server
We need to still link to MS Access databases and understand the 64 bit SQL Server does not allow. So, a thought is to have the new 64 bit SQL Server coexist with a 32 bit SQL Server Express instance. The thought is the 32 bit instance will enable linked server access to MS Access [...]

Answer Question   |  December 22, 2009  3:04 PM
MS Access, SQL Server, SQL Server 2005

sql server express 2005 cannot see drive on my server (drive q)
I have installed sql server express on my local computer and now I would like to install it on the server (q). When I go to install it, it is not seeing the q drive. What could be causing this?

Answer Question   |  December 9, 2009  4:50 PM
SQL Server 2005, SQL Server Express, SQL Server Express 2005

Implementing Encrypted SQL Server Database Columns
This is the problem I’m facing: The database (SQL Server 2005) holds more than 5 million customer records. These records contain sensitive credit-card information that must be encrypted. Implementing an application-side encryption solution involves VB6 and .Net technologies. How to achieve a server-side encryption solution that would have minimal impact on performance and business processes? [...]

Answer Question   |  December 7, 2009  10:12 PM
.NET 2.0, SQL Server 2005, SQL Server database, SQL Server encryption, VB6

SQL Server 2005 Performance optimiztion
I have the following setup, would like to know what’s best for log files, data files, indexes, tempdb files. Also, since the server is used solely for SQL 2005 Reporting Services, how many tempdb data files and tempdb log files should I create, also how many userdb data files and userdb log files. Want to [...]

Answer Question   |  December 4, 2009  4:24 PM
SQL 2005 Reporting Services, SQL Server 2005, SQL Server performance, Windows Server 2003

SQL Server 2005 Log Shipping question
I have setup log shipping on our production SQLServer to send the logs to a server I have at my home for a warm backup solution. The process seemed to work but then I had a problem on my secondary server – it seemd to stop working for a period of 2 weeks (I dont [...]

Answer Question   |  August 2, 2010  9:27 PM
Log Shipping, SQL Server 2000 Log Shipping, SQL Server 2005, SQL Server log shipping