Viewing 15 posts - 7,366 through 7,380 (of 7,428 total)
Also you may want for sake of not causing undue growth again want to clean the indexes and update usage to have the database in order before you try shrinking....
February 6, 2002 at 12:48 pm
I agree with all, I mean even if you can turn it off you are creating a larger issue for yourself, especially when that occasionally problem occurrs and you don't...
February 6, 2002 at 12:37 pm
I have those processes in a job I run based on the size and number of non-clustered indexes I have on a database. But you will always have something to...
February 6, 2002 at 6:34 am
How is this file delimited, if quotes does the first line have a extra quote you do not expect. Or maybe if tab then a tab if off. I have...
February 6, 2002 at 5:14 am
Start SQL Server profiler and look at the connection from the begining to the point of failure watching how many connections are created and destroyed. You may also want to...
February 6, 2002 at 5:07 am
Well, first off this is actualy the SQL Server Logs, and contrary to the name not only errors are stored there. If they are filling up fast then make sure...
February 6, 2002 at 4:33 am
Actually and oddly enough I like the exam cram books. They are simplistic and cover a lot of what you need to know on the tests as well.
February 5, 2002 at 6:17 pm
Fortunately for me it was at Christmas and not too many people needed it. After a few days another programmer who read thru my comments and code and found my...
February 5, 2002 at 6:14 pm
Sorry the Micrsoft SQL classes. I like SQL as I had a long experience with Access.
February 5, 2002 at 6:12 pm
Do you have Office installed? Or did you install a SQL 2000 eval edition?
February 5, 2002 at 5:49 pm
Did you ever setup a linked server or a DTS package that referenced an Oracle databse. If so and you removed the client that reference is being fired.
February 5, 2002 at 5:02 pm
Try the most current MDAC on the server. Sometimes the MDAC can be corrupt, so even if you are runniong the same revision the server may have a flaw it...
February 5, 2002 at 4:59 pm
But it only remains there so long before it is flushed to give room for other histories. There is a way to increase the size which was on the MS...
February 5, 2002 at 4:55 pm
Sorry, but alas no. And I don't believe any of the new 7 service packs make a difference either.
February 5, 2002 at 4:53 pm
The problem is that the # temp table only exists for the duration of the process. Technically the source runs then the transformation but because the transformation is to SQL...
February 5, 2002 at 4:48 pm
Viewing 15 posts - 7,366 through 7,380 (of 7,428 total)