Contrary to a statement above, you can declare a PK or Unique constraint - which creates an index - on a table variable.

Table vars can be as good or slower...

Jam,

Yes, it does exist. You can find code examples on the net quite easily. The MS website has some code too.

See DTS Package2 Hierarchy in Books Online.

P

Did you say you have a deal_id column in each of product and asset tables? Can 1 product have more than one deal_id? Can 1 asset have more than 1...

Hi Steve,

Thanks for the reply.

So in my case, @ObjectHandle = reference to the jobs collection object? I've tried that, and I kept getting and error.

Here's the rest of the...

Thanks for the reply.

I know I can use sp_add_job, except I have to run that on the SQL Server I want the job added to first. Using DMO, I can...

We debated long and hard, but went with integer for NANP (North American Numbering Plan) numbers, and varchar for other numbers.

Given the different numbering system and standards around the world,...

This site is a great and free resource. That means take it or leave it. Nobody "owes" you or anyone else comments in any particular language. Code is shared on...

Joe,

I'd be interested to know why you advise against using UPDATE...FROM. Is it purely for proprietary/portability reasons?

P

Yes, using BACKUP DATABASE. And what ArcServe proposes to do is stop the server and/or detach the DB, backup the DB and log files, I guess, and re-start/re-attach.

Seems like madness...

Hey gang,

I appreciate each of your input. I suspected I was right all along, but... I cut'n'paste below (in quotes) the original notice I received from my management. The background:...

DM,

This will back up all DBs except pubs, Northwind, and tempdb, to the path you specify. Files will be named according to this format: _Dump.bak.

IF OBJECT_ID('dbo.utl_backup_DBs') IS NOT NULL

DROP PROCEDURE...

Why on earth would someone want to alphabetize the fields in the table? What if you need to add another field? Drop constraints, copy data out, drop table, re-create table,...

Another suggestion is output paramaters to the sproc, if that can be applied in this situation.

P

You need to do some more research, and evaluate how and where these tables are going to be used.

In short, @tables are not always the best way to go. As...

#tables in sprocs cause recompiles under certain conditions.

Using Profiler, monitor the sp_recompile event, and select the Sub-class data column. Then, go see Q308737 on MS website for an explanation of...