XMd Shell..

Feb 3, 2004

I am not a local administrator on a machine and there is sql server isntalled.
I am logging into the server as a guest user. How do i run the xp_cmdshell??

Is there any way??

Sandu.

View 2 Replies

WM Shell

Sep 22, 2006

hello all,
how can run my application as a first application?
i mean before start up programs.

View 3 Replies View Related

I am attempting to execute xp_cmdshell with a non-sysadmin db login. I have created a Windows account and the associated proxy account in SQL Server. I have verified SQL Server is showing the proxy account credentials. I am still getting the following error. What am I missing? Guidance is very appreciated.

Microsoft OLE DB Provider for SQL Server error '80040e09'

EXECUTE permission denied on object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'.

View 1 Replies View Related

Window Batch Shell

Jul 20, 2006

how do I write a batch script that can tell whether sql express already exist with some instance on the current machine?

View 4 Replies View Related

Lauch Shell As Domain Administrator

Mar 11, 2003

My trigger should launch a shell.
The shell should be launch by a domain administrator.

I don't want that the password can be read by other DBA.

How can I do ???

View 7 Replies View Related

DTEXEC Runs In Its Own Command Shell ?

Nov 29, 2007

Does anyone know if DTEXEC runs in its own command shell area? The reason I am asking this question is that we have hundreds of old DTS packages that fetch data from Source Progress double-byte and standard databases. When we fetch from a double-byte Progress database, the first thing we do is to set System Environment variables and within the same command prompt session invoke DTS packages via DTSRUN utility. THis method works like a charm using the old DTS packages. We are trying to accomplish the same thing using SSIS and are unable to do so. The SSIS package works fine while fetching data from a non Double Byte Progress database but fails miserably while using a Double Byte Progress database. Has anyone experienced something like this? Any solution for this problem?

Thanks

Jagannathan Santhanam

View 25 Replies View Related

Connection String To Conn To SQL From Shell Script

Dec 27, 2007

I have a unix shell script. I need to establish connection to the MS SQL server to execute packages and jobs. Could you please help me out on how to establish this connection as I am new to SQL server. I am using SQL Server 2000.

Thanks,
T.

View 6 Replies View Related

Unix Shell Script And Macros Are Available In SSIS ?

Aug 18, 2006

Hi all ,

i am preaparing POC Document for SSIS and also compare with already created Job in Oracle Using Data Stage Server. The follwing List tasks are we can do in Data Stage Sever.

"
1. Unix Shell scripts can be called before/after the job runs.

2. Programming can be done through:

a. Routines

b. Macros

c. Subroutines

d. Functions

e. Expressions

3. Programming can be done in Mainframe jobs and COBOL code and JCL files can be generated.

4. The DataStage Reporting Tool is flexible and allows you to generate reports at various levels within a project, for example, entire job, single stage, set of stages, etc. "

The above Task will we do in SSIS Pacakge or not ? pls any one give me the correct answer?

Thanks & Regards,

Jeyakumar.M

View 1 Replies View Related

QUESTION: Converting Oracle Shell Scripting From AIX To Windows

Jul 23, 2005

Hi, all...I have a sizeable database running under Oracle 9.2.0.4 under AIX5.2.0.I am faced with an impending move to a Windows environment, runningunder SQL 2000.Currently, we are heavy users of shell scripts, for exports, backups,etc.I am looking for viable scripting options under W2K/W2K3. Maybe sh/kshemulators, VB, Perl...?Scheduling of script operations is also required.Anyone been through this kind of move, who could offer some wisdom?Thanks!DW

View 19 Replies View Related

Any Clues Why DTExec.exe Is Slower Than Business Intelligence Studio(SSIS Shell)?

Sep 18, 2006

All,

I have a simple package in SSIS that reads approx 2.5million rows from SQL2k5 source and exports it into 4 Foxpro files.
The way I do it is as below
1) use and oledb source to read data from SQL2k5
2) use a conditional split component to divide the source into 4 streams ( I do a recId % 4 = 0, 1, 2, 3 to give 4 streams)
3) use an OLEDB destination to export to the 4 prexisting foxpro tables.

This thing runs amazingly fast when I run(F5) it from Business Inteligence studio, but it is atleast 10 times slower when rightclick the package and execute using dtexec.exe

I can't figure out why! any clues??

I would elimiate the 64 bit /32 bit problems because export to foxpro only works in 32 bit mode and my package has been configured to run in 32 bit mode.

Appreciate any insights

Thanks,
Saptagiri Tangudu
PNT Marketing Services

View 13 Replies View Related