Topics
Started by
Posts
Last post
I ran dbcc sqlperf(logspace) to see what logs I could shrink and by how much. Then, I went ahead a…
7 replies
By: johnchiu
Hi I was wondering if there is any way of getting the user id of a transaction in the transaction l…
6 replies
Does anyone know of an easier way to release procedures in a database say thru a cmd file (ex if th…
1 replies
By: philcart
Hello, I am using MS SQL server 7.0 with SP4 and Enterprise Manager hangs when I click on Current A…
1 replies
My test database went into Suspect status. So, per BOL, I ran sp_resetstatus and DBCC DBRECOVER an…
7 replies
By: mpinnow
I'm in the planning phase of setting up monitoring and alert resources using Tivoli and MON softwar…
1 replies
I have inherited numerous databases that look like they were created to have a 1GB data file and a …
2 replies
By: gts31
Hi All, Does anyone know how to cure the following: Server: Msg 8966, Level 16, State 1, Line 1 Co…
1 replies
Has anyone ever encountered problems with a trigger causing deadlocks? I have many tables that hav…
4 replies
By: Alamir
We currently have roughly 50 Access Databases. We are trying to consolidate these into a SQL 2000 …
4 replies
By: Alamir
Hi All, I run this DBCC script on my database once a week. dbcc shrinkdatabase ([dbname],10) Last t…
1 replies
We are having quite a time since moving a large database to a new server (actually built new server…
7 replies
By: mccork
Assumning there is a very large table in a database, do you have any ideas to make it good performa…
11 replies
I need to update a field in all tables where the field exists. Is there a generic query which I ca…
4 replies
Hey, I would like to simulate a deadlock in the northwind-database using MS SQL-Server. I think tha…
1 replies
By: Ferguson
Viewing 15 topics - 12,526 through 12,540 (of 16,173 total)
You must be logged in to create new topics.