jgee, thanks and please feel free to use it. I'd be interested to see if it works.

phillcart - I looked at Change Manager a couple years ago at PASS and...

Not really brilliant, but this may work:

create table MyTest

(MyChar varchar( 10)

, MyChar2 varchar( 10)

, MyChar3 varchar( 10)

, MyChar4 varchar( 10)

)

go

insert MyTest select 'data1', 'data2', 'data3', 'data4'

insert MyTest select 'data1', 'data5',...

I'd use dts. you can quickly copy structures and limited data.

Steve Jones

steve@dkranch.net

I agree with Paul, however these won't help you detrmine how much more.

Steve Jones

steve@dkranch.net

You can also use profiler and get the "worst queries" by specifying those that take 2 sec, 3 sec, or whatever. This is a good place to start.

I've had decent...

Finally, an agreement!!!!!!!

Steve Jones

steve@dkranch.net

Not much experience here. I've usually tried to go overboard with memory to handle the loads. I'd doubt that there is much overhead, but there is definitely the possibility for...

I use http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp

Steve Jones

steve@dkranch.net

you can also use use datename()

Steve Jones

steve@dkranch.net

What do you mean? Novell has nothing to do with SQL Server.

Your clients are runnig W98 and Novell Netware client? Or Netware BTrieve?

Steve Jones

steve@dkranch.net

You should be able to control the amount of history you are keeping for a database. I think a new fullbackup will clear the old history.

Maybe this will help:

sp_delete_database_backuphistory

Steve Jones

steve@dkranch.net

Not sure about SQL 6.5 Most likely you will want to move from SQL65/Nt directly to W2K/SS2K and run SS2K in 65 compatability mode. You should see some improvment from...

Not sure what you mean. Does SQL run on Novell? I thought it only ran on Windows.

Is this a database move?

Steve Jones

steve@dkranch.net

Brian Knight is our DB2 guy, but from his book, I see you need a provider for Db2. It looks like you are using a SQLServer driver. You need an...

Interesting. This sounds like a bug in EM that was introduced by SP1. Haven't seen it and this is a guess. If reapplying SP1 doesn't fix it, I think you...