I haven't seen a good script to get this info, probably because it's a lot of work to store it in the first place. Everyone has to "build" their definitions...

You would have to build the select yourself using multiple tables. It's no different than a single table, just join the tables and reference the columns

You probably need a trigger to catch the inserts and compare them to the previous entries. Assuming you can do this and have some ordering criteria, I'd have the trigger...

Yes, setup a trace for those events and set the logging as a table. You can build a server side trace and have it run as a startup procedure.

This doens't make sense? You aren't setting a value for the variable in the firts cawe and not sure where you want rowcount to appear from the 2nd.

It's an AD/Domain issue. I've had similar issues that have driven me crazy as well. Search on SPN and try setting one for the machine. I've usually seen this with...

Most things are fairly expensive. Servers Alive (http://www.serversalive.com/salive/index.asp) used to be very reasonable.

Why not just compare to a date instead of converting to a char?

We've talked about this. Part of the issue is that so many people come back and add things to posts a week or month later. We don't want to prevent...

I'm sure I've made some ridiculous statements, with probably more to come, but I'm not sure this is one of them.

Porting costs are high and they subsantially impede the move...

Tend to agree with some of the research comments. If I had to get something done this week or next, I'd just buy a new server. However since I have...

Thanks for the comments. Someone sent me this link: http://www.thisoldstore.com, if anyone else is in the same situation.

I'm thinking that I might move this box into the dev/test area with...

No good way to move DTS packages. You could probably script something to open and save on the new server, but might be as quick to just open and...

Not sure about the internal fragmentation. I think that depends on a per-table basis since your index keys will be of widely varying widths.

For external fragmentation, I think your script...

There is no best place. Depending on the project, you need to hire a DBA or a consultant to help with this.

I'd look for someone that's done work in your...