If you want to learn SSIS, I own part of a training company in Orlando, FL that has gotten great feedback about our SSIS training. Brian Knight, MVP, author, has...

It can migrate some pckages, but depending on if you have scripting and complicated packages, it might not work and you have to re-write.

Pragmatic Works (www.pragmaticworks.com) has a tool that...

I'm not 100% sure, but it's possible that you can't open two cursors on a table variable.There might be some scope issue here.

Any reason not to move this to a...

Sites such as this one are good for general knowledge. Depending on time, you could go back through old articles and see what you learn. We have feeds for...

Oh and I'd set the databases in simple mode. Not sure you want to deal with up to the minute recovery for users.

If you do, then you need to manage...

Backups, maybe have them set a preference (folder) and run a backup to there? depending on how knowledgeable your users are, either let them pick a name, run it as...

create a function, query sys.objects using your criteria.

First I'd suggest you get Management Studio so you can more easily view things.

second, did you create another login or a user? A login has access to connect to the...

My guess is that they'll leave the open source product as it is, letting it evolve over time. I think that this will put more pressure on Oracle, IBM, and...

Again, that doesn't help. It depends on what your data is.

If you are storing phone numbers, you don't need a varchar(50). You can reduce that to 10 char in the...

This sounds like a homework assignment. Please make your own attempt at this and show some effort.

This is a holdover from pre v7. Not sure that you need this information anymore.

This isn't something easily answered. It depends on your data.

Pick something that you think fits your data, with some pad for character values. Dates are dates, numbers are integers or...

As Jeff mentioned, we're more than happy to help. However take the time to describe what you want, include relevant code, but we're not going to dig through your code....

There's a place to change the default file locations in the server properties, Database Settings.

I'd do the detach, attach listed above.