No books that I'm aware of. I've never read one about Tandem. I've had to learn everything on-the-job or in training from the company. It really is...

That's right.

If your aim is to have an exact copy of the original database, I'd go with backup and restore with move. I've had trouble transferring users and permissions with...

I second the suggestion to backup and restore because detaching and moving the database files will require downtime.

I was going to suggest mirrored backups before I read your second post. Now it seems you want to consider backing up over the network. We've done this...

Suji,

Since you mention Enterprise Manager, I assume you're talking SQL 2000. You know you can script all the jobs in an instance in Enterprise Manager by right_clicking on...

My take on this is that it doesn't really doesn't have to do with Query Analyzer. The ability to query and change data is wholly dependent on the object...

The easiest way I can think of is to us the 'generate SQL script' database option in Enterprise Manager. R-click on any database, choose 'All Tasks' then 'generate SQL...

What if the stored procedure is encrypted? I don't think sp_helptext will display anything if it's encrypted in syscomments.

Greg

Are you asking about Tandem NonStop, now owned by HP? I've worked on Tandem systems for about 20 years. Is there anything specific you want to know?

As for...

The table is being created because that's what SELECT INTO does. If you were to use INSERT INTO SELECT, you could precreate the table.

Do you want to add identity...

Read about the SQL Server Agent fixed database roles i.e. SQLAgentUserRole, SQLAgentReaderRole, SQLAgentOperatorRole in BOL and see which one fits your needs. Members of the roles can create and...

Have you tried assigning an alias to the count (e.g. count(*) as count_num) in the select list? The Transform Data task needs that to map it to a column...

Database roles and users are included in a full backup, so when you restore it, they'll be in the database. You'll need to be sure that the logins that...

And what are the circumstances/messages associated with package failure? If Integration Services is not running, you can't execute packages. Are the packages saved on the server where SQL...