SQL Server 2005 Error Registering database
I try to copy SQL Server 2005 Database to VISUAL Jobshop (ERP INFOR) get message when VJS DB Wizard of Jobshop tries to create catalogue tables “Error registering database – operation is not allowed when object is closed” Thanks for help where I have to look to solve that problem.

Answer Question   |  November 30, 2009  9:12 PM
SQL Server 2005, SQL Server error messages, VISUAL Jobshp

Returning string value from a stored procedure in sql server 2005 to vc# ide code at runtime
Hi, This is Pushan Chakraborty from Kolkata.I have complied 2 stored procedure to retrieve the names of 2 user defined tables that I have created . The stored procedures are: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go    — ============================================= — Author: <Pushan Chakraborty> — Create date: <23rd nov> — Description: <retrives the name of [...]

Answer Question   |  November 30, 2009  3:27 PM
SQL Server 2005, SQL Server 2005 Express, SQL Server stored procedures

hardware requirement for sql 2005.
Hi all, We are planning into SQL 2005 server (windows server 2003)with multipledatabases of sizes of around 10gb.What should be the CPU speeds ,type of CPU and RAM requirements for ir

Answer Question   |  November 25, 2009  12:20 PM
SQL Server 2005, SQL Server databases, Windows Server 2003

Why is my logical disk usage enormous?
I have a cluster server (2003 OS) in my environment with SQL Server 2005. It has four internal disks with RAID 10 configurations. My logical disk usage is pretty high and I am not sure how to find out what exactly is “hammering” our server or what database is making this disk activity enormous. I [...]

Answer Question   |  November 10, 2009  2:19 PM
logical disk, performance tuning, SQL Server 2005

Setting up dbmail in SQL Server 2005 on Server 2003
I am having trouble setting up dbmail in SQL Server 2005 running on Server 2003. I am trying to send mail through an Exchange 2007 Server. Do I need to use the SQL Service account with Windows authentication? Also on the Exchange side, how should the “receive connector” be set?

Answer Question   |  November 8, 2009  4:37 PM
Database Mail, DB Connector, SQL Server 2005

TFS VSTS2010
Hello Members,                        I am very new to this blog.I want to need some information regarding VSTS2010 TFS(Team Foundation Server).I have couple of questions in my mind. I really want to share with you. At present time we want to implemnet automation testing processes for our WPF window based as well as web based applications. [...]

Answer Question   |  November 6, 2009  3:00 PM
SQL Server 2005, TFS VSTS2010, Visual Studio, Visual Studio 2010

SQL Server 2005 on Windows 2008 64 bit SP2. Installation issue
I have tried to install SQL Server 2005 on Windows 2008 64 bit SP2. I have installed SQL server 2005 and SQL server 2005 SP2, however only the SQL Server 2005 configuration tools appear. (Everything was selected to install) I have found these posts which have the same issue, but they are for web server [...]

Answer Question   |  August 23, 2012  11:57 AM
SQL Server 2005, SQL Server 2005 (64-bit), SQL Server installation, Windows Server 2008

How to export/ import userschema in SQL server 2005?
To export userschema in oracle, we can use expdp and impdp commands. Do we have any commands to export/ import userschema in SQL server 2005? Also, How to export all the tables to filesystem? Using SQL management server studio there is an option to export 1 table at a time to a file.     [...]

Answer Question   |  November 4, 2009  7:14 AM
SQL Server 2005, SQL Server backup, SQL Server snapshot backup

Security Update for SQL Server 2005 Service Pack 3 (KB970892)
hi! each time i try to update the captioned update it fails. i guess it has also caused my ooutlook to crash!!! pls help

Answer Question   |  January 12, 2010  7:24 AM
Office 2007, Outlook, SQL Server 2005, SQL Server Security Bulletins, SQL Server Service Packs

SQL 2005 will not recognize other local disks
SQL Server Management Studio only recognizes one drive on the server, how do I get it to recognize the other Local disks?  The one disk it does see is also on the AX-100, but it will not list any of the others, even the interanl disk, as options for devices to create databases on or [...]

Answer Question   |  October 30, 2009  5:26 PM
SQL Server 2005, Storage

How to export excel data to Sql server 2005
How to export excel data to Sql server 2005

Answer Question   |  August 10, 2010  11:04 AM
Excel 2007, Exporting Excel to SQL, Microsoft Excel, SQL Server 2005

What is the difference between RAM and Cache Memory in SQL Server 2005?
What is the difference between RAM and Cache Memory?

Answer Question   |  October 27, 2009  4:02 PM
Cache Memory, RAM, SQL Server 2005

Database restore
I’m struggling with when is the right time to do my last transactional log backup before my full database backup. My question is this: if I do a full db backup once a day at 10pm; and a tran log backup every 4 hours (12pm, 4am, 8am, 12am, 4pm, 8pm). If i have to restore the [...]

Answer Question   |  October 27, 2009  2:53 PM
Database backup and recovery, SQL Server 2005, SQL Server administration

Auditing Windows 2003 and MS SQL 2005
Are there any audit scripts I can use to audit Windows 2003 and MS SQL 2005?

Answer Question   |  October 23, 2009  9:17 AM
IT auditing, IT security, SQL Server 2005, SQL Server Auditing, Windows Server 2003, Windows Server Auditing

Is having the auto create statistics on in a database a good thing?
Hello I have a 250GB database and the auto create statistics is on is that a good thing?

Answer Question   |  October 23, 2009  2:08 AM
SQL Server 2005, SQL Server administration, SQL Server performance, SQL Server performance tuning

SQL Server 2005 distribution agent failed
Getting this error message

Answer Question   |  October 16, 2009  5:01 PM
SQL Server 2005, SQL Server Distributor, SQL Server error messages

Restore a View Sql Server 2005
I over-wrote a VIEW by mistake. How do I recover the original version of the view? Is there a way to ROLLBACK a “CREATE VIEW…” command?

Answer Question   |  October 15, 2009  3:10 PM
SQL Server 2005, SQL Server View

Different database & server collation
Hi, We have a database that is sitting on a SQL Server 2005 with different collation setting, the application connect to the database is running with out any issue. Have anyone had this same issue, if so how long has your application run with different database and server collation without running into collation issue? Thanks

Answer Question   |  October 19, 2009  5:26 AM
Collation, SQL Server 2005

Resource usage of SQL Server 2005 Generate Script
Hi, I am wondering how resource hungry the Generate Script for SQL Server 2005 is. We are planing to script out one of our production database on a production server that has over 1000 object to script, and wether this will have more affect on SQL performance during the scripting? Thanks.

Answer Question   |  October 13, 2009  12:28 PM
SQL Scripting, SQL Server 2005, SQL Server performance, SQL Server performance tuning, SQL Server Scripts

Trying to setup a Merge publication between two database Need Help!
HI I am trying to setup a Merge publication between two database and I am having troubles.  I have to server one is HKDD01 and LDDD01 and the HKDD01 is set as the distribution and the LDDD01 is set as the subscriptions. I am trying to create a Merge publication with pull subscription and I [...]

Answer Question   |  October 13, 2009  9:39 AM
SQL Server 2005, SQL Server databases, Windows Server 2003