Thanks for the help, Jim. Yes, you were right to add the Agent permission to folder. Leave me only one more problem to deal - send email task.

Thanks again.

Chris

Hi SCC and Matt,

Thanks for the help. I will try:

select * from [PROD].[database].dbo.

tomorrow when I get back to office.

And yes, I signed onto SQL server itself and made sure it...

Hi Stuart,

We just migrated from SQL 2000 to 2005 (Windows server 2003/Ent SP 2). SQL 2000 database was backed up and restored (attached) as SQL 2005 database. Most of procedures...

Hi Roy,

Thanks for the help. Users were creates during database was restored. I checked SID in sysusers; it was populated. Could I just update SID to NULL?

Chris

David,

Thanks for the helping hand.

I got ColTitle1 from a stored procedure. One of column name in CSV should match the name of ColTitle1. If anyway I could something like this:

IF...

Again thanks, Kan. If there is no way output the table variable. A temp table is only solution I have.

Chris

Hi Ken,

Thanks for helping out. I actually simplied dynamic SQL a little bit:

SET @sql = N'

INSERT INTO @tMulti

   SELECT Attribute (from 1 to 20)

   FROM  ...

Hi John,

SMTP is on remote server. I figured it out now. The file was sitting on public server. However, the sub-folder is a private one. I have the access but not...

The file was created inside DTS job. DTS also calls a stored procedure which fires xp_smtp_sendmail. SQL server is a domain account.

Hi John,

Thanks for helping out. I was using the UNC \\servername\xxxx\yyy. I was able to open file from IE by using the link though. I created the file from one...

Hi Journeyman,

Thanks a lot. Agree, save the clustered index key for non identity column if there is a need. But say I am so sure there is no need to...

Hi,

Thanks for tips. I thought hotspot was history after SQL 7.0. Maybe I was wrong.

Chris

Yes, it is for OLTP. But the volume is not huge (< 100 per second for sure). Is there a gotcha for a large volume environment?

Hi Mike,

I was looking at the other article:

http://www.sqlservercentral.com/columnists/bknight/encryptfunction.asp

It did not work for me. The one you pointed works, thanks.

Chris

Hi,

Thanks for help from all og you. The exact error message in SQL Agent step 2:

Date                 5/3/2006 5:01:43 PM