if exists (select *

             from sysobjects

            where id = object_id(N'[dbo].[sp_SQLSMTPMail]')

              and OBJECTPROPERTY(id, N'IsProcedure') = 1)

   drop procedure [dbo].[sp_SQLSMTPMail]

GO

SET QUOTED_IDENTIFIER  OFF    SET ANSI_NULLS  ON

GO

Create Procedure dbo.sp_SQLSMTPMail

      ...

ranec, I think no having to reboot sql or the server itself is the most benefit.  At my shop we are still using sql-mail, but with sql 2005, we have to...

There are pro and con for using sql-mail.  If sql-mail really die, you have to stop and re-start sql server.  I have never heard of smtp mail problem in which...

I've done a couple of downgrade.  Here is what I usually do when I need to do one:

1.backup all databases on the server to be downgrade.

2. Stop SQL Server. Copy...

bcp databasename.dbo.salesperson_dimension out salespersonfile.txt -T -SserverName -c -n

sorry I have never try queryout option.

mom

From BOL:

ALTER TABLE table

{ [ ALTER COLUMN column_name

    { new_data_type [ ( precision [ , scale ] ) ]

        [ COLLATE < collation_name > ]

        [ NULL | NOT...

I started out as a SQL Developer, get my feet really wet, and then became a Junior DBA with the help of the in-house DBA's guide.  He was a great...

Backing it up directly to tape will slow your restore process.  Here we backup to disk, and then veritas back up our backup to tape.

mom

Here is another suggestion.  Ask your dba some questions like how do I do this stuff?  I need this stuff, how do I create it?  This is how I learn, ...

I would like you to restart your server.

Here is 2 suggestion.  Go to add/remove program and try to remove sql server from there.  If it is complete then go to...

I hope your crystal report is not using sa for the login...  regardless of how strong your password is, if you let this password be kept on a file somewhere,...

75 license is only for 75 concurrent connections.  Regardless if you have 5 or 10 people using it, if you are not closing your connection properly, you will have lots...

You could also set the baup folder to only allow administrators group and the sql service account to have full access, and then remove everyone out of that backup folder. ...

Here is the most simplest way, set all your user to use pubs as their default database.  You could change this by using:

sp_defaultdb [ @loginame = ] 'login' ,

    [...

put your backup on a cd and load that cd on the new system.  At restore, you could point it to the cd.

mom