If I understand you correctly, you want to have a linefeed after each Job information; if so, then simply use char(10) + char(13).

Paul

Do you have frequent database/log backups in place? Are they running at all?

Paul

A very comprehensive article including best practices on table partitioning can be found in the following link:

http://www.microsoft.com/technet/prodtechnol/sql/2005/realpart.mspx

The article also discuss the sliding-window approach and has useful scripts to view the...

You might try googling for a more comprehensive step-by-step instructions, but two things that you might come across:

1. If you try installing EE and find that it only allows you...

OK. Are you performing DBREINDEX or INDEXDEFRAG? Have you modified the fillfactor? How much has it increased by?

Paul

A production server should ideally have the Enterprise edition of SQL Server installed. The Personal edition is primarily used for development work.

Or else migrate to 2005 and use the mirrored backup option. Read up more in 'Introduction to SQL Server 2005 Database Backups' in SSC.

I was more thinking of writing 'stored procedure' scripts to perform these operations.

If you need to execute these from a VB app, you can simply invoke the relevant 'stored...

As pointed out in an earlier post, the process of defragmentation is a fully logged operation, irrespective of what recovery model the database in set to.

If performing many defrag...

You do have a reasonable number of tables to rename as well as a good proportion that you do not want to rename. My suggestion would be as follows:

1. Create...

Are you able to run Profiler during script generation? It might give us some clues as to its cause - It's difficult otherwise!

Paul

Try this:

SET IDENTITTY_INSERT <schema name>.<table name> ON

--your insert statements goes here

SET IDENTITY_INSERT <schema name>.<table name> OFF

Paul

For high availability, you would use SQL Server Clustering. For disaster recovery go for things like log shipping and database mirroring in SS 2005.

Replication is often used for scalibility reasons...

The '2' means start at position no. 2 and the 8000 means all the way to position 8000, that is, all characters from 2 to 8000.

Please be aware that this...

If the login does not exist on the server, then you will need to add it. For an orphaned server, the best approach is to revoke the login for the...