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...

Hi Stefan,

Of course you can pass the name of a new DB. You'll need a way to create it -- this would likely be a stored procedure which accepts the...

OK. I usually monitor Stored Procedures - RPC Completed and TSQL - SQL Batch completed. In the Data Columns tab, defaults are usually fine. Makre sure TextData and Duration are...

Turn on SQL Profiler, capturing the output to a table (this also has a cost, unless you're writing to another server). Make sure that you're getting the SQL/stored procedure calls,...

You might want to use initials. What will you do if you do have 2 John Walkers with same DOB?

P

Estuardo,

Not sure if previous reply made it...sorry if this is a repeat.

A few things:

1) You need a datatype for col1 of your #tmp_table.

2) I was able to do a similar...