Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 3 of 3
Search took 0.01 seconds.
Search: Posts Made By: tshab
Forum: SQL Server 2000 March 16th, 2005, 05:02 PM
Replies: 2
Views: 507
Posted By tshab
Doesn't seem to be an option on restore, but I...

Doesn't seem to be an option on restore, but I scripted it to occur just after using:

EXEC sp_MSforeachtable
Forum: SQL Server 2000 March 16th, 2005, 03:06 PM
Replies: 2
Views: 507
Posted By tshab
So DBCC DBREINDEX (mytable, '', 70) fixes the...

So DBCC DBREINDEX (mytable, '', 70) fixes the problem...

Is there a way to do this automatically on restore?
Forum: SQL Server 2000 March 16th, 2005, 02:49 PM
Replies: 2
Views: 507
Posted By tshab
Default sort changes after restore on new machine

Hi,

I migrated a database using backup/restore. On the new machine, a select * from one of the tables will not be in order of the index (a clustered index based on the column1, asc., it's an int...
Showing results 1 to 3 of 3

 


All times are GMT -4. The time now is 04:33 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.