Search Results | SQL Server Performance Forums

change the location of SQL agent error Log file?

Thread by: xuka200308, Jul 10, 2007, 7 replies, in forum: General DBA Questions

Hi Guru can we change the location of SQL agent error log file after the SQL 2k is installed? we need urgent help on it. where can we change it if...

database restored from server with SP4 to SP3?

Thread by: xuka200308, Jun 11, 2007, 12 replies, in forum: General DBA Questions

Hi All ask a very general question: can we restore the databases from the SQL server 2000 with SP4 to SQL server 2000 with SP3? i got the errors...

diff backup with NOINIT ?

Thread by: xuka200308, May 17, 2007, 3 replies, in forum: General DBA Questions

Hi Guru i just want to clear my mind as i just took over new system. one of our database use full database backup, initial differential backup and...

trigger didn't get fired when table updated

Thread by: xuka200308, Apr 24, 2007, 12 replies, in forum: General Developer Questions

Hi All we have 2 triggers that are used to insert the current date into table when the table is updated/inserted new data. but the question is both...

how to return max date from these date?

Thread by: xuka200308, Apr 17, 2007, 4 replies, in forum: SQL Server 2005 General Developer Questions

Hi All i have these tables in one DB: A, B, C, D, Demo. they all have a column called last_update_dt. the query need to return the last update date...

datetime formate issue--help

Thread by: xuka200308, Apr 8, 2007, 4 replies, in forum: SQL Server 2005 General Developer Questions

Hi i'm not good at SQL programming. but i need to re-format a variable like this: @current_date=getdate() it's "2007-04-08 15:41:54.447" now....

can we remove the name pipe from sql 2k cluster

Thread by: xuka200308, Mar 29, 2007, 9 replies, in forum: SQL Server Clustering

Hi All can we remove the name pipe from SQL server 2000 cluster on windows 2003+sp1? any suggestion would be great. thanks in advance, xk

VB6 connect to SQL error -urgent

Thread by: xuka200308, Mar 9, 2007, 1 replies, in forum: General Developer Questions

Hi All<br /> we have VB6 codes that connect to SQL 2k. it works fine when it connects to SQL 2k+sp3. we got this connection issue now when it...

do i need to install MDAC 2.6?

Thread by: xuka200308, Mar 8, 2007, 2 replies, in forum: SQL Server Clustering

Hi All we are installing the SQL server 2000 clustering on windows 2003 SP1. i did research online and got this: "Setup MS Data Access Components...

anyone has this connection issue--urgent

Thread by: xuka200308, Mar 7, 2007, 2 replies, in forum: General DBA Questions

Hi All please help. we got this connection issue on SQL Server 2000 on windows 2003. the web application couldn't do transaction on sql 2000. the...

can MSDTC share IP address with others? --urgent

Thread by: xuka200308, Mar 1, 2007, 8 replies, in forum: SQL Server Clustering

Hi All we tried to install SQL 2000 clustering on windows 2003. does MSDTC ask to have its own IP address, network name and physical disk? or it can...

FK refer to part of primary key

Thread by: xuka200308, Feb 22, 2007, 3 replies, in forum: SQL Server 2005 General Developer Questions

Hi All i have a question concerning Foreign key. one parent table (called D) uses composit key(Recip_ID+Prov_Num). the child table H doesn't have...

Memory issue

Thread by: xuka200308, Jan 23, 2007, 8 replies, in forum: General DBA Questions

Hi All one of our SQL server has this counters on perfmon screen: SQLServer:Memory Manager: Total Server Memory (KB): 1662320 SQLServer:Memory...

urgent help needed

Thread by: xuka200308, Dec 28, 2006, 2 replies, in forum: General DBA Questions

i tried to restore the master database from old dev server to new dev server. the old one is SQL 2000+sp3. the new one is SQL 2000+sp4. i wasn't able...

How grant db access permission to builtin/admin

Thread by: xuka200308, Nov 30, 2006, 7 replies, in forum: General DBA Questions

Hi All we revoke the 'sa' permission from BUILTIN/administrators account. right now we found that BUILTIN/administrators doesn't have db_owner...

job failed, but data loaded in DTS

Thread by: xuka200308, Nov 21, 2006, 3 replies, in forum: SQL Server DTS-Related Questions

Hi All if anyone has this issue with DTS package. we use DTS package to import data using query from one server to another server. the data is...

what permission required in VB connection string

Thread by: xuka200308, Nov 8, 2006, 3 replies, in forum: General DBA Questions

Hi All i'm wondering that what kind of login permission required on teh SQL Server when VB program connect to SQL Server and load data text files...

Failed to obtain TransactionDispenserInterface?

Thread by: xuka200308, Aug 29, 2006, 1 replies, in forum: SQL Server Clustering

Hi All if anyone know how to fix this issue "Failed to obtain TransactionDispenserInterface" on SQL Server log of SQL Server 2000 clustering?...

any different to put value on left side/right side

Thread by: xuka200308, Aug 25, 2006, 7 replies, in forum: General Developer Questions

Hi Guru is there any difference on performance in sql server 2000 for the following query? one query: select emp_name, emp_title from employee...

how to rename virtual SQL server name?

Thread by: xuka200308, Aug 23, 2006, 2 replies, in forum: SQL Server Clustering

Hi All i got the error message when i tried to disable the jobs that are on our new SQL Server 2000 clutersing. i restored the all databases from...