Maybe this gets you started...

Select M.BookId, D.[status], count(*) as NumberOfOccurrences

from [master Book table] M

inner join [details Book table] D

on M.bookID = D.BookId

Group by M.BookId, D.Status

it's sql 2005, wright ?

Compare the XML-plans. They provide more detail ...

it will try to use the port it used the previous time, but if that port is unavailable, it will switch to anothre port.

So if you want to use kerberos...

IFAIK: no

SSMS ... maybe you mean the "registered servers" tab. (check BOL)

even if a job is disabled you can launch it manualy or using sp_start_job.

That's why I don't want sp_start_job in any application !

maybe 2 things:

1) provide indexes (2) for the dates, to support you and grouping

2) If you know you don't need to process the whole table , add an extra where...

A virtual pint of my favorite Geuze for SSC :w00t::cool::smooooth:

Hip, hip, hurray for the winners 😀

maybe you're better off ftp-ing the backup file to a local drive of your target sqlserver server.

And the just perform a local restore without having to provide extra privileges...

😀

Edwin, I hope it gets you started.

I'm not MS, but tend to go for :

SIZE = according to your estimate + grow estimate Mb,

Filegrowth = NOT in percentages !

Avoid autogrowth if you can, so your file...

as you have noticed, SSIS itself is not instance aware.

So you can only have one active SSIS on a cluster :crying:

On the other hand, IMO MS is trying to push...

yes you can, if the login exists on the server.

I think I got this from SSC, but I cannot find the link:

-- Written by: Greg Larsen Date: 06/15/2002

-- All rights reserved Copyright 2002

set nocount on

DECLARE @I INT

DECLARE @C CHAR(8)

SET...

- grant the login the needed rights (tables, views, sprocs,fn,...)

- sp_changedbowner 'sa',true

thank you for the feedback.

Glad to see setspn solved your issue.