• Setting up failover notifications in SQL Server 2005 cluster

    We are new to clustering. We have recently successfully implemented a four-node (active/passive config) SQL Server 2005 cluster. How can I be automatically notified when a node within the cluster fails over to the passive standby or other node within the cluster? Thanks, JGalt

    JohnGalt35 pointsBadges:
  • Command to display virtual nodes hosted by a physical server.

    We have a four node (N+1)SQL 2005 cluster. From a DOS prompt, is there a command that can be run on each of the physical servers that will show you if it is hosting one of the virtual nodes of the cluster?

    JohnGalt35 pointsBadges:
  • Emails go straight to the Task Folder

    In outlook 2007, some emails received are being moved straight to the task folder rather than the inbox. There are no rules set in Outlook causing this to happen. Any ideas? Is this a bug?

    Lindsey5 pointsBadges:
  • Error message in Query Analyzer on SQL Server 2005

    I am trying to run the following command in Query Analyzer on SQL Server 2005: use temp alter user [MY-LP79EFIWXO93login_a] with login = [MY-LP79EFIWXO93login_b] However, I keep receiving this error: Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'login'. Why might this be?

    SQL Server Ask the Experts2,585 pointsBadges:
  • i5/OS vs MS sequel server 2005

    The powers that be would like to replace our 20 year old i5 home grown billing system with a .NET solution (partial) over MS SQL Server 2005. How do we convince the powers that be to keep & improve what they have or should we just surrender and start taking .NET classes?

    Soooyeah5 pointsBadges:
  • Overlapping data on a merge replication between three SQL Servers

    We have a merge replication between our three SQL servers at three different locations. One is the publisher and two are subscribers, and we have a primary key on a table (a unique field with is auto-incremental by one). On the publisher’s server, if the user creates a new order, the table...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to create new ramco test server?

    Plz help me,when i restore my sql database with ramco backup then my database is restore but problem is that front-end not lounch in my system.

    Amitshukla60 pointsBadges:
  • Reindex DBF file from Ms-SQL 2000

    Is it possible to reindex an extenal dbf file via linked server ?

    Mic15 pointsBadges:
  • sql reports

    Sql Server Reporting service. 1.first query I have given a task of generating reports using sql server reporting service.I need to generate a summary view as below, Fig:1 Jan-08 Feb-08 Mar-08 Bug Trend ECR 3.88 4.06 3.86 Goal 5.00 5.00 5.00 Backlog 70 75 82 Incoming67 71 55 Outgoing62 65 56...

    33015 pointsBadges:
  • Database tables interrupted…..

    Any input at all would be greatly appreciated - All I know is that a companywe provide IT Support to had 4 databases running when the SQL services were shut down on the server. Now the fellow cannot see any of his tables – nothing shows up when he opens SQL, or in his ODBC network connections....

    AndreaF8,035 pointsBadges:
  • Records with null value not in output

    See query: select distinct f2.description Business_Unit, f3.description Department, f4.description Function, a.segment5 Account, f5.description Account_Description, sum(nvl(d.entered_dr,0) - nvl(d.entered_cr,0)) Actual, (Select sum(nvl(dd.entered_dr,0) - nvl(dd.entered_cr,0)) from...

    Tams5 pointsBadges:
  • SQL Subfile and position to ability

    I have a subfile that can be sorted by any of 4 fields, so I want to use imbedded SQL to read the data out of my PF in order to populate the subfile. I want to be able to allow the user to enter position to information, and position to that entry - normally, I would do a SETLL to the file based on...

    Klw50 pointsBadges:
  • Executing System Stored Procedures

    What kind of "Permissions" does a developer need in order to execute sp_fulltext_catalog, sp_fulltext_column, sp_fulltext_database, sp_fulltext_table, sp_addLinkedServer, sp_addLinkedSRVlogin ?

    VelameLaCosa110 pointsBadges:
  • joining what is the diffrences between oracle proprietary join and sql 1999 compliant joins

    what is the diffrences between oracle proprietary join and sql 1999 compliant joins

    Muktioracle50 pointsBadges:
  • Can’t Upgrade to SQL Server 2005

    I am trying to upgrade a SQL Server 2000 SP4 standared edition running on 64bit Windows 2003 to SQL 2005. Since I am trying to upgrade, I am updating the Default instance. After selecting default instance, the wizard takes you to what components to upgrade; but the Database services is locked so it...

    Randym1,740 pointsBadges:
  • List the names and addresses of all employees who are Mangers

    Employee (emplD, fName, lName, address, DOB, sex, position, deptNo*) Department (deptNo, deptName, mgrEmplD*) Project (projNo, projName, deptNo*) WorksOn (emplD* projNo*, hoursWorked) where Employee contains employee details and emplD is the key. Department contains department details and deptNo is...

    Shawe10 pointsBadges:
  • I need to move a sql 7.0 database to a different server running sql 2005.

    What would be the best way to do that and will the jobs and DTS jobs come with the database? If not how can I move them also. Thanks for any suggestions.

    Bubbanm90 pointsBadges:
  • Receiving an error in Quality Assurance on SQL Server 2005

    I am trying to run the following command in Quality Assurance on SQL Server 2005: use temp alter user [MY-LP79EFIWXO93login_a] with login = [MY-LP79EFIWXO93login_b] However, I keep receiving this error: Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'login'. Do you have...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Copying a database from SQL Server 2000 to SQL Server 2005

    I am using the Copy Database Wizard to copy a database from SQL Server 2000 to SQL Server 2005. I gave it the data file path on the source server (ex. \SOURCEDBC$Program FilesMicrosoft SQL ServerMSSQLData), but it returns an error when I attempt to execute the package ("Access to the path...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Restoring SA access to SQL Server

    I have somehow removed my SA permissions from my SQL server. I do not know the SQL SA password. Is there any other way to restore my SA access to SQL? I am a local admin on this server.

    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