Viewing 14 posts - 16 through 29 (of 29 total)
Great, thanks for your help. I found the following topic on MSDN ...
http://msdn.microsoft.com/en-us/data/aa937705.aspx
It looks like using the sqlncli.msi installation program is what I need. ...
September 17, 2008 at 12:30 pm
Just in case someone else reads this, I found a system sp to do what I'm trying to do.
exec msdb..sp_delete_database_backuphistory 'dbname'
This works best for me as I'm trying to remove...
June 26, 2008 at 11:36 am
Great, that does sound reasonable. I did see some advice on another post about using SP_DELETE_BACKUPHISTORY to remove old records so I'm going to investigate doing that. ...
June 24, 2008 at 3:04 pm
I'm researching RCmd, thanks for the help.
June 12, 2008 at 2:27 pm
These job triggers were probably created by some backup tools were evaluated last year. All these triggers were for backup jobs. No other type of job had a trigger.
January 11, 2007 at 8:07 am
Actually a more efficient method is to just drop the trigger and then run sp_delete_job. All the referential integrity is included in the system sp.
We've got several of these...
January 10, 2007 at 10:34 am
Thanks everyone for the input, it all helped to figure this out.
This job had a delete trigger on the sysjobs table associated with it that handles cleaning up all the associated...
January 10, 2007 at 10:02 am
I've tried ...
exec
sp_delete_job @job_name = 'Job Name'
...and...
delete
January 10, 2007 at 7:56 am
Sorry I didn't include that before...
I'm trying to delete this job through Enterprise Manager and we are on SQL 2000.
January 9, 2007 at 4:43 pm
Yes, exactly! I was hoping to be able to use the view to join to local table(s). So obviously that would be more efficient if the filter on the remote view...
May 18, 2006 at 7:40 am
So what I'm now hoping that somebody knows of is a way make a locally executed stmt like ...
declare @var VARCHAR(12)
select @var = 'ABCD1234EF56'
SELECT *
FROM RemoteServer.DBName.dbo.VW_name
WHERE FieldName = @var
... to do the filtering on...
May 17, 2006 at 3:59 pm
btw...
Thanks for the responses everybody they are a help.
Noel, my goal is to be able to use a view on the local server that uses a view on the remote server. So...
May 17, 2006 at 3:51 pm
I tried looking at the execution plans for each stmt and they show that the stmt with @var returns the whole recordset and then filters locally. Whereas the other stmt doesn't...
May 17, 2006 at 3:43 pm
I have run these in different order multiple times and consistently get the same results, the times of 30 secs and 2 secs are an average skipping the first run.
The screened result...
May 17, 2006 at 3:27 pm
Viewing 14 posts - 16 through 29 (of 29 total)