Viewing 15 posts - 136 through 150 (of 153 total)
I changed my mind. You have to be looking at the enterprise manager at the time of the deadlock to let that work.
Use the profiler and select SQL:BatchStarting,Lock:Deadlock and...
November 15, 2002 at 5:22 am
The simplest solution is by looking in the enterprise manager.
In the map current activity\locks you can see the current locks. It shows if a lock is blocked and by...
November 15, 2002 at 4:19 am
Raid 0 does not mean mirrored. Raid 0 is striping (Raid 1 is mirroring).
The Books online say the following:
<quote>Filegroups allow files to be grouped together for administrative and data...
November 14, 2002 at 1:43 am
As I was busy anyway, I tried it with SP1.
The problem also occurs here.
November 13, 2002 at 5:59 am
I am just upgrading SQLServer 7 to SQLServer 2000.
A test shows that SQLServer 2000 without Service Pack also has the problem.
November 13, 2002 at 4:06 am
Use DTS. This is easiest with the export or import function on the right-shift menu.
It has enough options for most purposes.
November 13, 2002 at 3:57 am
If you do not give the group public permissions to the tables, the user will only have those permissions you give him.
Joachim.
November 12, 2002 at 6:59 am
I also just tested SQLserver 7 sp 4 without any problems.
I guess it is a bug.
November 12, 2002 at 5:33 am
This is SQLServer 2000 SP2. I still have to check it out for SQLServer 7.
November 12, 2002 at 4:36 am
I was looking for this myself this week.
The following does it:
DBCC INPUTBUFFER (spid)
November 2, 2002 at 3:09 am
You have checked "attempt to repair minor problems" in the maintenance plan. The job putso put the database in single user mode, whether it needs to repair or...
October 31, 2002 at 11:48 am
There are ways to read files that locked by a writing process.
"type filename | more" on the command line always works as far as I know.
Several editors can do the...
October 29, 2002 at 1:59 pm
query timeout:
sp_updatestats might help.
If that does not help you can also change 'query wait' with sp_configure
Default it is -1, which means 25 times the calculated time for the query.
You...
October 29, 2002 at 12:51 pm
This might be a permissions problem. Check the owner of the service.
It should have rx permissions on the sqlserver\binn directory and on winnt and winnt\system32
I also saw this...
October 29, 2002 at 12:35 pm
I have seen that locks cost memory and time.
That is the reason that one table lock is better than millions of row and table locks.
October 26, 2002 at 5:31 am
Viewing 15 posts - 136 through 150 (of 153 total)