10 mins aint bad! Will you end up reprocessing all 300k rows every day?

Andy

Not that Im aware of.

Andy

Access is good enough for quick and dirty forms.

Andy

6% cpu is decent, doubt it make the difference. Have you tried running it multiple times? First time will create the plan and also cache the data.

Andy

Books online is a good place to start for cursor info. Also, a lot of the procs in master use cursors, so you can see how MS uses them. Try...

Sp_primarykeys will tell you which column(s) is used in the primarykey. You have to specify the relationship when you join, else you wind up with a cross join.

Andy

You might find parts of this article helpful:

http://www.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.asp

Andy

Would the non null rows have a relationship to the null rows other than physical order? Conceptually I think a cursor is easiest to envision, sort the data however makes...

Sp_dropuser will cause you to lose any permissions assigned to the user (should be assigned to the role anyway!). One other note, sp_dropuser has been deprecated by MS, the preferred...

convert(varbinary(10), value) = convert(varbinary(10), othervalue)

Andy

It's best done with a trigger. BOL has a pretty good section on them. You'll wan to do something like this:

create trigger i_tablename on tablename for update as

set nocount on

insert...

Try converting it to varbinary and doing the compare, that's what I use for case sensitive joins.

Andy

I see no advantage to setting something to case sensitive. At times it may make sense for a column or two, but hardly ever would you want TSQL in a...

I'll try to get some sample code posted this weekend if no one else does it first!

Andy

You want all the backups from all instances in one folder?

Andy