• Updating the database using information_schema

    I am having database a and b i want to update database a according to updations in database b .b is same as a operations are done on b database and after complition a will get updated for permanent change? how can I do this automatically by using information_schema in sql server 2000

    Mcm5 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:
  • Connecting Visual Basic and SQL Server

    After creating ODBC, what code will connect the front-end Visual Basic and the back-end SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2000

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

    Jld10 pointsBadges:
  • Exception from HRESULT: 0×80040104 (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:
  • Date formats in SQL Server Stored Procedures

    This one will be easy, I'm sure. I'm a novice at Stored Procedures, and I'm wondering what function I can use to display a smalldatetime field (currently displaying as Dec 19, 2008 12:00AM) as a short date (12/19/2008)? I am on Sql Server...

    Wandasoozq5 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:
  • Writing a stored procedure to insert an ASP.net file into a SQL database

    I need to write a stored procedure to insert into a SQL database the contents of a file that has been in read in ASP.net. How would I do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How do I use the results of count(*)=0

    I am using SQL to code a select statement. If the result of the statement = count(*)=0, I want to put a message out on a report.

    Sherryborden85 pointsBadges:
  • Configureing DTC in Windows 2008 64 bit clustering with SQL 2008 std 64 bit

    I have read some limited blogs and kb articles about this DTC setup in windows 2008 clustering with SQL 2008. I like to get some clarification about this DTC setup. Our shop doesn't use distributed transactions but we do use transactional replication. So our DTC is mostly used in SQL related...

    OceanDeep15 pointsBadges:
  • SSIS package using dynamic configurations

    Hi I have to create a package which process the analysis services cube and its partitions,and dimensions. This package should run every 15 minutes to process the cube. I have a procedure which creates the database in analysis services db and relational db for the current month. I have another...

    GIG240 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