Having been a trainer for many years, it is very disheartening to attend these events where delivery of 'Important Information' is no better than a [Insert company or choise] chest beating...

Here is what I use to Migrate Databases from 2005 server to 2005 Server.   This script will not work on SQL2000.   This Code is from the MSDN SQLServer site, but it needed...

I can absolutely recommend SSRS !!   The WOW factor is huge and so is the potential company exposure (and good way to do a bit of showing off :cool

Try the following on your local server,  remember you will need to set the security context.   

--SCRIPT START

Create Procedure usp_AddlinkedServer (

    @a_Server_name  varchar (50),

    @a_errorText    varchar(200)OUTPUT,

    @a_return       int OUTPUT

    )

as

Declare

@v_error int

set...

Good Advice Steve,   Taking a break also diverts the mind to other tasks while the subconsious works on the issues that may be plaguing you at the time.   There have...

Hi Jason,  the copy database will only work from 2005 to 2005 .  Been there done that (and failed....) The answer to the Forum...

Rather obtuse question.  Ok I duffed it but what can it be used for ??

Ummm. http://servername/report is the 'Example Default'

To verify that reporting services are running check the SQL Server configuration manager, the RH panel should show you an Icon with a Green arrow...

Luke,   I have used this one and found it very informative.  I found that working through the examples benificial to understanding why SSRS does what it does. 

Osborne Press

SQL...

Oh brave soul....   The certification debate should a good one.    I myself have a basic level of certification and at the time of gaining said accolade was considering almost...

I suppose in comment on the reason for this post is to 'Challenge Yourself'.  Not only in those things we thought we knew, as software changes...

Too many have been lured from the true path via the Dark certification promise of quick rewards rather than the long road of design permanance and eloquent performance.  

BTW I don't...

Hey Andy.  

Just a personal recount and opinion.

To often people learn one way to achieve a result and then use it to death no matter what the cost.   I had...

After being an avid reader of articles by Steve Jones and others of his ilk, I am always ready to learn from those who know more than I.   But...