Thanks.

That is the logical name. The physical name would be I:\log4.ldf

I am currently using SQL 2008 (I have both standard and enterprise editions) with SP1. Do I need to re-license my SQL 2008 products to use SQL 2008 R2?

Thanks

The one size fits all backup strategy. Backup strategy driving the recovery instead of recovery needs determining the backup strategy.

No matter if it's a bad question or a trick question. The answer is one. The question was "How many records are returned from the last SELECT?". ...

If I remove the - sign, I get a positive value, with it I get a negative value. But further down there is another similar query that does the...

You could be correct. But why not use the ABS() function. It would be clear and sort of self-documenting. We are going to ask the vendor to...

At first, I thought maybe that would be what it was, but the results of the query return a positive value for column d

select isnull(sum(u.quantity),0) as q, -isnull(sum(u.linecost),0) as d

from matusetrans u

where u.issuetype in ('ISSUE','RETURN')

and u.transdate< 200912

Actually, the initial size of the database is the size specified in the model database.

It's a user defined stored procedure.

exec dbo.spFuelSAWA_Output

One parameter @WeekEnding which is a datetime.

I might have found a work around it by creating a user defined function that...

Fabulous. Thanks!

I am also having issues with modifying partition schemes using existing data.

Here's what I have done:

1. Created filegroup and added files

2. ALTER PARTITION SCHEME partition_scheme_name NEXT...

Yes, I realized it after I saved.

Right Click SQL Server Agent in SSMS and select Properties.