Specify the column number instead of name.

Select 1,3,24 from yourtablename

Select into and then deleting is an option but beware to fire these queries if the number of records in your table is huge. Delete might take ages.

Can you...

The metadata about the replication is not stored in user Db, it is stored in distribution. Check system tables and clean up from there.

If you still have the session from where you executed the SP then fire the select query from that session.

This is happening because when you run the package from SQL Agent job it runs on the server and not your local machine; And the config file is not present...

Definitely this can be achieved, You need have 2 new objects:

1. Metadata table in your database - to track the execution of your Import SP.

2. A SQL Agent job -...

Strange! If there would have been a security issue then you won't get page can not be displayed.

Are the reports working fine for builtin\administrators?

Can you try these:

- Run IE...

I beleive that there is no such option. But, if someone knows the solution please post. I am also interested in knowing it.

-Vikas Bindra

I beleive sp_sendmail is not available in SQL server 2000. In 2000 you will have to use xp_sendmail.

-Vikas Bindra

Which reference is missing?

-Vikas Bindra

Yes! Try local Node\Instance name or .\Instance name

-Vikas Bindra

Do you have a "Default Instance" of SQL server on your machine? Because "(local)" and "." works only for default instance. If you have a named instance then you have...

Check the application event log and post the error that you are getting there.

-Vikas Bindra

Lookup itself is a type of transformation.

And, if you wish to know how lookups can be used then check out section "Configuring the Lookup Transformation" in the following link...

Have you tried this:

Click on folder A -> properties -> security -> Add UserA?

-Vikas Bindra