• 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:
  • C#.Net

    Does anyone know of a good place to find people with C#.net experience besides the big job boards? We have several positions in the Financial/Trading industry in Chicago but we are having a hard time finding enough people with this skill set. Any Blogs, User Groups or Niche Sites you can recommend?...

    Cmcwag0 pointsBadges:
  • execution plan is same even though it takes 10 times longer to run

    I have a query that accesses a table with a non-clustered index. When I drop the index and run the query, it takes 1.25 minutes to run. With the index, it takes 2 seconds to run. Yet, the execution plan is the same with or without the index. How can that be? Thank you!

    Abbi20 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 Scripting

    Using SQL and given table X with columns labeled A, B, C, and D – how do you get a list of data in column C when column A and B are the same?

    Tdwalton365 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:
  • Installing Terminal server to existing domain

    I have a client who has Server 2003 R2 installed running 2 line of business applications on SQL Express databases, plus Exchange. They have installed a Second server as a Terminal Server to provide access for remote workers. Do I have to reinstall the applications on the Terminal Server, or is...

    Itworx5 pointsBadges:
  • Using Veritas for SQL clustering

    I would like to know if anyone is using VCS for SQL clustering and, if so, what their real-world experiences and thoughts are on VCS versus Microsoft SQL Clustering.

    JohnGalt35 pointsBadges:
  • SQL Right Trim Nulls

    How can I trim any trailng nulls from a selected record set. I have a table with up to 17 cols that I need to extract data from which included all embedded nulls but no trailing nulls

    Tim442025 pointsBadges:
  • Equivolent SQL Server function for Access DoCmd.TransferText

    I need to convert an Access app to SQL Server that has a DoCmd.Transfer command in it. Is there a qay to accomplish this in a stored procedure?

    Paul4815 pointsBadges:
  • Apache config question

    I'm trying to get a rewriteCond & rewriteRule to work. I want the command to check for a file(image) and if it doesn't find it to use a default image. Not having any luck getting the command right. example: RewriteCond /doc/route/%{REQUEST_FILENAME} !-f RewriteRule ^(.+)...

    Chrissdc5 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:
  • Limiting users to one concurrent login in Active Directory

    We wish our users to login once only to one PC. Microsoft say we can only do this by limiting them to one designated machine, this is not possible for us. We need to know that if a particular user did something we can rely on the audit trail. We understand this may get tricky with Citrix use....

    Stanslad0 pointsBadges:
  • Stored Procedure for dropping indexes

    I would like a stored procedure that will take as input the name of a table. Whatthe procedure would do is drop all indexes on that table excpet any index that ends with U1 or P1, and save the information on the ones it drops. Then I would like another strored procedure that takes a table name as...

    Dangagne30 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:

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.