create table mytable (id int, firstname varchar(10), lastname varchar(10), tele varchar(10))

go

insert mytable select 1, 'John', 'Smith', ''

insert mytable select 2, 'John', 'Smith', '5553333333'

go

select * from mytable

go

update a

set a.tele =...

I think George has it right in his last post above here.

Great discussion!

http://blogs.conchango.com/jamiethomson/archive/2005/12/05/2462.aspx

DDL triggers are good for finding stored proc changes.

If you want data changes from a specific proc, Profiler or a server-side trace. You could log things into another database.

Do you mean the query files open again automatically? I don't think this is possible. You can open SSMS and have a file open, but not sure it automatically opens...

Not sure. This is a simple process that should work. I'd uninstall, reboot, reinstall. Might be something flaked.

Less is more, use few slides, don't read them, put information on them you will talk about, but other than a way to keep people organized, I wouldn't use Powerpoint.

If...

You never know who will win. I wouldn't think that anyone who posts a lot on the site has much more of an advantage than someone that posts little. It's...

Thanks and the comparison is to stimulate debate. Think about it, we teach and learn by example, we are always comparing A to B, trying to better understand the world.

Lots...

Correct, a .bak is used in DR situations. There will be no MDF/LDF. They will be created during the restore process, at the sizes needed for the backups.

You can look...

If you need to use languages outside English, then use Unicode. If you are sure you won't, then stick with regular varchar.

There are lots of ways to do this, but most of them come down to being organized and standardized in how you approach deployments.

I wouldn't give anyone Visual Studio...

Use a production backup and obfuscate the data.

Buy a tool. Red Gate has a data generator you can use.

In this case GUIDs are a better choice. You can use identities, but pick ranges for each system, large ranges, if you do.

Don't cross post.

Answered here: http://www.sqlservercentral.com/Forums/Topic511041-146-1.aspx