• Merge Replication Identity Ranges

    What should the publication range and subscription range be set to for each table with identity ranges, bearing in mind thousands of changes can go into some tables each day. I have 1 Publisher and 9 Subscriptions (Merge) and have started getting "The Publisher failed to allocate a new set of...

    Ramapa25 pointsBadges:
  • Restoring a SQL Server 2005 IBM Rational RequisitePro database from SQL Server 2008, back to SQL Server 2005

    I have installed a SQL Server 2005 IBM Rational RequisitePro DB into my local SQL Server 2008. Can I restore this database back to the SQL Server 2005 box? I know this was a problem when going from SQL Server 2005 to 2000.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is it possible for named instances to share components in SQL Server 2005?

    Is it possible for two named instances to share components in SQL Server 2005? I’m aware multiple instances have their own components, but is there any way these can be shared to reduce overhead in SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can I bring a .dat database file into SQL Server 2005?

    I need to bring a .dat database into SQL Server 2005. When I right click on database and Task, I don’t get the "Copy Database" option. What do I need to have this? What is an alternative method to bring the SQL Server 2000 database into SQL Server 2005 Express?

    SQL Server Ask the Experts2,585 pointsBadges:
  • sql 2005 db security for public

    I have databases that were converted (by restore) from sql 2000 to sql 2005. I found a script to move the logins (all using nt/sql auth) to the 2005 box. All the users on the sql 2000 box belonged to public on the old box. If i loook at the users inside the db's on the 2005 box (no public) they are...

    tcstl95 pointsBadges:
  • Connecting from VB6 to a remote Oracle Database

    We are a SQL 2000 Database shop using Visual Basic 6.0 & Windows 2003. I need to develop an application that can access an Orcale database on a remote system (sight to sight VPN in place) using SQL. I retreived some information yesterday that enabled me to construct the connect statement in our...

    Gcasner5 pointsBadges:
  • Can one instance of SQL Server 2005 support two databases on one server running Windows 2003?

    Can one instance of SQL Server 2005 support two databases on one server running Windows 2003?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Do replica dbs need to be updagraded when uprading from SQL 2000 to SQL 2005

    Do replica dbs need to be updagraded when uprading from SQL 2000 to SQL 2005

    LindaLawson10 pointsBadges:
  • Upgrading from SQL 2000 TO SQL 2005 Will all the sites (Multisites) need to be upgraded

    Upgrading from SQL 2000 TO SQL 2005 Will all the sites (Multisites) need to be upgraded

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

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