• SQL 2005 Active/Active/Passive

    We have a SQL cluster server running with SQL 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition. Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So after I have done it, the cluster will be a Active/Active/Passive cluster. Because...

    Kjrichmond15 pointsBadges:
  • Installation and updates

    Howdy folks, Tryin to keep things going around here....need some advice. I have Win2003 servers and Active Directory.....single domain....approx. 100 client computers.....one location. Am upgrading all computers from Office XP to Office 2003. My project: Install Office 2003 and all updates remotely...

    TheVyrys0 pointsBadges:
  • How to prevent SQL update trigger from firing on insert?

    Category: SQL Server 2005, T-SQL I have an insert trigger on TableA that updates Column1 in TableA. I also have an update trigger on TableA that I don't want to fire, or at least not to execute certain code, when a new record is inserted in the table. How can this be achieved? I don't want to use a...

    Leo W5 pointsBadges:
  • full-text replication SQL Server 2000

    I'm having problems replicating a table that has full-text enabled using sql server 2000 sp4. When I start the distribution agent I get the following error: Cannot use a CONTAINS or FREETEXT predicate on table 'dbo.proposals' because it is not full-text indexed. I have run sp_fulltext_database...

    MarkT35 pointsBadges:
  • Convert time to GMT time

    In t-sql, I want to store the date from the getDate() function in GMT time instead of local time.

    Apinto5 pointsBadges:
  • What’s a safer upgrade, SQL Server 2005 or the new SQL Server 2008?

    Do you think that as of next January (2009), SQL Server 2008 will be too new and we should instead go with SQL Server 2005? FYI, we are not a big installation.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Looking for a stored procedure to monitor size of Transaction Log file

    Is there any way I can create a stored procedure which will check for the Transaction Log file size - where we have a specified limit to grow - and if the Log file reached 80 percent of total size, email alerts can be sent to DBAs?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Problem occuring while performing Mirroring

    Hi, I underwent the following Steps for creating a mirror in sql server 2005. 1. Downloaded and isntalled sp2 in principal,mirror as well as witness servers 2. Created a new database named it as FinalMirror 3. Right clicked on the database Tasks-backup-BackupType--Full--Ok created FinalMirror.bak...

    Cmrhema5 pointsBadges:
  • New user permission to SQL server

    Hi all, I have created a new local user on the sql server. Now when i access the sql enterprise server, it fails and gives error as " login failed to user, check SQL registration properties. Thank you.

    Mutallib5 pointsBadges:
  • SQL Server 2005 – Are There Any Easy Appl. Builders

    Hi, Is there a easy application builder for a PC to access a SQL Server 2005 Database that will give it the ability to do Inserts, Update, and Deletes? Is there a program that can read in a SQL Server 2005 Schema and generate forms to do updates and reporting? Are there any Open Source Apps or low...

    Tsmith235 pointsBadges:
  • Replication

    Can I have multiple Distributors configured on one SQL Server instance? Also, can I have multiple Distributors configured on one SQL Server instance? Finally, can I have multiple Subscribers configured on one SQL Server instance?

    Consultant16535 pointsBadges:
  • How to pass Parameter of stored procedure Crystal report

    How to pass parameter of Crystal report from visual Basic while crystal report created with stored procedure

    N75 pointsBadges:
  • fore front – Can FCS be installed on sql express 2005

    Can FCS be installed on sql express 2005, and if yes what is the requirements as per the web site it can be done but how !!!!??? eveywhere else they are saying its not supported http://www.microsoft.com/forefront/serversecurity/mgmt/sysreqs.mspx

    Rami220 pointsBadges:
  • about checkbox

    Iam just at the very basic level of entering a boolean value(yes/no) for the check box cheked value in to a database with field check...for this Iam using a string variable checkvalue and proceeding like this private sub submitbtn_click(.......) dim checkvalue as string="" if checkbox1.checked=...

    Anupamak1515 pointsBadges:
  • Looking to resolve SQL Server performance problems caused by using many temporary tables

    I need your advice on the SQL Server performance tuning. The Problem: We use a lot of temporary tables in our application, which is causing a lot of SQL Server performance problems. I read about the following solution on some site. "RamDisk presents a powerful solution to this problem by providing...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error when restoring a .bak file in SQL Server

    I’m having a problem restoring a .bak file in SQL Server. The .bak file is fine and good. But when I restore it, I get an error. It says " TITLE: Restore failed for Server <servername>(Microsoft.SqlServer.Smo) ------------------------------ ADDITIONAL INFORMATION:...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Microsoft SQL 2005 Networking

    Hi I'm a software developer and i use Visual C# 2005 and Microsoft SQL 2005 to create my desktop applications my application is a software will be installed in to client machines as 2 home PC and i want to make the two software's connect throw Ethernet to my database which it located on one of the...

    M200015 pointsBadges:
  • How to back up SQL Server database file on a different shared network

    I want to back up a SQL Server database file on a different system shared folder which is in different WAN network. How can I do this and are there any other backup methods available in SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Potential over & under security issues with SQLNative Client ?

    Hello, I've been unable to find any reports of these two problem when using the SQL Native Client driver (9.00.3042.00), so I'm hoping else has seen these. Firstly check constraint definitions accessed by the following TSQL only returns data with the SQL Server driver, ie nothing with SQL Native...

    WarwickW5 pointsBadges:
  • Activesync And Server 2000

    I'm having trouble with setting up my AT&T Tilt with Server 2000. I have Activesync 4.5 and it will not conect to the server. I've been told there is no upgrade for Server 2000 but there has to be a way short of upgrading to 2003. I just need to get my Email from the Exchange. Please help.

    Mountian Bubba5 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