• Move data in SSIS via store procedure

    How do I set up an SSIS pkg to move results from a stored procedure from an external ss2005 db to the local ss2005db?

    Dreadoux5 pointsBadges:
  • Email notification in the event of a SQL Server database failover

    In case of a failover of a SQL Server database, I’d like to be notified by email. Can you tell me how to activate this option?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error message during database mirroring on SQL Server 2005

    I am trying to begin database mirroring in SQL Server 2005. I have Service Pack 2 installed, and I have three instances running. When I attempt to start mirroring, I receive the error message, “One or more of the server network addresses lacks a fully qualified domain name.” My network...

    SQL Server Ask the Experts2,585 pointsBadges:
  • BCP and SQL2005 collation issues

    I get this error: Error = [Microsoft][SQL Native Client]Unable to resolve column level collations SQLState = 01000, NativeError = 5701 I am using the standar collation that comes with SQL2005

    Jmead5 pointsBadges:
  • Using MSDE 2000 Release A with my Custom VB 6.0 Application (PDW or Visual Installer 1.1)

    Hello IT Pro, Please can anyone give a thorough guideline on how to package my VB 6.0 Application with MSDE 2000 (Also including my Custom Database) so that my clients gets the CD and install without my being there for assistance Please help

    Aowl5 pointsBadges:
  • Union Query

    I 've a problem with porting my ms access database to sql server. In my inventory database, i have 4 tables: (1)Purchase, (2)Sales, (3)Quantity Adjustment, (4)Amount Adjustment. I want to calculate the stock position from those 4 tables. In access database, i do with this kind of queries : a....

    Ipong40 pointsBadges:
  • PHP or HTML

    I need to create a database that allows a user to query info. on a project,name, proj number, contacts, contact #, etc. We are using SQL 2005. The office manager will enter info. about each project into an access form. Then, from the HTML page a user can f search by project name or number to list...

    Caddman35 pointsBadges:
  • Extracting information with a DTS package from a database in SQL Server 2000

    We currently use a DTS package to extract data from the database and export it in either an XLS file or a TXT file. We now need to be able to export it as an XML file, and SQL Server 2000 DTS functions do not appear to support this directly. How do you recommend we proceed?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Creating a website with a SQL Server database

    What programming tools can I use to create a website that will be hosted on a Windows-based platform with a SQL Server database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Access databases

    I have a database that is in Access, Does anyone know if it is possible to query this DB using SQL server 2000..?

    Michaelrdowney10 pointsBadges:
  • Cobol Stored Procedures

    Can someone explain the flow of reentrant cobol stored procedures? Is it possible for two users to access and modify the same variable at the same time?

    Everett5 pointsBadges:
  • DTS of TEXT to BLOB or CLOB

    Is there a maximum size to DTS from text to a Blob or clob ?

    Donranny5 pointsBadges:
  • SQL Script

    I am trying to write a sql script that will ask for a date range each time it's run. How do I do this?

    Ebethea5 pointsBadges:
  • Backup/Restore a DB from Microsoft SQL Enterprise Manager to SQL Server Management Studio Express

    Hi Is it possible to copy a DB from a server that has a genuin SQL Enterprise Manager to a server that has SQL Server Management Studio Express installed? Both servers are on the same net. I get following error when trying: Restore failed for Server 'PROGTST\SQLEXPRESS'....

    Lissy5 pointsBadges:
  • RAID 1 or RAID 5

    I have 1 file server and 1 email server. both are Win2k3....one with exchange 2003 one with SQL 2000 but only 4 people using a small accounting program on it. Both are Dual XEON 2Ghz processors 1 Gb RAM 15K rpm hard drives. Ultra SCSI 160 controllers File server has software RAID 1, Exchange Server...

    TheVyrys0 pointsBadges:
  • Installing SQL Server over a SAN

    I am trying to install and configure my SQL Server over my Storage Area Network (SAN). Can you give me the best steps for doing so?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Time out in VB.net when SQL transaciton log backup schedule changed to hourly

    We have changed our back up schedule on transaction log from daily to every hour recently. Now my VB.net 2005 program start getting fail to read the table error (maybe caused by Timeout) during the time backup is executing. Is there anyway we can prevent this? Thank you, Paul Hsu

    PaulCHsu0 pointsBadges:
  • Oracle to SQL Server Migration – User Defined data types

    Oracle database has two user defined types as the following: CREATE OR REPLACE type arrayType1 is table of int CREATE OR REPLACE type arrayType2 is table of varchar2(255) How do we represent these in SQL Server 2005?!! (Note: Microsoft SSMA fails to migrate these) Thanks

    Kumar937825 pointsBadges:
  • What are the benefits of SQL Server 2005 over SQL Server 2000?

    If i am satisfied with SQL 2000 then why I should go for SQL 2005

    Itramkrishna5 pointsBadges:
  • SQL server – Stocks Data -How to Push Data To Client Application

    My client application providing real time stock quotes takes data using a xml webservice which pulls data from sql server 2005.with number of clients increasing for same piece of data, the sql server is being queried again and again.Is there a way to push data from sql 2005 to client application...

    Rak9995 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