duration is milliseconds

from BOL:

Duration 13 Amount of time (in milliseconds) taken by the event.

Steve Jones

steve@dkranch.net

What's RAID 1 + 5?

Some options,

Software - Nt/2K support software raid, but will be slow.

Hardware - there are some cheap Adaptec cards. If yuo search Ebay, you might get really...

no idea at all. Don't have auto-shrink set on any of my dbs.

Steve Jones

steve@dkranch.net

Dim sConn, objConn, rsTable

Set objConn = Server.CreateObject("ADODB.Connection")

Set rsTable = Server.CreateObject("ADODB.RecordSet")

sConn = "Provider=SQLOLEDB; Data Source=MyServer;" & _

"Initial Catalog=pubs;User ID=steve;Password=stevespwd"

objConn.open sConn

Set...

Should be the same. The client interperts the text v image data. It's all just bits. You can open a jpg in notepad, just looks funny.

Steve Jones

steve@dkranch.net

I use #1, but like this:

declare @err int

select @err = 0

-- do something

insert.....

if @@error <> 0

select @err = -1

-- do something else

update.....

if @@error <> 0

...

You can also CAST columns to match each other.

Steve Jones

steve@dkranch.net

Can't restrict sa, similar to the inability of restricting the domain admin. what is missing, however, is the auditing ability (or the take ownership tracking) in SQL. I've seen this...

You are welcome and thanks a bunch for the followup. Hopefully this will help someone else.

Steve Jones

steve@dkranch.net

3M rows!!! Yikes!!!!, could probably rewrite and get much better performance.

My suspicion (and that's all it is) is that the fibers are making a difference. Also, check...

A good career move for you.

Please come back and ask more questions, we love to help!!!!!!

(also visit some of our sponsors

Steve Jones

steve@dkranch.net

You should be able to just place the data files on the SAN and set the proper pathing (if the SAN can be addressed as a \\server\share.

As far as something...

I don't think they do, but you'd have to try it.

Steve Jones

steve@dkranch.net

Can you post some code?

Steve Jones

steve@dkranch.net

That's a good point.

check all db settings before backup and after. See if something changed.

Steve Jones

steve@dkranch.net