Forum Replies Created
Viewing 11 posts - 316 through 327 (of 327 total)
-
RE: Transfer of backups
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 =...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: how to automate profiler
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...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Debugger
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...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: script to check file
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...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Need to Select rows from a Top 10 Result
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...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Need to Select rows from a Top 10 Result
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...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Need to Select rows from a Top 10 Result
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...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: SP_ADDARTICLE Help needed
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,...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Need an alternative to replication
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?
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Need an alternative to replication
Thanks - DTS certainly sounds like a reasonable alternative. I'll set it up and test.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: When was a database last accessed
Thanks - I was fairly certain that was the case but I had hoped there was an undocumented "feature" somewhere.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
Viewing 11 posts - 316 through 327 (of 327 total)