I'm thankful people post so I can learn something from other's questions too!  I was able to figure out how to get the exact data, but as Remi pointed out, I'd...

Another option?

create table test

(col001 char(3),

col002 datetime

)

go

insert into test

select 'aaa', '8/19/2005'

union

select 'bbb','8/19/2005'

union

select 'ccc','8/20/2005'

union

select 'aaa','7/29/2005'

union

select 'bbb','8/24/2005'

union

select 'bbb','8/2/2005'

union

select 'ccc','8/24/2005'

union

select 'aaa','8/11/2005'

union

select 'bbb','8/8/2005'

union

select 'aaa','8/8/2005'

union

select 'bbb','8/25/2005'

union

select 'ccc','7/28/2005'

go

create table #test

(col001 char(3),

col002 datetime)

go

insert into #test

select top 2 *...

Microsoft's knowledgebase(support.microsoft.com) shows this behavior is what they intend:

http://support.microsoft.com/default.aspx?scid=kb;en-us;814574

Take a look in Books Online at "Shrinking the Transaction Log".

What I have done in the past is use

backup log databasename...

Would this help?

select 15.25*16.29

--248.4225

select cast(15.25*16.29 as decimal(8,2))

--248.42

I had to save the file to my harddrive.  I then right-clicked the file and chose properties.  There was a checkmark indicating that the content was blocked.  When I removed...

Does your SQL Account have read/write rights to that d:\ drive?  I use an *.htm file as a template.  I'm not sure it it has a hardtime with the extension...

Looks like the e-learning classes from Microsoft are free:

https://www.microsoftelearning.com/sqlserver2005/

DLT is fine...It has been around for years and is usually very dependable.

Has anyone tried to erase/reinitialize (not sure of the terminology on your drive/software) a tape and then try...

What kind of tape? DLT, LTO, 8mm?

What software are they using for the backup? Windows NT, Veritas???

Is the tape drive connected to the server via SCSI, Ethernet, USB?

What...

Hi Steve -

When I click on the SQL Server Standard Subscriptions, nothing happens.

How about this?

drop table test_seq

create table test_seq

(wpage smallint,

wsequence smallint

, word char(11))

go

insert into test_seq

select 1,1,'certificate'

union

select 1,2,'of'

union

select 1,3,'liability'

go

insert into test_seq

select 2,5,'certificate'

union

select 2,3,'of'

union

select 2,1,'liability'

go

select * from test_seq

go

select a.* from test_seq a

where a.wpage =

(select...

With Yahoo, I've gotten in the habit of adding the email address of anything I want to receive to my address book. This has seemed to be the best...

Can you ping the server from your machine? Do you have tcp/ip client library enabled on your local machine?

Also, check the rights you assigned to the SQL...

Here is a script on this site that can get you started:

http://www.sqlservercentral.com/scripts/contributions/687.asp

Is your goal to have a record like the following?

member_nbr, #loans, sum_of_orig_amt

Do you need the rest of the fields?