• 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:
  • 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:

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