I sent a script called GetFileInfo2 on to this site. If you review this, I am sure you will be able to find a solution to your problem. ...

Please E-mail me.

I have a process in place and will be happy to share this with you. To lengthy to go into here.

Agreed..............

ER/Studio. A little more intuitive than Erwin.

E-Mail me...

I have a solution in place that monitors file growth and alerts me prior to it happening.

Jeff

Hi Brad,

SQL Server is a little different than Oracle and wasn't sure which 'Bulk Insert' you were referring too...

You can set the database into a 'BULK' recovery model with:

ALTER DATABASE...

From an architecture standpoint I really like Buckingham's last post.

Lots of good stuff in this thread!!

Is that W2K SP3 or SQL Server SP3?

Just checking. Thanks!!

Good question..

I dug into the same situation you are about a year ago. If we all were perfect DBA's we would know what distribution stats to create and would...

Nope. No errors on the SQL Server side. Only errors visible came through SAP.

The client configuration never changed. Only the active node of the cluster. All client's are set with TCP/IP first. The odd thing is that the named pipe...

Ooops

I never said what I was looking for... I am hoping to find all/any reasons why there was a change in the use of the network...

How bad can security be....

One year ago I started in a new position at a company that had fired their first DBA of 1.5 years.

Here's what I found:

No sa passwords...

Select into/bulk copy is also very useful when executing the DBCC DBREINDEX command.

I do not believe there is a way to stop all entries in the transaction log....

I performed the detach/attach on a semi-production system. It was our SAP development server. We are testing an upgrade of SAP (actually migrating towards production) and I...

Perfect!!! Thanks