We haven't setup Database Mail (yet) but I had a similiar requirement using SQL Mail on two SQL Server 2000 systems.  I populated a temporary table with the information from...

Although your are being authenticated through the group BUILTIN\ADMINISTRATORS, system_user still returns who you are.  I do not know of any system functions that will return the group through which...

Not sure, but you can give this a try:

CREATE PROCEDURE [dbo].[MY_CREATE_VIEW] AS

WITH EXECUTE AS OWNER

AS BEGIN

    DECLARE @SplitTblName char(5)

    DECLARE @CreateViewScript nvarchar(4000)

    DECLARE @GrantPermissionsScript nvarchar(4000)

    DECLARE @Count...

Your problem is the GO statements after the CREATE PROCEDURE and before the CREATE TABLE, try this:

CREATE PROCEDURE usp_f_job_create_table

AS

    CREATE TABLE [dbo].[f_job](

     [job_id]    [bigint]  NOT NULL,

     [mas_job_no]   [int]   NULL,

     [company_id]  ...

We also need to see what the function(s) that are called are doing.  Without that info, it is hard to determine how to create the set based solution that may...

Looking at what you have posted, I am not sure where to start, so I will start at the beginning.  Can you provide us with a more general description of...

Actually, TOP is valid in SQL Server 2000 as in TOP 100 -- first 100 records or TOP 10 PERCENT -- top 10 percent of all rows).  What isn't valid...

When I have used DTA, I have also only implemented part of the recommendations.  I tend to ignore the statistics it tells me to add, and concentrate on the indexes. ...

To use a term from Jeff, looks like RBAR (Row By Agonizing Row).  I would revisit your update process and look at rewriting it use a set based solution instead...

The alter table statement adds the column to the "end" of the record.  I was also alluding to the use of EM/SSMS to modify the table.  I have had developers...

Not going into any details, as I would need more information regarding your stored prc, it looks like you will need to build your query in the stored procedure dynamically...

Yes, you can add a column to a table in production.  If it does not allow nulls, you need to include a default value.  Also, you should add it to...

Short answer, yes.

If you only knew.......

I think I was born confused, but of course with 2 teenager girls at home, that could account for it also.