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...
I wouldn't set the database to SIMPLE mode if the database has many transactions on daily basic. So if you have your log in autogrow mode, then one...
I don't think there is any different in performance, however you may not be able to truncate the log once is full.
Well someone here recommended sp_attach_single_file_db, however my database has one filegroup, the only missing is the log. In...
Big difference: FULL: you can do backup trans while SIMPLE you can't.
thanks, I will search and post the search result.
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...
When I said audit I mean there will be a notification when a user delete an object. thanks
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...
I am using SQL Server 2000 .
On the ADO.NET side try to use DataReader is very much faster than other objects On the SQL Server use profiler to trace memory usage, disk usage,...
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...
I restarted the windows, so I guess it also restarted SQL Server. But it still doesn't show as sp4. Let me apply the hotfix see if anything...
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
Thank you so so much MohammedU. This forum is so so valuable to us. Cheers, 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...
Separate names with a comma.
