Remi,

as we say; "There a many ways to Rome".

When I started within ICT I learned it the scripting way. Nowadays its a click and ready application doing the job for...

The maximum number of bytes per row is 8,060.

will be less if you use replication !!

GKramer

The Netherlands

Seems that your page chaining is corrupt. the database can not find the items on the right spot on the pages. Try Reorg or Reindex ( if DBCC checkdb (repair) does...

Before purchasing the SQL Source Control from Skilled Software please evaluate Visual Source Safe from Microsoft. I once used it in a medium - large environment and it worked fine.

I...

Dumb Questions DO NOT EXCIST !!!!

try;

select <all columns you need> 

into #temp_table

from original_table

drop original_table

select *

into original_table_remake

from #temp_table

GKramer

The Netherlands

Some tips to help monitoring all the active servers.

A) Setup a linked server to every active server from you maintenace server.

B) Write A script (SP) to retrieve every database on each...

Steve,

Reading the two related articles I could not agree on the mentioned symtoms (I thought).

The "Kill that target server" article mentioned the server has been moved and the Microsoft PRB...

newbie......( Charl )

you can monitor the servers automatically

The original question is / was "how to administer" !!!

Grasshopper.....( Jonny )

I also have to administer 160-170 sql servers ( several hundreds...

from bol;

*********************************************

SET FMTONLY

Returns only meta data to the client.

Syntax

SET FMTONLY { ON | OFF }

Remarks

No rows are processed or sent to the client as a result of...

just a thought....

use one of the DBCC commands ( DBCC checkdb )....

GKramer

Hi,

plaese try "SQL server compare" ( freeware ) .. just 1Mb and very user friendly.

GKramer

Hi

I use the DTSbackup2000 utility ( freeware ) .....smooth and easy.....recomandable..

GKramer

ALZDBA,

Thanks for replying, but the links couldn't expand my knowledge. The articles give an overview what it is and where you can use it for but that part I heard ( and...

Brows the Internet. There is an enourmous ammout of information about undocumented sp's.

http://www.databasejournal.com/features/mssql/article.php/1490641

Regards,

Gkramer

For backup files use the copy past mechanism trough your LAN. ( backup and restore )

This same goes for the datafiles after ( and before ) attaching and detaching.

How easy it can...