The distribution database needs to be large enough to hold your changes, so size it appropriately, which may mean making it larger. You can set autogrow, but you don't want...

Ed is correct in that you need to license users. If this is in your company, you might own CALs for many users. I would check on that first.

Typically...

PRINT messages are intended for display and not capture. AFAIK, there is no way to capture this in a table. You'd need to change the procedure to output the messages...

There is no set thing to look for. Is there a problem with your server?

Usually you check if things are slow. If you want to generally tune everything, start by...

This has no effect on your server or databases. You do need to make sure all clients know that they must use a different port to connect.

In most Windows clients,...

There isn't really a positive or negative response with these. It could go either way depending on your environment. Also, your title, audit objection, doesn't make sense. What are you...

Why would you turn it into a recordset and than back to a CSV? Why not just move the CSV from one side to another.

Nice rant, Jeff.

Personally I think SQL Server is better because it's cheaper, easier to use, and more friendly to the user. But I'm a SQL Server guy and always have...

Very cool comments and sounds like everyone has had some interesting experiences out there. Congrats to those of you that are in the place you love.

I love where I'm at...

Thanks again and I appreciate the kind words.

Start with backups, be sure that you have them running and you can restore them.

I'd also request some consulting help and hire someone to help you. If you have TB...

Please don't cross post. Continued here: http://www.sqlservercentral.com/Forums/Topic439166-9-1.aspx

Look in sysservers. What's in there?

Don't use sysobjects, use information_schema.tables.

We do not allow dumps to be posted here or requests. It violates the NDA and you lose your certification if Microsoft finds you requesting them.