• SSIS package

    I am supposed to Run an sproc /script for more than one database. I thought of scheduling this sproc as a job for all database instances. But, DBA's suggested me to go with SSIS Package. Can any one quide me in doing this.

    MSDEVELOPER5 pointsBadges:
  • sql server stored proc question

    Hi the code is like this. Its taking too long to excute. if exists(select jbadsd from saldayf sa where substring(convert(char(7),sa.jbadsd),4,4) = substring(convert(char(7),@jbadsd),4,4) and substring(convert(char(7),sa.jbadsd),2,2) = '07') --print'exists' update [national].dbo.tempsaldayfna set...

    Gullu15 pointsBadges:
  • Webpage and SQL interaction

    The problem I need to figure out is that I need to have client information stored on an SQL server database and I need something to be able to use this information to get quotes from several insurance companies. All these companies require different info in a different order. So my questions are as...

    Katy20 pointsBadges:
  • restore server folder Veritas Backup Exec 9

    How do I select a specific folder on backup tape(Veritas exec9) to restore a folder on server 2003

    William687710 pointsBadges:
  • Error message when creating a table in SQL

    Whenever I try to create a table in SQL, I receive the error, "No disk space." How do I create more disk space on my Oracle server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can I connect my local machine to the SQL Server 2005 Enterprise Edition?

    How can I connect my local machine to the SQL Server 2005 Enterprise Edition?? I can't even run the local service instance

    Jimena8a5 pointsBadges:
  • Application using VB6 & SQL

    Dear sir, I am computer data entry operator, i would like to make one simple application reg Payroll using VB6 and SQL. I know only some basic commands in both but i dont know what are the steps taken first what we have to do (crating forms in vb or creating tables in sql or other i dont know...

    Lahari5 pointsBadges:
  • Securing a SQL Server 2008 database

    I am on SQL Server 2000, and to secure my database, I want the user to be prompted for a user ID and password before the database is expanded. How might I do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Differences between values in a SQL Server 2005 database

    What is the difference between the Checksum and TornPageDetection values of the PageVerify option in a SQL Server 2005 database's properties?

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

    How to format crlf inside a field text

    2601515 pointsBadges:
  • SQL Server 2000 error in log: WARNING: EC 5c3320c0, 9 waited 300 sec. on latch 44173b2c. Not a BUF latch.

    I am seeing this error weekly in the sql server log with associated performance hit: WARNING: EC 5c3320c0, 9 waited 300 sec. on latch 44173b2c. Not a BUF latch. Has anyone resolved this error?

    Ftornoe40 pointsBadges:
  • Connecting to a remote DB on a UNIX server with SQL

    I am trying to connect to a remote DB on a UNIX server. I am using embedded SQL statements to achieve this task. I have a file that contains DB name, ID & PW that I pass to the connect statement, rather than hardcoding the info to the program (for security reasons). C EstConnect BegSr * C Eval...

    AS400 - Ask the Expert485 pointsBadges:
  • SQL proceedure to join header and detail file

    I want to know how to set up a SQL procedure that joins a header file and detail file where the status field in header = 'X' then updates this header record after selecting the detail records.

    AS400 - Ask the Expert485 pointsBadges:
  • ABT database backup from SQL Server 2000

    hi please tell me that, if i am using vb as front end and sql server 2000 as backend then for giving the facility of implicit periodical data backup at project, how can i go......through vb coding...

    Nileshmahadik5 pointsBadges:
  • JDBC/ODBC to Excel 2007 getting Exception

    Iam getting the SQLexception by trying to connect using JDBC/ODBC to Excel 2007 through Java. Any Guys can tell abt this problem. java.sql.SQLException: [Microsoft][ODBC Excel Driver] External table is not in the expected format. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at...

    Ansipar288315 pointsBadges:
  • Strange Stored Procedure Behavior (Dev vs Prod)

    I have a stored procedure that runs on my Production database in 0.394 seconds. However, when I try to run the SP on a DEV box it takes well over 15 minutes to run *every* time. I have checked indexes and everything seems to be identical (I did a backup/restore to the Dev box in the first place)....

    Noonway25 pointsBadges:
  • Deploying reports created in SQL Server Reporting Services

    We have SQL Server Reporting Services installed and I have created several reports. However, I cannot get the Report Manager website to work so I can deploy the reports. How would I do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • os on data base servers

    do you need an os on a data base server if you have sql loaded

    Carman5 pointsBadges:
  • SQL problem

    Hi, Iam having two sql servers 2000 and 2005 are installed on the same server. When i run any application it is directily hitting the 2005 serve but i want the application to to hit sql 2000 server only and when i want to hit it to sql 2005 it should hit it means vice vers can some one help me in...

    Vemuseshu5 pointsBadges:
  • Linking sqlserver to oracle

    How do I create a link to oracle 9i form sqlserver I can tnsping oracle, I can connect via sqlplus, I can connect in odbc admin, I can connect via a udl, I can connect via ssis but I get ORA-12154: TNS:could not resolve the connect identifier specified when I try to set up a link in the management...

    Wgself65 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