What version of SQL Server 2005?

The reason i ask is that the developer edition e.g. is not network enabled by default so you have to enable TCP/IP  and express is...

Well it seems to be going well our Java bloke has happily used hibernate to map the stored procedures saving himself lots of coding effort and the data access code...

Thanks

David

Live state agents and browser

I believe it uses the volume shadow copy service and it doesn't actually stop the server it freezes it momentarily while taking a snapshot then unfreezes it. Since sp3 i...

Thanks for the replies guys.

Its just one of these things where from the software developers point of view you can defietly see the benefits i.e. no more hand coding of...

Sorry I was just pointing out that as you have used f.Description in the CASE statement that it was ordering on the Description column unless you changed the name and...

Craig

I think its just some funny behaviiour you get with some non-standard i.e. non Ansi-Compliant features if you change your query to

SELECT          f.[Id],

                [Descriptions] = CASE

                    WHEN b.[Description] IS NOT...

Alan you could use a case command e.g. using the pubs database this orders differntly depending on the date

SET DATEFORMAT dmy

select title_id, title, type, pubdate, orders=CASE

         WHEN pubdate > '01/07/1991'...

I've just remebered while I was writing the above the query, which is really useful for creating a view from which you can do a compny telephone list in reporting...

To add the linked server and set th security for the linked server try

EXEC sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces',

'ADSDSOObject', 'adsdatasource'

GO

EXEC sp_addlinkedsrvlogin 'ADSI', false

This is a sample query to...

I'm not sure if it will work but if you read the folowing article and try putting the database into emergency mode you may be able to recover the data.

http://www.sqlservercentral.com/columnists/bknight/unmarksuspect.asp

Reseting...

I always create my databases with mutiple files for two reasons.

1. If i need to move a file off onto a secondary disk array for performance it will be proportionally...

SQL Server will run on both fine but if you're like me and do development work at home you will find that reporting services needs XP pro so if you...

I've seen this before when the account the agent was running under didn't have the correct permission on the registry key when running the agent service undera domain account.

Check the...