Try this:

DBCC SHOWFILESTATS WITH TABLERESULTS

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

Ah, great that it's OK now. Interesting however what caused this. Probably have to wait until next time it happens to find out.

--

Chris Hedgate @ Apptus...

Ken, it looks pretty cool and I'll have a better look at it later. However, just a note, you can set up a linked server from SQL Server to...

quote:

---

I am trying to connect via TCP/IP instead of named pipes. I am not sure how to use named pipes. ...

Dalton, could you post the code used to display the data from ADO Recordsets?

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

Hmm, interesting. I found the part in BOL so you don't need to worry about me misunderstanding you. They are not talking about erasing the registry in Windows, it describes...

What network protocol are you using to connect?

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

YEs, I think it will be faster. Another option is to simply detach the database from instance A, copy the files (at least the data files, log files will be...

Why don't you just make a full backup of the database on instance A, then try to restore it to instance B. If this works then you know the backup...

Simple answers: yes, yes, yes.

Not so simple answer: It depends.

For the last question the answer is definately yes, you can set up multiple databases on any...

Never heard of that, but of course there could be some bug in it that could do that. Where did you read it?

Do you have any alerts defined?

--

Chris Hedgate @...