Agreed I can't find out what we are suppose to do.  I too am more interested in the survey although the newletter is a nice feature.

Cool, that solves my problem.  I must been doing something wrong in my syntax before.

Great idea!

Is there a way to lock the view while it is in use and being changed?  Or how to you keep a second instance of your sp from stepping...

I too like temporary tables, I don't use them to often but find them a good alternative to cursors.  Recently I have had reason to use a global temp table...

This definately sounds like a poor idea to me.  For them to log enough information to actually identify a person and what that person was doing would be an insane...

It sounds like you used the DTS to SSIS migration tool on your packages.  It has been my experience that this tool will attempt to convert your packages and any...

Your legacy DTS packages (those not upgraded to SSIS) are in Management/Legacy/Data Transformation Services.  Once you have the Microsoft SQL Server 2000 DTS Designer Components  installed, just right click on...

Hi Veljko,

  Bummer by first reply got erased.  Oh well here goes again.  I like your idea, it is a good challenge and one which I didn't think of at...

I only have a few servers with critical jobs and we monitor them primarily through email.  However I have been planning on writing a script to monitor status information.  Thanks...

Nice going, I love learning new tidbits like this.  Articles such as these are what makes this site great and a wonderful early morning read.

short commute or working from home would probubly be my top two priorities.

Of course I do love the money but I would prefer knowing that when I go to work...

I discovered that on our old reporting server all the reports which accessed remote sql servers used sql authentication.  Because of the increase in network traffic that kerberos causes, we...

Hey Paul, I wish I could say such things about my younger years.  Unfortunately I didn't really start gaining enough understanding of computers to pull off such stunts until I...

Your right, it is one of the more common words I miss-spell.  I meant ingenious.

However the meaning could still sort of apply.

Most of the programs I wrote when I first started were in VB3 and were designed to help my parents.  I wrote movie and recipy organizers as well as a...