running a query within a DTs package

IF a run a query from within a DTS package will I have to use complete instructions, i.e. will I have to include in the query the name of the table that i am importing from or will the DTS package assume this?
thanks!Are you referring to performing a sql or transact/sql statement from within an execute sql task?

If so, despite you establishing a connection with one or more servers/dbs (transform data task or not) you should have to specify the table you are referencing... when you are in the execute sql task properties (ie when you double click) you need to specify which server connection you are using in order to reference that specific table. There is a drop down box in the task's properties window called existing connection... pick the connection which references the server/db that contains the table which you will be performing a query on... You don't want to perform an update statement on tblcustomer (located in db1) and not specify the correct connection in which to find it!

I hope that is what you were asking for if not, give a little shout back with a little more detail and we'll see what we can do.sql

RUN SQL Profiler with non sysadmin role in SQL Server 2000

Hi,

Is it possible to RUN SQL Profiler with non sysadmin role in SQL Server 2000?
Is it possible to include the GRANT ALTER TRACE function to SQL Server 2000?
David Chai
davidch@.avanade.com

Hi David,

It's NOT possible to use SQL profiler with non-admin role in SQL Server2000, NOR can you use "Grant Alter Trace" to grant a non-admin an access to run profiler in SQLServer 2000.

This feature is new in SQLServer 2005.

Please let me know if you have any questions.

thanks,

Allen

RUN SQL Profiler with non sysadmin role in SQL Server 2000

Hi,

Is it possible to RUN SQL Profiler with non sysadmin role in SQL Server 2000?
Is it possible to include the GRANT ALTER TRACE function to SQL Server 2000?
David Chai
davidch@.avanade.com

Hi David,

It's NOT possible to use SQL profiler with non-admin role in SQL Server2000, NOR can you use "Grant Alter Trace" to grant a non-admin an access to run profiler in SQLServer 2000.

This feature is new in SQLServer 2005.

Please let me know if you have any questions.

thanks,

Allen

run both enterprise and msde on same box

Is it possible to run both MSDE and enterprise edition (sql server 2000)
on the same box?
I am working on an application that will include MSDE, and I'd like to
test it on my developing machine that is already running Enterprise. I
could just shut off Enterprise, but the MSDE needs to be a subscriber,
so they both need to be running.
Thanks,
-Casey
hi,
C Williams wrote:
> Is it possible to run both MSDE and enterprise edition (sql server
> 2000) on the same box?
> I am working on an application that will include MSDE, and I'd like to
> test it on my developing machine that is already running Enterprise. I
> could just shut off Enterprise, but the MSDE needs to be a
> subscriber, so they both need to be running.
yes, it can be done..
up to 16 instances can be installed on the very same machine, resources
permitting :D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply