I get it. Thanks.

The statement "Inner joins can be specified in either the FROM or WHERE clause without affecting the final result" makes it look like there is no difference in the examples...

Thanks!

You'd think that with all the replication improvements from 7.0 forward that they would address this since GUIDs are used as unique identifiers in replicated DBs.

I noticed that when I open an sproc using r-click>Script object to new window as>Create, when I try to save the file, the file name proposed in the Save Query...

The keyboard shortcuts are great. How do I create a new sproc. R-clicking the stored procedures node or the database node doesn't appear to give me that option.

>>You can fix...

Shift-F1 are Scripting Options are big help - thanks! Is there a way to highlight a section of code and have it commented out automatically. How about indenting/unindenting sections?

When I r-clicked...

How do you write sprocs in QA? If I right-click a stored proc and select Edit, I get it displayed in a Notepad-like window. How do I:

- Check the script...

In some cases a table will be added between existing tables, for example to track competitors' products or rate competitors' competitive influence. In other cases more links may be added....

Thank you so much for the link to that great article. My book has quite a bit on Exec(), but this is even more in depth. Re manually creating tables,...

Thank you for your input. The 'application' is actually a tool that allows users (admins) to redefine the schema. Tables, fields, indicies, and constraints are generated/dropped dynamically. I agree, my...

Looks like it was.

Thank you all for your help. I ended up putting the file name in index names, which made them all uniquely named. This worked. I will have someone with SQL...