I run a stored procedure manually each day without fail using Query
Analyzer.I.E. I right click in the browser window on the stored
procedure hit open and execute. I am trying to get my "DBA" to
schedule this job in Enterprise manager and they keep getting syntax
errors that make no sense and keep asking me to fix the code.
Is there any difference in how the job scheduler executes a procedure
vrs doing it in Query analyzer via Open/Execute that requires a
different SQL syntax??? Im thinking that this problem is not the code
but a permissions issue What are your thoughts? 2 2419
"Philip Mette" <ph******@msn.c om> wrote in message
news:96******** *************** ***@posting.goo gle.com... I run a stored procedure manually each day without fail using Query Analyzer.I.E. I right click in the browser window on the stored procedure hit open and execute. I am trying to get my "DBA" to schedule this job in Enterprise manager and they keep getting syntax errors that make no sense and keep asking me to fix the code. Is there any difference in how the job scheduler executes a procedure vrs doing it in Query analyzer via Open/Execute that requires a different SQL syntax??? Im thinking that this problem is not the code but a permissions issue What are your thoughts?
There should be no difference in syntax, but it may be a permissions issue,
depending on who owns the job. Without seeing the exact errors, though, it's
impossible to make any real suggestions. It would also be useful to know the
version of MSSQL, who owns the job that's failing, and what the stored
procedure does (just data manipulation, or does it use xp_cmdshell for
something etc).
Simon
Syntax or missing object errors?
Make sure they know what database to point at when running it.
"Simon Hayes" <sq*@hayes.ch > wrote in message
news:41******** @news.bluewin.c h... "Philip Mette" <ph******@msn.c om> wrote in message news:96******** *************** ***@posting.goo gle.com...I run a stored procedure manually each day without fail using Query Analyzer.I.E. I right click in the browser window on the stored procedure hit open and execute. I am trying to get my "DBA" to schedule this job in Enterprise manager and they keep getting syntax errors that make no sense and keep asking me to fix the code. Is there any difference in how the job scheduler executes a procedure vrs doing it in Query analyzer via Open/Execute that requires a different SQL syntax??? Im thinking that this problem is not the code but a permissions issue What are your thoughts? There should be no difference in syntax, but it may be a permissions
issue, depending on who owns the job. Without seeing the exact errors, though,
it's impossible to make any real suggestions. It would also be useful to know
the version of MSSQL, who owns the job that's failing, and what the stored procedure does (just data manipulation, or does it use xp_cmdshell for something etc).
Simon
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: PF |
last post by:
On one of our machines, all of the SQL Server 2000
components except for the main Server component (SQL Server
core) itself were installed (Management tools, etc) a while ago
and everything was running fine. Now I go and add/install the
Server component and then Service Pack 3a.
It seems that Service Manager won't start up (I get an hourglass cursor)
and now I find that Enterprise Manager won't run as well. No error
messages appeared...
|
by: ffoiii |
last post by:
I am attempting to connect to a remote default instance of SQL Server
2k on Win2k using Enterprise Manager from my local host but receive a
"SQL Server registration failed, timeout expired" error message each
time.
I am able to connect using Query Analyzer when specifying the IP
address of the server (I am also specifying the IP address in my
Enterprise Manager connection), am able to ping the server from the
command line, and am able...
|
by: bitunwise |
last post by:
I had a problem today where I could not see column names and all
tables had a _1 after them when viewing a Sql Server view in
Enterprise Manager
e.g.
TableName Company when added to the view would be named Company_1 and
the only columns available were 1 which was *(All Columns)
After looking through the news groups I saw several occurrences of
|
by: Thomas Richards |
last post by:
Hi,
I have a table with about 70k rows. When I use open table --> return
all rows and then edit a field Enterprise Manager then says it has to
return the entire result set for the update to take place.
This can take a long time and makes editing data a slow process. Is
there any way to get Enterprise Manager just to update the one row??
Thanks Tom
|
by: Greg Doherty |
last post by:
I am using SQL Server 2000.
I have created a new database in Query Analyzer but I cannot see it in
Enterprise Manager.
I then created a new database in Enterprise Manager, but I can't see it in
Query Analyzer.
How do I get these applications to see the databases that the other creates?
Thanks,
| |
by: jcabc |
last post by:
The row counts I am getting from SQL Enterprise Manager and Query
Analyzer are different. When I double click a table in Enterprise
Manager it gives me a row count of say 1000. However, when I select *
from that same table in Query Analyzer it returns 1028 rows. Anyone
know why or better yet, how to fix it? Thanks!
|
by: Zorba.GR |
last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64
bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite
Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express
Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM
Tivoli Workload Scheduler Virtualized Data Centers v8.2 , other
IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM , other IBM WebSphere Business CDs...
|
by: Alex |
last post by:
Hi Everyone,
Most of our MS SQL Servers are still running on SQL 2000, but being I
will soon be upgrading my workstation to Vista Business I'd like to
install MS SQL 2005 Enterprise Manager to manage them all. When I
tried to install MS SQL 2000 Enterprise Manager on Vista, it gave me a
message saying it's not compatible, so I'll have to use 2005 I guess.
We have LOTS of DTS scripts on our SQL 2000 server, and will 2005 EM
work with...
|
by: chudson007 |
last post by:
Hi All,
What are the pros and cons between using Enterprise Manager or Query
Analyzer for my queries.
Currently I use Enterprise Manager because I prefer the interface and
only use Query Analayzer when queries time out in Enterprise Manager,
but I'm sure there must be more to it.
Regards,
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |