Hence the reason it's best to call PSS when doing that.

I still think the best solution would have been to do a backup prior to the upgrade and then...

spireite,

While building recordsets for a single record may seem trivial. As soon as you multiply that creation over all the conceivable connections a web server could have it can really...

Yes,

I just found this work around myself. Here are the steps.

create a new database by same name and same physical filenames as the old ones ( save out the old...

Very nice article Andy! I think I would rather restore the backup that I would have created just prior to installing SP4 though as I think that would simply be...

Look at the topic "Strategies for Backing Up and Restoring Merge Replication" in SQL Books Online.

I have the following ready to do in case of a disaster (I sure...

There is no way to shrink the database during the restore process. The only solution is to shrink the database first and then back it up and restore it.

Gary Johnson

Microsoft...

IMHO this is a really bad practice on a relational database. If you give people the ability to restore only one table in the database you give them the ability...

You might try to use CREATE DATABASE ... FOR ATTACH. But basically what you really want to do is to simply restore a backup of the database. sp_Attach... only works...

Hi gregforeman,

What language are you using to create the text box? Does the text box have a property to turn off the word wrapping of data? SQL Server couldn't care...

I use output parameters when I KNOW that there is only going to be one value returned. Otherwise I use resultsets. There is a lot of overhead to go along...

I haven't had any problems at all with Office XP and SQL2K.

Gary Johnson

Microsoft Natural Language Group

DBA, Sr. DB Engineer

Many times you see the "suspect" database when the drive is too full for the database to be written to. Your solution to restore the database is the best approach...

Try something like the following...

IF EXISTS(SELECT * FROM...)

BEGIN

put your update here

END

ELSE

BEGIN

put your insert here

END

Gary Johnson

Microsoft Natural Language Group

DBA, Sr. DB Engineer

Can you give a little more background on what you are trying to do? Some DDL on the tables structure would really help here.

It seems to me from looking at...

My guess is that the results coming from SQL Server are not actually in the scientic notation format you see but that either Crystal or ASP is doing the conversion...