Something to consider...

The SQL Server service account does NOT need to be in the Local Administrators group of the host machine. Elevated privileges of that degree is not a...

Michael,

A couple of things come to mind...

Access & permissions... The SQL Agent Service account must have the appropriate access to the destination server and permissions within the destination database....

I wrote an automated checkdb, backup, updateusage, defrag, reindex, update stats system back in the 6.5 days that handles all of the busy work.

Thirty servers is a handful and I...

To parrot that which has been noted already, the SQL Agent for Veritas, in addition to being a substantial expense if you have several servers, is not reliable. Also,...

One other minor cautionary note... For those of us that deal with Daylight Saving Time (or other arbitrary time shifts), the UDF_UTCDATE function will only work if the

We ran into a similar issue and used a table valued UDF to resolve it.  You can join to the UDF result set.

FUNCTION...

Another consideration, if the PK is clustered, is the inclusion of the key in all non-clustered indices.  The larger the clustered key, the larger the NC indices will be.

Regular SQL Server backups to disk are your best bet.  You can set the GeoDatabase(s) to full recovery and execute full/diff/tran backups scheduled as makes sense for you.  When something...

A little leisure reading for those of you that may be a little rusty on the topic of propositional logic:

http://www.earlham.edu/~peters/courses/log/terms2.htm

Although lacking a specific example of its use, the article...

There is a whole slew of automatic type conversions that can occur if strict datatyping is not observed.  Take a gander at Data Types [SQL Server]: Precedence in BOL.

See SET ANSI_WARNINGS in Books Online, I believe that may be your problem/solution.

I had problems with a similar scenario & ultimately had to put everything in a single tran.  You can use @@TRANCOUNT to determine the nesting level but in the end,...

Actually, a trigger that inserts into a table with an IDENTITY column will 'mask' the identity you are expecting.

To limit the value returned to the table within the scope of...

In order to have a single row resultset and be able to distinguish between the values (i.e. different columns), something like this might work...

      SUM

Copying the files is the first step.  Attaching the files as a db, so the SQL Server knows they are a db, is the second.  In SQL Enterprise Mgr (2000)...