Search Results | SQL Server Performance Forums

ADO connection fails

Thread by: erg, Apr 10, 2006, 2 replies, in forum: Non-Transact SQL Developer Performance Tuning

Getting following error... Provider (0x80004005) Unspecified error I can connect directly to sqlserver by VB/ADO. However, I cannot get access to...

SQL update optimization

Thread by: erg, Aug 26, 2005, 2 replies, in forum: Performance Tuning for DBAs

Normally, I only see the source table named in the FROM clause of an UPDATE query. However, the only place to put index hints is the FROM clause. I...

sql table

Thread by: erg, Mar 25, 2005, 2 replies, in forum: Performance Tuning for DBAs

Is there a way to determine the last time the contents of a table changed in SQL 2000 for QA purposes?

DTS Oracle 9i to SQL server 2000

Thread by: erg, Feb 24, 2005, 1 replies, in forum: SQL Server DTS-Related Questions

I am getting error when I use DTS from Oracle 9i to Sql server 2000. Error message: It can not login to oracel? I know username and password is...

create view

Thread by: erg, Jan 26, 2005, 2 replies, in forum: General DBA Questions

Which permission do I need to create view in sql database? THanks

Maintenance Plan

Thread by: erg, Sep 28, 2004, 1 replies, in forum: General DBA Questions

I backup my sql via maintance plan. My maintenance plan dumps the database and transaction log. Which order should I dump the database and...

Maintance Plan

Thread by: erg, Sep 17, 2004, 5 replies, in forum: General DBA Questions

I am gettig following error when I ran Maintance plan? Executed as user: serverAdministrator. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029)....

Transaction log

Thread by: erg, Sep 17, 2004, 6 replies, in forum: General DBA Questions

I have a database setup with 2 Transaction log file. Now I don't need 2nd log file anymore. How can I delete the 2nd Transaction log file. I have...

Transaction log

Thread by: erg, Sep 13, 2004, 4 replies, in forum: General DBA Questions

I have 20GB database with 50GB lof Transaction log file. Now I do not have any space for the backup.? Any Help..Please. How can I make so,...

log file

Post by: erg, Jul 18, 2003 in forum: General DBA Questions

Thanks for the quick reply. I have setup to backup transaction log every hour and also its on its own mirror drive. I hope it will resolve the...

log file

Post by: erg, Jul 18, 2003 in forum: General DBA Questions

I have setup file growth by 30%. My transaction log file is 9GB in size. Now I am running out of space on my Log mirror drive. Also i have setup...

log file

Thread by: erg, Jul 18, 2003, 6 replies, in forum: General DBA Questions

I am running sql server 2000 and having a problem with transaction log. Transcation log is keep getting full. This is what the error message on...