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...
check this link for SQL 2000 SP3 support
i checked the SQL Log file and found that: "BackupFileDesc::VerifyCreatability: Operating system error 32(The process cannot access...
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...
yeah. we have the same message too. there are not any duplicate records from source table. we use DTS package to copy data from one server to another...
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...
check this link:
thanks All for your great thoughts.
i found why the triggers failed to fire. our DB setting of recovery model is simple.
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...
thanks for quit reply. but my query look more complicated. i try to modify the coding in
when max(A.last_update_dt) >(Demo.last_update_dt)...
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...
thank you all for your reply. they are really helpful to me.
have a good day
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....
we have installed SQL 2k on win 2k3 already. i wanted to know if the named pipes could be removed after SQL Server was set up.
how to understand this one @http://doc.ddart.net/mssql/sql70/1_server_17.htm
SQL Server supports a subset of available network protocols when...
we removed named pipes from non-clustered SQL Servers based on the security requirement--our company has this security policy.
yes. but we installed SQL 2000+sp4 on win2k3+sp1. any different?
thanks for quit reply.
can we remove the name pipe from SQL server 2000 cluster on windows 2003+sp1?
any suggestion would be great. thanks in advance,
the MS DTC configuration is different. the other process is the same.
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...
Separate names with a comma.