Thanks Ian, that information was very useful. I've got a question for you. Do you have any recomendations for a data dictionary tool? How to you keep up with...

Very nice job. Short, sweet and to the point.

To pass in a null to some stored procs (with older Vb6/ADO code) you can do this:

1) The VB code puts 1/1/1900 in the date and the proc converts it...

If you're having trouble seeing table and view objects, it's probably because the default schema of the user is NOT the same as the schema of the objects. Open SQL...

I've run into the Order by problem on the VIEWS in SQL2005 and I personally think they should have made it a Compatability setting instead of changing the behavior. It...

Wayne, I agree with you on that. The renaming of the links applies to linked views as well. The idea is that you link and rename the objects instead...

Here's a tip for upgrading you Access front end to use a SQL server DBMS.

1) Copy the MDB to a backup location

2) Import your MDB data to SQL Server

3) remove...

for me, output parameters are most useful when your proc is an Insert on a table with an identity column. What you need is to pass back the Primary Key...

I would strongly advise you NOT to do this. In my experience you will end up with a big mess and lots of dependencies you don't want.

Try to find...

Nice job Troy, how about an executive summary of your top 5 tips for good modeling and design?

Doug

I'm not a modeling expert, but basically your tring to eliminate duplicate information. I would not over-think this problem. If your users are working "fine" with Access up to...

when you are combining that many databases and looking for duplication of effort, without a data dictionary you're screwed. It will probably take the programmers months to gather this info....

I can't help you with the course, but I can say you have a huge job on your hands. Here are a couple of suggestions.

1) start by analyzing all your...

Everything sounds reasonable. I dont have time to read the forum posts, but I like the idea of being able to opt-in on a particular forum to see items I'm...

I agree with the French mademoiselle,  let's keep the topic about databases and SQL. But I must admit that I did enjoy the picture of the Eagle.

August 29, 2007 at 8:39 am