Actually, the size of the database has little impact on the size of the log - there are rules in the SQL Server Resource Guide, but they must be treated...

Wouldn't using merge replication require a lot of coding to resolve conflicts, or are you assuming that either A OR B are live at any moment, but never both receiving...

I'm sure people will have done it, but the maintenance of it is a nightmare. Try looking at http://www.incepto.com, their product SQLup is going to be reviewed...

Hi there

Get hold of "Advanced Transact-SQL for SQL Server 2000" by Itzik Ben-Gan and Tom Moreau, published by apress (www.apress.com).

ISBN is 1-893115-82-8

Chapter 16 is all about Expanding Hierarchies which is...

This may be a silly question, but can't you add another column which is an integer IDENTITY? Then use that?

Could you also use a correlated subquery in your view...

Yes, you cannot GROUP BY a derived date format. I believe that I got round this once by deriving the date in a separate table then JOINing that back...

INSERT TempRX_NDC(rx_NDC,rx_strength)

SELECT RX_NDC, Rx_Strength FROM SERVICES

WHERE RX_NDC IS NOT NULL AND Rx_NDC <> ' '

GROUP BY RX_NDC, RX_Strength

However, if you are using SQL2000 and this temporary table...

SET NOCOUNT ON stops SQL from sending back the progress messages generated by Transact-SQL statements that affect one or more rows.

If you run your stored procedure without SET NOCOUNT ON...

This is fairly straightforward: any functions, be it UPPER(), LEFT() or whatever will prevent an index being considered for that part of the WHERE clause....

I hope this answers your question,...

I *cannot* vouch for this product, but look at http://www.incepto.com to see if this more closely matches what you want?

Simon

UK

Well I for one would never write a business app using ASP - you just don't have the control of the screen you need, let alone state management.

But anyway, 65536...

I would just point out that with VB and .NET in general you are buying into the Microsoft wish list in many ways.

The VB fans here will correct me, but...

Brian

Could you tell me if you have written a class wrapper that provides a means of accessing the functionality of Excel without accessing low-level formatting calls?

The severe limitation to Excel...

Actually, I'd recommend Visual Foxpro for providing a rich environment for developing your front-end. This is one of those subjective threads that can so easily degenerate into sniping about...