• Settng Memory Sql Server 2005 SP2 64Bit

    Hi I've a SQL Server 2005 sp2 64bit , i have to set memory and my server has 12gb fisical memory and 20gb paging file, what is the best pratices to set sql server memory for best performance? Thank You Best Regards Vincenzo

    Nuanda777720 pointsBadges:
  • Replication in SQL Server 2005 deleting records

    We just converted from SqL 2000 to 2005. We were replicating from 2 instances on the same server every 30 minutes. A record from Intsnace A was copied to Instance B, then the record in A was deleted. Worked great for years. Now with 2005 it is deleting the records on B on the second pass. We think...

    Getmygto5 pointsBadges:
  • Problems with sp_send_dbmail in SQL Server 2005

    I am trying to convert my stored procedures in SQL 2005 from using xp_smtp_sendmail to using sp_send_dbmail. When I use the "Send Test Email" option in the management studio, I am getting the following error message from the sp_send_dbmail: The mail could not be sent to the recipients because of...

    Randym1,740 pointsBadges:
  • Problem with MSSQL? .NET application? or Win Server?

    Dear members, Please help me in regarding my problem. I am very much confused on whom to blame for the problem........MSSQL? or .NET ? or Win server? I have a dedicated server with 2GB RAM, SQL 2005, 150GB bandwidth, 160 GB disk space etc., I have created a .net application that fetches data from...

    georgesmith55 pointsBadges:
  • SQL Server Tools do not show up

    Greetings, I have my laptop running MS SQL 2005. I upgraded from XP to Vista. When XP was installed, I had SQL 2005 Express and SQL Server 2000 running parallel. After installing Vista (clean) I decided to just go with SQL 2005. I installed SQL 2005 Express. Later, I installed the full server, and...

    Taersious15 pointsBadges:
  • SQL 2005 with running 2 Databases

    Can we install one instance of SQL 2005 on one server but running two different databases?

    Stemdriller5 pointsBadges:
  • Reverse engineering replication

    I would like an "automated" way to "script out" existing replication for SQL Server 2005. Does anyone have a method for this? Thanks.

    Lizward5 pointsBadges:
  • SQL 2005 Replication

    hello, i have a replication which is done between 2 sql 2005. server AB which is on a cluster is the publication whereas there are multiple servers who are the subscriber. whenever reepliaction is done i have the error : error authenticating proxy domain\username. check that the username or...

    Nns5 pointsBadges:
  • Filegroup in SQL Server 2005

    I have very large tables (5,000,000 records each year) which are frequently joined to each other, should I put each of them on a different filegroup? what about their indexes which are used in join conditions?

    Gerayeli5 pointsBadges:
  • Possible Deadlock Condition

    I have a server at work that I have been having some serious issues with. It is our main server that holds our database and runs our applications. For the last 3 days we have been receiving 'Possible Deadlock Condition' errors which leads to the server locking up. The only way to restart the server...

    ZiPPy30 pointsBadges:
  • Indexing Fact Tables for a data warehouse

    Hi I am reviewing the indexing the fact tables of a data warehouse and it currently has a clustered primary key and quite a few VERY LARGE covering indexes comprising lots of columns. The selectivity of the columns other than the primary key is very low; mostly close to 0% with a couple around 15...

    Garp0 pointsBadges:
  • Disaster Recovery

    How to get database back in disaster recovery when database is in emergency mode in sql server 2005 is there any option to update master then take a backup --please let me knw---

    Vaibhavmathur0 pointsBadges:
  • connecting VB2005 Express with remote msSQL2005 Express server

    I'm trying to do the above with no sucess although I can connect msQuery, create msAccess projects, and ODBC with the remote server. The remote server is already configured to accept remote connections.!!! the message is that the remote server do not allow remote connections!!! any ideas

    Teqani0 pointsBadges:
  • Triggers in sql server 2005

    hi Experts, I have created a table called MyEmployees with ManagerID,ContactID,etc.,.. fields. Also i created another table ManagerAndContact with Only ManagerID and ContactID as fields. Now what i need is, whenever am inserting a new row in MyEmployees table, the corresponding ManagerId and...

    Kmm0 pointsBadges:
  • SQL 2005 Restore DB with Multiple files in Primary File group

    Is it possible to take a backup of a database that has multiple files within the primary file group (10 total in this example) and restore that backup to a new database that has only one file in the primary file group? THanks, Lee

    Leeland0 pointsBadges:
  • move db,logins

    how can we transfer database and logins from sql server 2005 to another sql server 2005

    241219840 pointsBadges:
  • Question on JOIN Clause

    Folks, Is there any differences between selecting values from a table using JOIN clause, by using as JOIN or INNER JOIN. I mean, Will the result or performance changes when JOIN is used instead of INNER JOIN in MS SQL SERVER 2000/2005 Thanks in advance ! ash

    Ashok tak0 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