• SQL 2005 trial version update

    I installed SQL 2005 trial version on a production server and the 6 months are almost up. I would like to go to SQL 2008 since I can get a very good deal for it. What options do I have? Can I just upgrade over the trial version or I need to uninstall 2005 and reinstall 2008. The 2005 is a trial for...

    Alan Dala30 pointsBadges:
  • Backing up SQL Server 2005

    Where can I find information on backing up SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Outputting results of SQL SELECT statements into a spreadsheet

    I am using OPENROWSET to output the result of a number of SQL SELECT statements into a spreadsheet. It works for most of the SELECT statements, but there are 4 random queries out of 82 that take more than an hour to execute. This is the code: insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Restoring to the end of a log backup in SQL Server bulk-logged recovery mode

    In bulk-logged recovery mode in SQL Server, how can you restore to the end of a log backup that includes a bulk event? It seems to me that everything after the bulk event is useless. How could I do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Temp Tables

    Hi, My question is basic and should be simple to answer I assume. I'm a beginner so I don't know much about Temp Tables? Can you please show how Temp tables work and the concept behind them. Thanks, o

    Omaleem5 pointsBadges:
  • 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:
  • Backing up SQL Server with specific settings

    I have set up my SQL Server backup using the native backup and restore option, but I want to have the files append for 5 days and then have the original file overwritten for the next 5 days. Right now, it's set to append the entire time, and this fills the disks rather quickly. How can I achieve...

    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:

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