I'm not sure I like email as a PK either. I might use it as a unique column, and display it, but since it is something that can easily change,...

Well this was interesting. Had someone ask for their account to be closed here since the questions haven't been good the last month and the quality of the discussions has...

The Bears are kind of a football team. With Cutlet at QB, they're not a great imitation of one :w00t:

jinlye (3/2/2010)

---

What surprises me is that this was the number one 'featured article' in this week's mailing from sqlservercentral.com. This must either be because:

A) The 'featured articles' are just...

The service account is the account that runs SQL Server. You can see this in EM, in the server properties. That is the account that likely is running your...

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. 😛