create a DTS package that first exports the table data to a file and then zips it. you can access the cmd functions.

BOL 2005

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/fulltxt9/html/a0ce315d-f96d-4e5d-b4eb-ff76811cab75.htm

you will find all the info you want.

Set cmd = New ADODB.Command

cmd.ActiveConnection = cn

cmd.CommandType = adCmdStoredProc

cmd.CommandText = "sqInboundSampleNo"

cmd.Parameters.Append cmd.CreateParameter("@sampleno", adVarChar, adParamInput, 6, sampleparam)

Set rs = cmd.Execute

If Not rs.EOF...

Ref: BOL

Full-Text Catalogs and Indexes

A Microsoft® SQL Server™ 2000 full-text index provides efficient support for sophisticated word searches in character string data. The full-text index stores information about significant words...

you can then put the above code in a scalar user defined function.

does your erp system export the data using DTS, or can you customise your erp to create an additional file after it has created the one you want to import?

are...

this is a critical piece of info that you should have highlighted earlier.

i think you should have a table that is not really a temp table but then have an...

here is my two senses to your problem.

it would help if i have your project table and type table definitions

---

-----

CREATE TABLE PROJECT

(

PROJECTID INT,

TYPEID INT

)

CREATE TABLE TYPE

(

TYPEID int,

TITLE

)

CREATE TABLE SUBTYPE

(

SUBTYPEID INT,

TYPEID

TITLE

)

CREATE...

why don't you use dynamic tables, that way you won't have to worry about them errors coming up.

e.g. from BOL 2005

USE AdventureWorks;

GO

DECLARE @MyTableVar table(

EmpID int NOT...

i don't think you should be assigning logins to the msdb database. you could assign their usernames to one of the server roles.

you have to look no further than on this website

SQL 2005 Symmetric Encryption

http://www.sqlservercentral.com/columnists/mcoles/sql2005symmetricencryption.asp

http://msdn2.microsoft.com/en-us/library/ms187798.aspx

http://www.databasejournal.com/features/mssql/article.php/3483931

>However I can't find anywhere on how to create the certificate

Truncate Table is essentially T-SQL so you could conceptually use the following T-SQL event classes

SQL:BatchStarting

SQL:StmtCompleted

SQL:StmtStarting

You then probably do a filter on the TextData column like %Truncate%

Hope that helps

What's more secure really depends on your security policies and by how much they are implemented.

If you use Windows Authentication, you take advantage of all the goodies that come with...

i think this is the easiest solution.

>Add the servers from which you need to fetch the data as linked server using >sp_addlinkedserver