You should definitely NOT allow incorrect data to be recorded in the database.

If you have enough info to determine what the proper data should be, then do so, and let...

Thanks Ninja.

Interesting thread. I may yet opt for the sqlfool colour scheme solution as well. Nothing like a visual in-your-face clue.

Bob's solution is definitely working for me, it's not too...

Robert,

That's close enough!

Much appreciated.

P

Wow.

Glad to see I'm not the only one who wishes it wasn't made so easy for us to make a Really. Bad. Mistake.

Hey Microsoft: Can we PLEASE have...

Doesn't do it. On both sprocs, sp_depends returns no results.

if object_id('proc1') is not null

drop proc proc1

go

create proc proc1

as

print 'proc1'

go

if object_id('proc2') is not null

drop proc proc2

go

create proc proc2

as

exec...

This may help you: http://poshcode.org/2276

I got it working, finally!!!

I thought I would share what I've learned the hard way about transferring data between a SQL 2K sp4 source server and a SQL 2K8 R2...

I guess at the end of the day, I want to understand

1) why the transfer method fails on 2 out of 53 databases, given that the syscontraints view exists...

Mixed-mode logins (not my choice) w/ different sets of users on source and destination.

And George, yes to both: this is a nightly thing.

George,

Thanks, but we're not really interested in that approach.

Boooo. It didn't work, sysconstraints is definitely not in the views array, and it was still scripted.

See above, in original post: rather than adding items, it's setting properties of the transfer object.

This creates the transfer object:

$xfr = New-Object -TypeName Microsoft.SqlServer.Management.SMO.Transfer -argumentlist $sdb

Then the code above sets...

Thanks Gail, that moved me forward.

So now I have the correct collection of views in $Views

$Views = $sdb.Views | Where-Object {$_.IsSystemObject -eq $false}

So I've set TransferAllViews = $False, how...

Hi Gail,

I was hoping that this would prevent those objects being scripted, but it appears not.

$xfr.Options.AllowSystemObjects = $false

I certainly don't want any system objects transferred.

jlmoore03,

If you're using SQL 2K8, you can check what app your "smart" users are connecting with using a login trigger, and reject those bypassing the app.

http://msdn.microsoft.com/en-us/library/bb326598.aspx

We will be gleefully implementing...