I think MS found it easier to say "varchar" rather then "charvar"

jay holovacs (5/28/2009)

......

SELECT * is typically resolved at compile time, and expanded to be the columns. So over time, if you've modified the schema, and a plan exists, this might not return...

AFAIK, you cannot create an instance programmatically using SMO. The setup program for SQL Server has to run, which is what VS does. It has a setup file set that...

Use the data import wizard to set up a basic package. From there, you can add to it.

there are lots of SSIS articles here on the site (http://www.sqlservercentral.com/Articles/SSIS) as well...

When someone said they ran the SQL, I said with the corrected question they couldn't get those results.

The newsletter is what the question goes out as, but it could potentially...

How does the job work? Why not just use Integration services to move the data.

You can take code off the Internet, IMHO, and use it in your systems, but I would not think that you can take it and resell it, meaning put it...

Luke,

thanks, but it shouldn't have mattered. now I need to check and see what else has changed

Ahhh, no more horses! They're everywhere.

I think Tia could get a horse to drink. She does some amazing things with horses. she got one to play fetch (http://www.youtube.com/watch?v=Xd6pxo1qYgE) and bow...

Or for a query.

You can create view for the query and encapsulate things. However, if you are planning on hundreds of tables for a linked server, you are architecturally...

I think you are either connecting to a different instance or database if you can see them from one place and not another with the same credentials.

When you log in,...

The script is really the commands he's given. Look them up in BOL and use the parameters that would make sense for your system.

for shrinkfile, use something that seems reasonable...

Refresh maybe? Restart SSMS?

You could use a hash.

Otherwise, there isn't a great way to do this. Typically you do not create a unique index on an encrypted field.