convert and cast will do it.

It depends.

We have an application where it is 2:1 and one where it is 10:1

Without logging mode the logfiles can be much smaller.

With logging mode it depends on the log...

SQLBill is talking about the logon user of the service that you can see in the properties of the mssqlserver service.

Does the eventlogs show an error?

And the sqlserver error log?...

You can write a script that makes select statements from the information_schema views and do a windiff between the results.

Something like:

select * from information_schema.columns order by table_schema,table_name, column_name

select * from...

To check the network you need the look at the object "network interface"

The counter "output queue length" must be zero. Packets should not need to be queued.

bytes total/ second...

The most reliable way I found is using convert. set dateformat only works for input and that can really confuse users as they see the date they just entered back...

As far as I know logical log backups do not refer to a complete or differential backup at all. They just continue from the last logical log.

After you restore...

I have the BOL "Maxium Capacity SPecification" page in my favorites

It says 32,767 databases for both 7 and 2000.

Joachim.

We also have seen differences between SQLServer 7 and 2000. We looked for the differences with the profiler on both servers (And sqlserver 2000 with 70 compatibility) looking using...

Maybe it goes fast just after am auto update statistics.

But you really need more data. There must be a bottleneck: cpu, i/o, memory, network (the last sounds unlikely, but...

All you have to do is the following:

shutdown sqlserver.

move the current mdf, ndf's and ldf files of the database away, just to be safe.

copy the old files to the place...

Another possibility:

I had this once where the culprit was the ISA client. For some reason the update program tried to connect to the database through the firewall Other...

I once wrote scripts to do this.

At the moment I can only find the trim script:

select 'update ' + o.name + ' set ' + c.name...

Allen, what you say about export from SQLServer 7 is correct, but an import from the SQLServer 2000 of a SQLServer 7 database works fine. Detach/attach and backup/restore are...

That is it. I can now control it in isqlw with the connection properties and in ODBC with 'Use ANSI nulls, paddings and warnings".

Thank you.

Joachim.

...