You're welcome. Glad we could help.

Try copying from server to workstation, then from workstation to laptop. You might be getting a Kerberos issue with copying from the server (2-steps) to the laptop. Not...

From what I can find, the longest last name on record, is:

Yeah, that's one name. But you probably don't need to accommodate that.

On the other hand, the USPS...

I've found it useful for this kind of thing to have a PhoneNumbers table, with the relevant data for that, including country code, etc., and an ID number, and a...

Another belated thought on this: If you're seeing a LOT of tempdb use, are connections using shapshot isolation (either explicit, or "read committed snapshot isolation" enabled on the databases)?

That will...

samalex (1/2/2013)

I wish I could use RedGate products outside of work, but unfortunately I don't...

CDC won't modify the tables, like a trigger would, but it does add system objects to the database. If you cannot modify the database at all, then the only...

In the RDP app, click Show Options, go to the Local Resources tab, and share the clipboard. That should do it.

I usually simplify this kind of thing by setting up an SQL Server account called something like "SSISUser". Limited rights, etc. Then all normal SSIS packages just use...

I use the RedGate tools at work and at home, and that works for me.

I used to use the ApexSQL tools, but haven't in a while. They were very...

Anyone with better data than I have on temp tables vs table variables, wanna take a look at this one: http://www.sqlservercentral.com/Forums/Topic1399050-377-1.aspx?

Gail, I linked two of your SQL In the Wild...

You're welcome.

Hope I didn't come across heavy-handed or anything. Just trying to say I don't have definitive answers for you. Someone probably does, but just not me. ...

Can you change how the data is put in? If so, you could capture at that level.

Have you looked into Change Data Capture? No object/code level changes needed...

Honestly, if you want commentary on the two links, you might ask Gail directly. She (not he) is better positioned to explain her posts than I am.

I'm not a...

SQL 2000 did handle table variables differently than prior versions of SQL Server. They didn't have them, it was a new feature. It hasn't changed, mechanically, since then.

Here's...