• 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

    Multilanguage25 pointsBadges:
  • 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.

    Db23290 pointsBadges:
  • 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

    Sukumardba5 pointsBadges:
  • 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?

    Tyecom5 pointsBadges:
  • 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...

    Db23290 pointsBadges:
  • 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 stored procedure...

    SwapnilD25 pointsBadges:
  • 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.

    Rick Martinez585 pointsBadges:
  • 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

    Teamwork085 pointsBadges:
  • 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 Tables created in my DB...pls provide me Step...

    ENGG66615 pointsBadges:
  • 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...

    Joetig35 pointsBadges:
  • 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...

    Baristador5 pointsBadges:
  • 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 databases. We...

    MxPerry25 pointsBadges:
  • SQL 2005 Password

    I inherited SQL 2005 server from a previous employee and the SA password is currently stored and saved in the GUI. This has allowed me to do my job up until now. I have what I think to be the password but I am unsure if it is correct. I am afraid to remove the stored password to check. Is there an...

    Jabbman4220 pointsBadges:
  • 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?

    Shircol25 pointsBadges:
  • 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...

    Kansai5 pointsBadges:
  • 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....

    ITKE346,430 pointsBadges:
  • 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.

    ITKE346,430 pointsBadges:
  • 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

    Infrastucture25 pointsBadges:
  • 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....

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following