There is also a "Create Stored Procedure" Wizard available from Enterprise Manager under Tools - Wizards - Database. I've never used them but you could try it out.

Steve

If you are importing data from an outside source and a field that should be numeric has bad data in it, you might need to import it into a char...

Transaction log backups will not work properly if you do not have a full backup (SQL-Server) to begin with.  I would be nervous about relying on Tivoli (if it is...

Wayne,

I would definitely use Full recovery unless there is a problem with space.  You will also need to make sure the transaction logs get backed up regularly or that could...

Wayne,

SDE is not just one table per feature class.  Since SDE provides the capabilities to have multiple versions of the map, the data is stored in the base table plus...

I'd like to reinforce what was said about columns containing NULLS.  If you have columns that are more often NULL and you can find group of columns that are contistently...

Another common way to grant permissions is to create user roles and assign permissions to the role (through Enterprise Manager or Query Analyzer).  Then as new people are added you...

I'm glad it works for you.

Steve

Is there a drive O: mounted on the server?  Remember, jobs run on the server, not your machine.  You should probably use the share name instead of a drive letter.

Steve

It all depends on the data you are working with.  For example, a list of 1, 2, 8, 9, 10, 10a, 20, 89 would be sorted as 1, 2, 8,...

I have no experience with tansactional replication so I wouldn't know.  Sorry.

Steve

Are you doing snap shot replication?  If so, this is how I would change the schema using enterprise manager.

Right Click the publication and select Properties.  On the Articles tab, drop the...

Just a shot in the dark, but are you transaction logs being backed up every 10 minutes?

Steve

If for some reason you needed to keep in varchar (I'm not recommending it), you could do the following:

ORDER BY len([data]),[data]

Steve

I would set up a role that you assign "everyone" to (or at least a large group of users).  When you create a table or view, be sure to grant...