Lynn Pettis (1/26/2009)

---

Very carefully.

Using SSIS, the process would be encapsulated in a FOR EACH container (not exactly sure how i would configure) and within that I'd have the necessary "code"...

Yes - that is correct. And, don't forget to apply all service packs that you need (SP3 would be my recommendation).

Well, I am not familiar with DTS and only have limited knowledge and capability with SSIS. I still think using SQL Server Express is your best option and have...

You really should be looking at using SQL Server Express and replication. That would be the better option all around and would be my recommendation.

All of the other posts have directed you to a dynamic pivot\cross-tab solution. I would like to point out that most (if not all) reporting tools available will not...

You have to install new instances. A new instance is a completely separate set of binaries and database files on that host. You cannot install a new instance...

Yes - this is going to have an affect...

Please include the number of pages for each index\table. If these are small tables they will never be defragmented fully.

You can't modify the calendar control, so - you modify the parameter in the SQL statement. The general formula is to zero out the time portion of the date...

It would really help if you would read the article I link to in my signature. It will help you format your question so we can help you better.

The...

FWIW - the second option would be the better option if it works. However, it will not work the way it has been presented here.

SELECT [BlockMaterialsID],BM.[MaterialsId],BMC.[BlockMaterialCategoriesId]

FROM [dbo].[BlockMaterials] AS BM

INNER...

Dennis D. Allen (1/21/2009)

---

Greetings Lynn,

Yes that does work and is a fine workaround.

I want to understand why this does not work as it should work correctly and the...

You probably cannot shrink the log because the active portion of the log file is near the end. You need to setup and run frequent transaction log backups (every...

ChrisMoix (1/20/2009)

---

I really wish you could use synonyms for databases on remote servers. We use SQL Client Aliases to keep from having to change code going from development , to...

ryp (1/20/2009)

---

Im using SQL server management studio 2008, there is no open table option on the right click menu and I dont want to write a Query, I know I...