We had an HP years ago with the same recommendation. For some instances it was fine, for some it was an issue. If you have heavy I/O, this can be...

The issue is that you don't have enough space for something. I'd try varchar(max). If that doesn't work, then it's not that field. It might be any of the char...

If you check the package, you can see if it's set to log to a text file (it should be).

The other thing I'd be sure of is if you really...

Do you have the logs of the maintenance plan?

You can set an xp_cmdshell proxy to make the copy. By default I believe it uses the SQL Server service account. If you haven't set a proxy, and are using...

Sounds like you are looking for help with homework/tests/interviews.

There are many articles and documentation written on this subject. As a short answer, why don't you start reading and then ask...

You can use the auto_fix option - http://technet.microsoft.com/en-us/library/ms174378.aspx

Or write a script based on the output of step 1 to execute things for you.

The removal is tough, especially when there might be valid reasons to have some data about you. Allowing someone to remove any data is not something I'm sure I'd like....

There are a number of scripts on this site to help with that. Here's one

http://www.sqlservercentral.com/scripts/Log+Shipping/67173/

If you're giving away beers.....we could use a few here at the ranch. 😛

And hope you don't lose that data. Maybe that's an idea...

You probably don't want tables in master, and note in the example above, NULL does not need quotes. It's a reserved word.

You could build an SSIS package to suck out a few rows of data from each table, but as (the other) Steve mentioned, this doesn't mean you have consistent data....

It wasn't me, Howard, but glad it helped.

If you go to that article and click the "discuss" link, you can ask the author a question and I'm sure he will...

I think Roger has put things well. I'm not saying you don't have a PK. I'm saying identities work well in that role.