What User ID do you use when you execute the Stored Procedure in Query Analyzer?

What happens if you use the User ID of the SQL Agent Service Account?

I just remembered that I did this before and I believe that I used s a Execute SQL Task.

I defined the From & To as well as the body. You...

Check BOL for a definition of:

SUSER_SNAME function

SYSTEM_USER function

BOL clearly state what the functions do and it is easy to identify the differences.

Some of the things that you can do is run profiler and look in the Text Column for DML.

Capture those DML statement to insure that the operation was performed.

You can...

I noticed thyat in addion to no clustered Indexes there are no Unique Indexes on the table?

Do you delete Statement remove a range of records or a single record?

What statement is in executing in the first step that failed?

Could you tr executing in a Test envionment?

Does the statement fail when you run in interactive mode? If so what...

Visio 2007 has made great strides and is relative inexpensive.

You can create relational diagrams, reverserve engineer and existing databas to generate an ERD, etc

If you run a DTS Package it will run very slow.

If you schedule to run from the Server as a Job you will see a noticiable improvement.

If you are test...

I had to do this. The code was taken from me. You can use the Dynamic Properties task but please be aware there are other options.

Unfortunately I can't remember the...

Securing SQL Server 2000 Data Transformation Services (DTS) packages is important, especially if you work with DTS a lot. By default, anyone with a login to SQL Server can create...

I have done this before, many years ago.

I used Global variables to specify the path.

I would read the files in the directory and assign the most recent file by using...

Thanks The GrumpyOldDBA...

What is your recovery model set to?

If it is set to full then you can perform a point in Time recovery.

]

If it is set to Bulked-logged then you can still...

I regret making the dumb post very early in the morning.

I provided an incorrect response.

When I mention "Concept" I was thinking of the ALTER INDEX Command which is a new...

Could you please refer to the article listed below and let me know if this helps?

Regards,

Kent

http://www.mssqltips.com/tip.asp?tip=1853