Steve Jones - Editor (1/25/2009)

---

Personally I dislike labeling things bad and good, especially with code since it's a question of where and when things make sense.

As I get older, I...

No, you need to be running in a 2005 compatibility mode. Your best option will probably be transactional replication. If you configure replication with it's defaults, it creates...

Please don't cross-post.

http://www.sqlservercentral.com/Forums/Topic643364-149-1.aspx

please don't cross-post.

http://www.sqlservercentral.com/Forums/Topic643362-146-1.aspx

You can use service broker to break the second insert out of your transaction. Here is a pretty good article for using service broker for auditing. It should...

Ok, a lot to talk about here.

First, you can increase the number of log entries the SQL Agent retains. Right-click on the SQL Job Agent in management studio and...

RBarryYoung (1/24/2009)

---

Heh. You know, I always have to follow these links to make sure that you aren't talking about me. Thank goodness too, I prefer my pork chops...

They can reside on the same server.

If you move components to a second server, you have to license both servers.

If you have cubes of any significant size, I would recommend...

RDP does some strange things. One of them is adjust screen resolutions. You may want to try a different screen resolution in your RDP connection.

You also may want...

Make sure the workstation you are building the packages on has the same version and service pack (and patch) of SSIS.

Make sure the precompile property on the script...

http://www.wisconsinmade.com/gift-ideas/Bone-in-Stuffed-Pork-Chops-2560.aspx?DepartmentId=1252

Search around this site and on google for "Slowly Changing Dimension". The topic you are asking about has been discussed a lot. I have posted a number of...

You need to be more specific about what you are trying to do. There is no magic "disable all security" button.

You need to give us more information. What OLEDB provider are you using? What error is being thrown?

Some OLEDB providers do not support parameterized queries, some don't support...

You can compare the column information in information_schema.columns. This does not cover all of the column information available, but you should be able to modify it. Notice that...