Lots of soccer talk, and good to talk to. Hopefully we'll all get together...

It depends on the OS, but it's a user right in the control panel (system in XP), I think similar in W2K3

There is no best. It's a company by company experience. It's like saying who's the best DBA? Not sure there is such a thing.

Are you looking in a particular location?

End to End Training (www.endtoendtraining.com) offers custom training in Orlando.

Disclaimer: I am a part owner of the company.

Thanks for the update, and glad you got it working.

Just remember the DTSSource() is a function, and represents a field of data. You want your other function to enclose that...

Thanks :blush:

good to meet you as well and glad you liked the presentation.

symmetric keys to encrypt data

asymmetric keys to encrypt the symmetric key.

http://technet.microsoft.com/en-us/library/ms345262.aspx

insert select doesn't work with identities unless you do as GSquared as noted.

Provide a column list for the insert and the select.

My thoughts exactly. What are makers?

Log Shipping is moving the tlog backups. They will be consistent. That's what a relational database does is ensure consistency based on the transaction...

Stange. Perhaps some batch setting in BULK INSERT

Print out the commands, and execute them yourself. Do you get the same counts? Each should be executing only once.

2008. In a VM, no networking to a 2005 instance right now

I do what GSquared does as well. Delete them in batches, 1,000-10,000 at a time.

Image attached

I have 1600.22 for my SSMS build and they highlight in gray here.

closed