Shrink won't damage the database.

insert into Table1 (ConcatenatedColumn)

Select Col1 + ' ' + col2 + ' ' + col3 From SomeOtherTable

Are you looking for a report of how it looks now, or are you looking to capture changes?

It reduces the size of the log file by releasing unused space within the file back to the...

A single IO (64kb) taking longer than 15 seconds is never acceptable, no matter what may be running. What that warning means if that in the course of 2 minutes...

No, 2000 didn't complain about that. It was laxer on what it considered valid SQL syntaax, leading to the occasional oddity

What it's complaining about is that there are two columns...

SQL 2000 only keeps track of the create date.

select crdate from sysobjects where xtype='U'

"The network has issues"

Networks don't have issues, they have problems. Magazines have issues (weekly or monthly).

Though, given the state of the network, hinting that in only worked properly once a...

Defragging an index means to put the pages of that index back into logical order. If there's only one page then...

Can I make what more clear?

100% sure?...

Actually, it didn't. You posted this on the 14th Aug. It...

The...

The shrink can only reduce the file space if there is free space within the file. If there's no free space, the file can't be shrink. It's not compression or...

Sounds about right for a while loop.

Could you post the code here and we'll help you do whatever it is without a while loop. It's usually possible and almost always...

Query analyser's asking for the login's password. All that's happening with enterprise manager is that it remembers the passwords when you add the servers to the tree. A person needs...