Hi All, Couple records just disappear from a table. This table has no delete trigger, and I was wondering how can I find out who or which service...
Hi All: Please advise me, I need to restore master database to another from production SQL server to test SQL server for evaluate some login...
Hi All: Our database has about 100 users have been either diable or delete from windows accesss. What should a DBA do with these users? what is a...
Hello All: I have a data file (mdf) but missing log file (ldf), how can I attach this file to sql server 2000? I know the data file created by sql...
Hello all, I was wondering if there is such a DDL in SQL Server 2000 like DDL in SQL Server 2005. If not then how can I setup audit database in SQL...
Hello All, I have two questions: 1) How can we use T-SQL to find the database allocation simliar to view database size in taskpad. 2) Is there a...
Hi All, I updated SQL 2000 with service pack 4. However, after applied sp4, I checked the @@version and it is still display as service pack 1....
Hi All: I am looking for third party software that can sniffer all the networks, find and locate database. If you know any please advise. Thanks...
Hi All: The transaction log is 97% full, I need to increase more space. Would you please help? thanks vua
Hi all: I am setting a maintenance job, and I would like to email the result to operator. I noticed the job can send the output to a file but I...
Hello all: I need to perform a failback to cluster node001. I know the process probably take seconds. However, I was wondering what would happen...
Hello all, sorry if this question has been asked. I search and found no similar. My question is how to assign a dynamic database name into a...
Hello all, I was wondering how can count total number of records in every user table without using select count(*) from table_name. thanks vua...
Hello all, I have one table that have over one million of records, I need to reduce number of records in this table. What is the best way to do...
Hello all, I am having problem with the error "Device error or device off-line" when I attempt to backup database to a device. This is what I did....
Separate names with a comma.
