This will get you the path and filename of the latest backup file.

SELECT DISTINCT B.PHYSICAL_DEVICE_NAME

FROM backupset a, backupmediafamily b, backupfile c

WHERE a.database_name = '<Your DB Name Here>'

AND a.type =...

SQL 2K Profiler has a script option so you can create and script out the trace. Then put it in a job. I don't know if the older versions of...

I think you need to configure DCOM and grant access. I vaguely remember needing to do that when I set up debugger but I don't remember what I did. Hope...

You can use the extended sproc xp_getfiledetails to capture the information you need.

Create a temp table:

CREATE TABLE #ATTRIBS (

 alternate_name  VARCHAR(128),

    INT,

 creation_date  INT,

 creation_time  INT,

 last_written_date INT,

 last_written_time INT,

 last_accessed_date INT,

 last_accessed_time INT,

 attributes  INT)

-- Check the archive bit to determine if the file has been...

Thanks - I wound up using a temporary table.

Select top 10 rownum = identity(int,1,1),

           productid, quantity

into #tmp

from [order details]

order by quantity desc

select * from #tmp

where rownum in (8,9,10)

drop table...

I goofed on the 'rs'. should have been [order detail]. I now get a result but the count is the total number of records for each productid and since the...

Thanks - tried it and I still get the invalid object name 'rs'. The inner query uses the alias of order detail in the outer query. Would that be the...

Thanks for asking. I actually found the answer in a Microsoft KB Article - 830210. It looks like you have to do some digging to get information on replication.

Anyway,...

I looked at BOL for the sp_reladdcolumn and sp_repldropcolumn. They both have a schema_change_script parameter. Would that be the alter table script?

Thanks - DTS certainly sounds like a reasonable alternative. I'll set it up and test.

Thanks - I was fairly certain that was the case but I had hoped there was an undocumented "feature" somewhere.