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

Are you saying there's one VM on a server with 5 instances? Or 5 VMs with an instance each?

You don't want to overwrite backups. You want to have a unique name per day, to be sure the date the backup was made is correct. As mentioned above, the...

http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-an-empirical-picture.aspx