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.

The corrected question, which is on the web site, is

CREATE TABLE E (eid int, mid int, en char(10) )

INSERT E SELECT 1,2,'Vyas'

INSERT E SELECT 2,3,'Mohan'

INSERT E SELECT 3,NULL,'Shobha'

INSERT E SELECT...

As mentioned you need to shrink the log, but you also need to set up log backups, figure out how large to leave the log, and monitor things.

I'd use Jeffrey's suggestion. You can't use a variable in the 3 or 4 part naming scheme.

Hard to stay in the top 5. Someone can answer a few hundred questions in a couple days and get up there.

The question is repeated when you click in the newsletter. If there is an issue, we will try to fix it as soon as we can.

The ORDER BY doesn't change...

If you (ya'll) want to write a book together or separately, Tony Davis of Simple-Talk is always looking for some to use in promotions. He has gotten them in print...