To find out which ports are being used you use the view

sys.tcp_endpoints

and if you needed further info you may join this with sys.service_broker_endpoints

I like the Itzik ben-gan books which if you write or review a lot of SQL are very useful

Inside Microsoft SQL Server 2005: T-SQL Querying

Inside...

If you apply SP1 and then the hotfixes from url I gave in the previous post you will have no issues with SSIS .

Its definetly worth applying them though.

P.S make...

Guys concurrency

Whats to stop another client grabbing exactly the same miniumum account number? Nothing

Whether it be through time splicing, multi processor systems or whatever...

On the point about HT you may find the following link interesting. Its to one of the sql server teams blogs where he talks about whether to use HT or...

I've been using 2005 since before the official release and its one of the few things about SSMS that I do not like. From within the managment studio there seems...

If you use DBCC INDEXDEFRAG in SQL Server 2005 it is an online operation but you should use ALTER INDEX REORGANIZE instead in 2005 and this also an online operation.

If...

You need to restart sql server after enabling the network protocols in sql config manager before you can connect over a network connection.

hth

David

You'll probably find that SSIS won't start afterwards this is to do with the managed code trying to check certificates on the internet there are ways around this but I...

Sue

Your where clause will prevent the row with female in it from ever being returned. Your outer join in the from clause will preserve the row with female in it...

You can call stored procs from a batch file using OSQL.

See BOL for syntax etc.

hth

David

I think you can possibly do this using event notifications using

AUDIT_LOGIN_CHANGE_PROPERTY_EVENT but I haven't go round to trying this myself yet

hth

David

SELECT ServerName

FROM TableB

WHERE ServerName NOT IN (SELECT ServerName FROM TableA)

hth

David

Opps forgot also and this may be more appropriate.

If you look under the properties tab of the report and go to the execution settings you can set it to never...

Timeout settings are under Site settings in report manager.

hth

David

P.S you can coonfigure some other options in the xml config files in the report server directory