• 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:
  • 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:
  • 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:
  • Which is more advanced in an Excel/Microsoft SQL Server Analysis Services environment, MDX or UDM?

    Which is more advanced in an Excel/Microsoft SQL Server Analysis Services environment, MDX or UDM?

    SQL Server Ask the Experts2,585 pointsBadges:
  • What are the best practices for storing SQL Server application/program files on a SAN?

    We have a non-clustered SQL Server with a Storage Area Network (SAN) on it. What are industry standards/best practices for the location of the application/program files? Is it okay to put the app files on the SAN? We usually put them on local disk storage, but due to an incorrect installation, they...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to create an SSIS package for importing an Access table to SQL Server, running SPs and exporting data to Excel

    I need to create a SQL Server Integration Services (SSIS) package for importing an MS Access table into SQL Server, then running some stored procedures on this database and finally exporting the result to Excel. I am comfortable in writing queries and working in Management Studio but I don’t know...

    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