Thanks again for the insight, luckily (maybe) the admin did listen to me and our databases have no public connections, (behind hardware and software firewalls and and such), and...

Again we are on the same line of thought. With what needs to be done. I have been getting one person at a time to understand and buy in on...

Again, I agree with you, and "pitched a fit" when we finished the disaster recovery "plan" and the company decided not to actually test it.

I am left wondering much...

Thanks all, fortunately for me, I work for a separate division in the company, and the CEO here does not trust the IT director's skills, and hence through a long...

Thanks for the replies so far, and yes, everyone of the disasters and questions I have asked in the last year or so of management. At least I know I...

I agree there Steve, I do have some input on who gets hired to work with me, and I would much rather have someone with experience than an Ivy League...

Interesting as always Steve.

I am one who is between the "older" workers and the "young" workers in age and experience. Yet I seem to do better based on the value...

Yes infact you can limit the transaction log usage with a commit on every so and so records using the data transform task in DTS. The last tab on...

Thanks Jo, I will try those things.

Actually, autoshrink is not needed, I have since turned it off, though that does not stop the one which has started already.

Unfortunately, there are...

I am still poking around, I just noticed one of the DB's had autoshrink on, and it is running at the moment. The DB is an archive DB so not...

Thanks Jeff.

That helps alot!

Ugh, this vendor system is filled with the not set based, and such logic. Its enough to make one wonky.

Hi All,

Nightly I have dozens of DTS imports from an Oracle DB to SQL2000.  I experienced the same performance issues when using a linked server for any tables over...

Myself, I have custom built mine, a ASUS PS8X-X motherboard, P4 3.06 Ghz Processor, 1 Gb PC2100 Ram, DVD Burner, GeForce FX5200 Vid Card, 200 gb hard drive, and the...

When you open the query analyzer for Excel the Choose Data Source window has typically a check for use the query wizard to create queries, uncheck this, and select your...

I had this problem, in my case the answer was as simple as updating the PC with the Enterprise manager to the same version as the server, and installing the...