Microsoft SQL Server BCP Utility password
I am executing a Microsoft SQL Server Job that runs a BCP Utility.  The utility loads a table from a file using the ‘in’ argument, a format file and an error file.  I have ‘hard coded’ the user name and password in the command line using the ‘U’ and ‘P’ arguments. I am looking for a [...]

Answer Question   |  November 23, 2010  7:42 PM
BCP Utility, BCP Utility password, SQL Jobs, SQL Server, SQL Server 2005, SQL Server 2005 Enterprise Edition, SQL Server Enterprise Edition

Documenting stored procedure jobs in SQL 2005 enterprise
Our consultant created several stored procedure jobs within SQL 2005 enterprise. How can we view them to document them? SQL runs on a Windows 2008 box with 32gb of memory.

Answer Question   |  November 1, 2010  2:19 PM
SQL 2005, SQL procedure, SQL Server 2005, SQL Server 2005 Enterprise Edition, Stored Procedures, Windows Server 2008

attach a new mdf and ldf files in sql server 2005 enterprise
i have a new mdf and ldf file created in sql server 2000.how could i attach these to sql server 2005 enterprise edition?i tried it by right click the database and select attach.but it shows an error when click the add button in database dialogue box.

Answer Question   |  March 26, 2010  6:45 PM
LDF, MDF, SQL Server 2000, SQL Server 2005, SQL Server 2005 Enterprise Edition

Differences between SQL Server 2005 Standard Edition and Enterprise Edition?
What is the difference between running SQL Server 2005 Standard Edition and SQL Server 2005 Enterprise Edition?

Answer Question   |  February 10, 2009  9:00 PM
SQL Server 2005, SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition

Correct Isolation level for SQL2005 Subscriber.
Hello, I’m specifying a SQL 2005 Enterprise back-end to an OLTP application which has one main DB (200GB, could grow to 600GB), a subset of which will be replicated to a separate subscriber for running read-only queries. Here’s the spec, any comments appreciated, especially around the use of read committed snap-shot on the subscriber. Transaction [...]

Answer Question   |  January 5, 2009  2:31 PM
OLAP/OLTP, SQL 2005 Database design, SQL queries, SQL Server 2005 Enterprise Edition

Migrate FROM SQL2005 Ent. TO SQL2005 Standard
We recently installed and have been running SQL 2005 Ent. because that is what we planned to use. During the 180 day window our needs have changed and we purchased Standard edition rather than Enterprise. Now we need to migrate from Enterprise to Standard. My question is what is the best way to do this. [...]

Answer Question   |  November 14, 2008  3:28 PM
SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server 2005 Enterprise Edition, SQL Server migration

How can I connect my local machine to the SQL Server 2005 Enterprise Edition?
How can I connect my local machine to the SQL Server 2005 Enterprise Edition?? I can’t even run the local service instance

Answer Question   |  November 5, 2008  10:29 PM
SQL Server 2005, SQL Server 2005 Enterprise Edition, SQL Server connectivity