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...
Please advise me, I need to restore master database to another from production SQL server to test SQL server for evaluate some login...
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.
FULL: you can do backup trans while SIMPLE you can't.
thanks, I will search and post the search result.
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.
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,...
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...
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....
I am looking for third party software that can sniffer all the networks, find and locate database. If you know any please advise.
The transaction log is 97% full, I need to increase more space. Would you please help?
Thank you so so much MohammedU.
This forum is so so valuable to us.
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.