Doh - shoulda known that. Thanks.

This is a SQL2005 database, and the Properties/Files page was disabled - well, at least I didn't see any files listed. I looked up the ALTER DATABASE MODIFY FILE syntax,...

Ok. So the next obvious question - how to I grow the log file? (Sorry, I'm pretty experienced at coding for SQL Server, but at these administration things I'm pretty...

Well I did notice that after running the backup log my available free space went from 1.16 MB to 16.73 MB, so it sure did something. I sent an email...

I tried the WITH TRUNCATE_ONLY option. It is the same syntax for SQL2005, and it executed successfully, but I am still getting transaction log full error when trying to copy...

Hey John, thanks - I had to make a couple of minor tweaks, but your method worked. That's just what I was looking for! Thanks again.

Somebody replied to me in another post. You can't use the "Optimize for many tables" option if you are going to keep identity inserts. Nowhere are you warned that using...

I'm curious about the WITH (FIRTROWFAST). I searched help in SQL Server 2005 and google didn't get any hits. Is there a typo? WHat is this?

Thank you, sir! That did the trick.

I must say that behavior is VERY counter intuitive.

Fortunately I am in luck! I had one instance created on C:, the first one I did before I knew how to target a different drive, and others on D:....

Yes Orders.ORDER_ID is the primary key (identity column). OrderStatus has a STATUS_ID primary key which is also an identity column, plus an index on ORDER_ID + STATUS_DATE. I thought...

Even better, I was able to turn it into a UDF

CREATE FUNCTION [dbo].[GetPrice]

(@ProdCode VARCHAR(8),

@PriceLevel INT)

RETURNS MONEY AS

BEGIN

DECLARE @Price MONEY

SELECT @Price = CASE

WHEN PRICE4 > 0.00 AND...

Works like a charm! Man, I was trying things with all kinds of if else's - didn't think of putting multiple conditions in the WHEN clauses.

Thanks!

I ran into a similar problem. I had an ASP.Net website I was developing using a local MSDE SQL Server 2000 instance, which used dbo. I went to upload...

Best one I've seen is Programming Microsoft ASP.NET, by Dino Esposito, Microsoft Press.

Mircrosoft also has a number of webcasts, the Essential ASP.Net by Fritz Onion being good ones

http://www.microsoft.com/events/series/essentialaspnet.mspx