• Testing when primary and mirror SQL Servers are the same

    My primary SQL Server and mirror SQL Server are the same. Is this allowed for testing?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Comparing views, user-defined functions and stored procedures in SQL

    How do views, user-defined functions (UDFs) and stored procedures work in SQL, and what conditions are there on their usage?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Acquiring remote access for SQL Server 2000 from a private server to a public server

    How do I acquire remote access for SQL Server 2000 from a private server to a public server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Limit admin access to a single database SQL2005

    I want to set up an account similar to sa but limit the rights to a particular db.

    Cybx10 pointsBadges:
  • shrinking of pie-chart graph when there is no data

    In my application, i have to display "No Data Available " at the pie-chart when there is no data to show in pie-chart... I have done that by setting the NoRows property to "No Data Available" , but the graph block shrinks by 1-2 mm when there is no data..Can anyone provide me the solution to this...

    Bhushanladdad30 pointsBadges:
  • SQL Server restore duration

    what DMV show restore info. including the duration of a restore?

    JDPhillips5 pointsBadges:
  • Exchange 2000 and Active Directory mess

    I inherited the bulk of these problems due to poor forethought by a previous consultant. He moves on server crashes I get called in with no real history or information, workarounds to get business critical apps going while waiting on parts for other server and now stuck in the quagmire I'm in....

    Injury5 pointsBadges:
  • Migrate FROM SQL2005 Ent. TO SQL2005 Standard

    We recently installed and have been running SQL 2005 Ent. because that is what we planned to use. During the 180 day window our needs have changed and we purchased Standard edition rather than Enterprise. Now we need to migrate from Enterprise to Standard. My question is what is the best way to do...

    Jtncat5 pointsBadges:
  • SQL Server 2000

    How do I connect my AS/400 to a SQL Server 2000

    Jld10 pointsBadges:
  • Exception from HRESULT: 0x80040104 (System.Windows.Forms)

    Program Location: at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous) at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args) at...

    Kambiz5 pointsBadges:
  • Reporting Services Installation

    My company is installing new software which uses SQL Server 2000 as its data container. Is it possible to purchase a standalone copy of Reporting Services 2008 and link it to the SQL Server 2000 database? I am new to SQL Server, but have a background in MS Access & Visual Studio. I believe that I...

    Critter0175 pointsBadges:
  • Updating values in a table in a SQL database

    I have a SQL database with a table. I need to insert a new record into that table if there is no entry for a particular column that day, or I need to update the record if that new record already exists. I am using a count column in the table to accomplish this, and if the count is null, I am...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL database backup

    Am having 2 databases running on SQL SERVER 2000, OS(windows server 2003), so the backup for these databases are to suppose to run on monday, wednesday and friday 12:00 and 16:30 in the afternoons.So since last week the backups have been failing to run till today, and by checking the event viewer,...

    45115 pointsBadges:
  • Log shipping after upgrading to SQL Server 2005

    I've upgraded our warm backup to SQL Server 2005 recently, but our log shipping is down. How can SQL Server 2005 be used with SQL Server 2000 log shipping?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrating SQL Server replication from one server to another

    We are migrating our SQL Server from one server to another; is there a way that replication can also be moved from source to destination?

    SQL Server Ask the Experts2,585 pointsBadges:
  • indexes on a large table

    hello, i got a 5milion rows on a single table, my database is sql2005 and my select is : SELECT top * FROM tbl1 WHERE ip_from <= 3515134258 and ip_to >= 3515134258 the 3515134258 is on a sample but the format is similar: SELECT top 1 * FROM tbl1 WHERE ip_from <= [value] and ip_to >=...

    Bbbttt15 pointsBadges:
  • Using the snapshot feature in SQL Server 2005 to replicate an operational database

    We are trying to keep a replicated copy of a customer’s operational database at our hosting facility. Our copy of their operational system will be used to run ETL against each night to refresh a data reporting database. Our hope is that, each night, we will receive a snapshot file and apply that...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Obtaining the value of certain columns in a SQL database

    I have created the following trigger that inserts data into a SQL table when a specific column is updated. I would also like to obtain the current value of certain columns of the updated row. To do this, I've been using the INSERT command, but I keep receiving NULL values in return. This is the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error messaging while using BCP in SQL Server 2005

    I am getting this error while using the Bulk Copy Program (version 9.0) in SQL Server 2005: "An error occured while processing the command line". I am using the following command: bcp MyDatabase..temptable in "C:Documents and Settings\RishiOut.txt" -c -r n -SMyServer -UHamp -Ppass123...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Configuring the mail account in Database Mail

    When I configure the mail account in Database Mail, does the @servername have to be a website address?

    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