Check this article and confirm that you have everything configured correctly, there are a lot of gotchas in 2003 that were not there in 2000.

http://support.microsoft.com/?kbid=555017

If your budget will accommodate, definately go for the RAID 10. Performance and redundancy are excellent. There are other raid options out there, for example RAID7, which is a beefed...

Have you put a hard cap on the amount of memory that SQL uses? Give the Operating System 1Gb of memory to work with. That should help with your system...

If you have the integrity enforced on the publisher (and you are replicating both tables out and these are the tables involed in the problem you are having) you don't...

I am running log shipping with the two servers being different operating systems (primary Win2k, logship Win2k3). I've not found any problems as of yet. However I would upgrade your...

It appears as though the subscriber has a foreign key defined against the table you are attempting to snapshot. As the snapshot drops and then recreates the remote table having...

This will give you the database and users for each database on a server.

exec sp_msforeachdb 'use ?;select db_name() AS DatabaseName, * from sysusers where issqlrole = 0'

From BOL...

sp_dropserver old_servername\instancename

GO

sp_addserver new_servername\instancename, local

GO

You could reverse engineer the db using the diagram option in EM to show tables related from a parent-child relationship standpoint, but from an application related standpoint you're going to...

You should probably use a cursor to iterate through a list of the databases inserting the data into a temp table, then into a main table along with the dbname.

According to the MS site the Small Business Edition of Win2K3 server is just that, Win2K3 Server with some software bundled on it, so no, you will not be able...

Rather than try to eliminate the return of the package execution you should probably establish why the package is failing and fix that otherwise you leave yourself open to other...

From BOL...

SET IDENTITY_INSERT

Allows explicit values to be inserted into the identity column of a table.

Syntax

SET IDENTITY_INSERT [ database. [ owner. ] ] { table } { ON |...

If the server has 2GB of memory why would you have /3GB, /PAE and AWE enabled? You should only use /3GB when the server has 4GB of memory, and /PAE...

The problem with most 3rd party trouble ticket software is that it doesn't give you the option to do that and will create the objects as owned by the user...