Yes you can, but will it give you the result you expect ?

select top 1 field2

from yourtable

where field2 is not null

order by id -- if id is...

does he also know what composite material the engine of his care is made of ? :hehe:

Do I know what exotic language is used for the SQL-engine ? No

Do I...

1) keep in mind there is no order in a table's rows.

If you want results handled in a certain order, you should use an order by clause in your...

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.