f



Explicitly fail a SQL Server Job in SQL Server 2000

I have a SQL Server job, which runs mutiple steps.  One of the steps
(step 3) looks for a record in the database.  How can I explicitly fail
the SQL server job if the database record does not exist?

0
7/5/2005 10:45:06 PM
comp.databases.ms-sqlserver 14567 articles. 1 followers. janinepelletier (108) is leader. Post Follow

2 Replies
641 Views

Similar Articles

[PageSpeed] 6

You can use RAISERROR with a severity level of 11 or higher to indicate
failure.

Simon

0
sql (2120)
7/6/2005 7:30:42 AM
Thanks Simon.  That worked.

0
7/7/2005 8:49:52 PM
Reply:

Similar Artilces:

MicroSoft SQL Server 2000, Service Pack 2, AppDev SQL Server 2000 Accelerated Training [3 CDs], TransTrainer for Designing Microsoft SQL Server 2000 Databases v1.1, SQL Server 2000 Reporting Ser
MicroSoft SQL Server 2000, Service Pack 2, AppDev SQL Server 2000 Accelerated Training [3 CDs], TransTrainer for Designing Microsoft SQL Server 2000 Databases v1.1, SQL Server 2000 Reporting Services, (Enterprise), Developer Edition 64 Bit, other 16,000 more CDs, [ no dongles, no activations, etc ... needed ! ] (free donge)! No time limitation! CD NR 4203 MicroSoft SQL Server 2000 4in1 CD NR 9452 Microsoft SQL Server 2000 Service Pack 2 CD NR 11 298 AppDev SQL Server 2000 Accelerated Training [3 CDs] CD NR 12 000 Microsoft SQL Server 2000 Developer Edition 64 Bit CD NR 13 424 TransTrainer for Designing Microsoft SQL Server 2000 Databases v1.1 CD NR 14 688 SQL Server 2000 Reporting Services (c) Microsoft CD NR 15 412 SQL Server 2000 Reporting Services Enterprise (c) Microsoft please send e-mail, to ola2@mail.gr, zorba@mail.gr ...

SQL Server 2000 SQL Agent Error [393] Waiting for SQL Server to recover databases
While I was out of the office the Lan Team moved one of my SQL Server 2000 servers to a new network domain. Since then the maintenance job has not ran. The error log for the SQL Agents has the message listed in the subject line. I have not found any useful articles on the MS SQL Server site. Anyone know what might be wrong and how to fix it. HTH -- Mark D Powell -- Mark D Powell (Mark.Powell@eds.com) writes: > While I was out of the office the Lan Team moved one of my SQL Server > 2000 servers to a new network domain. Since then the maintenance job > has not ran. > > The error log for the SQL Agents has the message listed in the subject > line. I have not found any useful articles on the MS SQL Server > site. Anyone know what might be wrong and how to fix it. I would try select * from master..sysdatabases where databaseproperty(name, 'IsInRecovery') = 1 and see if that finds something. There are a couple of more properties for Databaseproperty that you should search for. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx On Jan 30, 5:30 pm, Erland Sommarskog <esq...@sommarskog.se> wrote: > Mark D Powell (Mark.Pow...@eds.com) writes: > > > While I was out of the office the Lan Team ...

Using MS SQL Server 2005 Enterprise Manager with MS SQL Server 2000
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 these okay? Also I want to make sure SQL 2005 Enterprise Manager won't be adding to, changing, or 'upgrading' the DTS scripts or anything on the SQL 2000 servers as we still have folks using SQL 2000 Enterprise Manager. Thanks for any suggestions. I'm always leery when using cross-versions of Microsoft applications because they are often incompatible or they do squirly things that often break stuff. Thanks -- Alex Alex (samalex@gmail.com) writes: > We have LOTS of DTS scripts on our SQL 2000 server, and will 2005 EM > work with these okay? Also I want to make sure SQL 2005 Enterprise > Manager won't be adding to, changing, or 'upgrading' the DTS scripts or > anything on the SQL 2000 servers as we still have folks using SQL 2000 > Enterprise Manager. > > Thanks for any suggestions. I'm always leery when using cross-versions > of Microsoft applications because they are often incompatible or they > do squirly things that often break stuff. There isn't any Enterpr...

MS SQL Server 2000 and MS JDBC SQL Server driver problems. (Connection timed out, followed by Error establishing socket)
I have downloaded the MS SQL Server 2000 Enterprise Evaluation edition, and the MS SQL 2000 Server JDBC driver. I have installed and configured the MS SQL Server 2000 onto two computers, which reside on the same network. (In fact, these two computers comprise the entire network). The network server (computer name=SUNCDS1), and the lone node (SUNCDS2), each have their own SQL Server 2000 instance. The SQL Server 2000 Enterprise Manager console on SUNCDS1 shows both SQL Server instances, the (local) instance, which is SUNCDS1, and also SUNCDS2. It may be worthwhile to mention that the SUNCDS2 instance on the Enterprise console does not show the SQL Server Agent as being started, but I can navigate to the SUNCDS2 databases, and display the table information. If I try to start the SQL Server Agent for SUNCDS2, I receive the message "Access is Denied". The enterprise console on the SUNCDS2 machine indeed shows the SQL Server Agent as being started. I have written a sample Java application that uses both the MS SQL Server ODBC driver and a JDBC type 4 driver (MS SQL Server 2000 JDBC) to establish a connection to the SUNCDS2 instance. This application resides on the SUNCDS1 network server. The ODBC driver will connect to SUNCDS2 instance wihout a problem. The JDBC driver does not connect to SUNCDS2. The JDBC driver will, however, connect to the local SQL Server instance that resides on SUNCDS1. Following are the code snippet to est...

Multiples Instance of SQL server 2000/SQL server 7.0 on Windows server 2003
Hi, Is it possible to install on a Windows server 2003, SQL SERVER 2000 in the folowing configuration : SQL server 7.0 as a default Instance and SQL server 2000 as a named instance. Thanks for your answer. riless (g.carali@voila.fr) writes: > Is it possible to install on a Windows server 2003, > SQL SERVER 2000 in the folowing configuration : > > SQL server 7.0 as a default Instance > > and > > SQL server 2000 as a named instance. If SQL 7 can be installed on Win2003, yes. But I would not really expect SQL 7 to be welcome on Windows 2003, although I don't...

Entreprise Manager error message: "[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '#####'. The user is not associated with a trusted SQL Server connection.(28000,18452)"
Can anyone give a quick description of the meaning of this message and what needs to be done to get a connection. I'm running DBArtisan with SQLServer 2000 client SP4 installed. I also get the same message with MS Enterprise Manager so this is coming out of the actual ODBC connection attempt. Thanks in advance! In the future, please do not put part of your message in the subject line. Makes it harder to read. In any case, you're trying to do integrated login and don't have that login set up in the DB. You need to add that login, or change to a SQL Login. -- Greg Moore SQL Server DBA Consulting Remote and Onsite available! Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html "byrocat" <strikemaster2000@yahoo.ca> wrote in message news:a1fc2ee7-94f6-40e2-9da9-6358130e11f4@e67g2000hsc.googlegroups.com... > Can anyone give a quick description of the meaning of this message and > what needs to be done to get a connection. > > I'm running DBArtisan with SQLServer 2000 client SP4 installed. > > I also get the same message with MS Enterprise Manager so this is > coming out of the actual ODBC connection attempt. > > Thanks in advance! ...

Access database(Jet Engine) and SQL Server or SQL Server express
Hi, I am trying to find out what are the big differences between access database Jet engine and SQL Server? If I have serveral web applications (same content different copies) running as different sites(on IIS), each site using an access as a back-end database, all sites will be running simultaneously, all the access databases are on the same machine, on this approach, does each copy of access has its own Jet engine to handle database transaction or only has one Jet engine with multiple threads handles multiple copies of access database. Also, I'd like to know what kind database, and database engines are used by big sites such as Yahoo, Hotmail, MSN, etc, and what are the good database structures for the hosting applications that deal with huge,complex information and large number of users. Thanks a lot, your time and help are highly appreciated. On 13 Sep 2004 18:37:35 -0700, penghao98@hotmail.com (Leon) wrote: I think there is only one instance of Jet running. You can check this using Task Manager. More than likely you don't have to worry about Yahoo et al. They take many orders of magnitude more traffic then yours. One thing for sure: they are not using an Access back-end :-) -Tom. >Hi, > I am trying to find out what are the big differences between access >database Jet engine and SQL Server? If I have serveral web >applications (same content different copies) running as different >sites(on IIS), each site using an access as a back-end database...

SQL Server 2000 Failover Cluster upgrade to SQL Server 2005
I attempted to upgrade my SQL Server 2000 Enterprise Edition (32 bit) to SQL Severer 2005 EE 32 bit and while the prereqs passed the installer will not let me select the version 8.00.x (2000 SP4) database that it finds on the server. When I ckeck the install details it tells me that "Your upgrade is blocked becuase of cluster upgrade rules" I have tried searching the MS site but none of the entries I found appear to apply. Any ideas? -- Mark D Powell -- Mark D Powell (Mark.Powell@eds.com) writes: > I attempted to upgrade my SQL Server 2000 Enterprise Edition (32 bit) > to SQL Severer 2005 EE 32 bit and while the prereqs passed the > installer will not let me select the version 8.00.x (2000 SP4) > database that it finds on the server. > > When I ckeck the install details it tells me that > "Your upgrade is blocked becuase of cluster upgrade rules" > > I have tried searching the MS site but none of the entries I found > appear to apply. > > Any ideas? Exactly when do you get this error? And do you have a cluster in the first place? I have not run that many upgrades (if any at all) to SQL 2005, but do you really select which *database* to upgrade? The upgrade is per instance, as far as I know. In any case, it may be simpler to install a new server instance rather than upgrading, not the least on a cluster. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: h...

move/copy database objects from SQL Server Express to SQL Server Standard??
Can anyone refer me to good 'recipes' or sources of information on this topic?? I have Visual Studio Tools for Office, which installs SS 2005 Express locally to my XP box, and I want to develop in SS 2005, then copy the tables or queries or reports etc. to a SS 2005 Standard server. Thank you, Tom Hi Tom If the objects are on source code control you may just want to check out the scripts and run them through SQLCMD. If you want the whole database then you can either use backup/restore or sp_detach_db/sp_attach_db, failing that you could use the import/export wizard, If SQLExpress is does not allow external connections then you will need to push it (export) from the SQLExpress machine. Check out http://support.microsoft.com/kb/314546 John "tlyczko" <tlyczko@gmail.com> wrote in message news:1157561832.911996.148780@b28g2000cwb.googlegroups.com... > Can anyone refer me to good 'recipes' or sources of information on this > topic?? > > I have Visual Studio Tools for Office, which installs SS 2005 Express > locally to my XP box, and I want to develop in SS 2005, then copy the > tables or queries or reports etc. to a SS 2005 Standard server. > > Thank you, Tom > I should have said SS 2005 Developer, not Express, I am installing SS 2005 Dev to my workstation here. But everything you said should work, I just have to learn how!!!!!!!! I will read the KB article, I suppose I could learn SSIS for just tables ...

Installing MS sql server 2000 on win 2003 server
How do I do this when my instalation cd is an old veriosn with no SP�s? Win 2003 requires MS SQL 2000 SP3 sp what do I do??? Regards Anders > When you get the prompt saying that it must be SP3 you can continue to the > end of the installation as per normal. You should then install SP3 > immediately before you do anything else. SP3a can be download from the > microsoft web site. Actually not. It says: Ms SQL Server 2000 Enterprise Ediditon server componenet is not supportet on this operating system. Only client componentes will be avaible for instalation. I juts read that bef...

Database link to a MS SQL Server 2000
Hi NG, we have to replikate some data between an oracle DB and an application with MS SQL Server. There is no possibility to load and push the data on the client mashine. We have to replicate the data on the server mashines directly. Is there a possibility to create a DB link from oracle to MS SQL Server or otherwise? thanx abbas On Thu, 9 Jun 2005 00:13:02 +0200, "Abbas" <ar.newsgroup@web.de> wrote: >Hi NG, > >we have to replikate some data between an oracle DB and an application with MS SQL Server. > >There is no possibility to load and push the data on the client mashine. We have to replicate the data on the server mashines >directly. > >Is there a possibility to create a DB link from oracle to MS SQL Server or otherwise? > >thanx >abbas > Look into using Heterogeneous Services in your Net administrators manual. -- Sybrand Bakker, Senior Oracle DBA Are you willing to install a bridge program to create this "link"? If so, then try www.examinstudio.com Do as Sybrand told you, look at the Heterogenous services of Oracle. Oracle even supports natively DRDA towards a DB2 z/OS mainframe, and they also support SQL Server. They all end-up like a database link with a totally quallified names in the "from" clause. Be aware of that distributed joins between different DBMS systems might cause huge performance problems, keep the functionality when dealing with multiple DBMS systems simple, no dist...

insert fails
Hi, I configured a linked server in MS SQL Server v8 pointing to a remote AS/400 DB2 database. I used Client Access ODBC driver (v7), installed it from a Client Access Express v4.5. Select/update/delete seems to be working fine, I just cannot execute an insert statement. Here's the error I'm getting: update as400..U1.TB1 set a = 4 select * from as400..U1.TB1 insert into as400..U1.TB1 ( a ) values (1) ------------------------------------------------------ Server: Msg 7399, Level 16, State 1, Line 4 OLE DB provider 'MSDASQL' reported an error. The provider did not give any inf...

SQL Server "Linked Server" to MS Access Database
I have a very frustrating problem. I have a situation that works fine on some computers, but not on others. I have SQL Server Express 2005 and Access 2003 loaded on 4 computers. I have set up a "Linked Server" in SQL Server linked to my Access database. I am running queries on t-SQL against the Access tables through the linked server. On all of the computers, I can do select queries and they all work great but what I need to do is run Update, Insert, Delete queries as well. On a couple of the computers, it works fine, locally and across the LAN, and a VPN as far as that goes. But on other computers I can do Select queries (also across the network) but no update queries. I get the error message "OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "securedjetls" returned message "Operation must use an updateable query." where securedjetls is the name of the linked server. The Access database on the computer that is not working is a copy of the database from the computer that is working and any of the tables that I'm trying to update have primary keys, so that's not the problem. ...

Transfer Database from one Pervasive SQL 2000i server to Another Pervasive SQL 2000i Server
Any tips on how to transfer the data files from one Pervasive SQL 2000i database to another Pervasive SQL 2000i database. Please advice ASAP Thanks Sajid Saeed Simply copy the files from one server to the other. Sajid Saeed wrote: > Any tips on how to transfer the data files from one Pervasive SQL > 2000i database to another Pervasive SQL 2000i database. > > Please advice ASAP > > Thanks > > Sajid Saeed If you are just wanting the whole database from one server on another copy the files over. May need to set up an engine DSN on the new server for SQL/ODBC acce...

Oracle DB to MS Sql Server DB Replication question...via Sql Server Views??
Hi, I'm not sure if this is even possible, but I've been asked to look into replication from Oracle to Sql Server. He's the situation: We have access to a remote Oracle database, but only read access (not allowed to configure or change the db). We own a Sql Server database with Views that use a link server to query the Oracle database. With this setup, is it possible to replicate the Oracle database? Can we do a replication from the Sql Server with the Views into another Sql Server database, and if we can, will it be able to only pull the delta for subsequent replications? Any tips and hints would be helpful. Pleeease! Thanx, Doemon doemon@gmail.com wrote: > Hi, > > I'm not sure if this is even possible, but I've been asked to look > into replication from Oracle to Sql Server. He's the situation: > We have access to a remote Oracle database, but only read access (not > allowed to configure or change the db). > We own a Sql Server database with Views that use a link server to > query the Oracle database. > > With this setup, is it possible to replicate the Oracle database? Can > we do a replication from the Sql Server with the Views into another > Sql Server database, and if we can, will it be able to only pull the > delta for subsequent replications? > > Any tips and hints would be helpful. Pleeease! > I don't know the answer to the second question, nor your versions, but the first sh...

SQL Server 2005 + SQL Server Express
Hi, I have SQL Server 2005 installed on my dev system. I am working on an app that i would like to distribute SQL Server with. SQL Server EXpress edition seem to be ideal for this. My questions are: -If i installed Express Edition, Can both SQL Server 2005 and Express Edition coincide peacefully on the same PC? -Which one will Visual Studio see? (currently i created by database using VS, which i assumed created a SQL Server 2005 database, since that is the sql server i have installed). -When VS2005 is installed, which SQL Server is installed and how can i tell which one VS2005 is using if i have both SQL servers (2005 and Express) installed? thanks much farseer (farseer@optonline.net) writes: > -If i installed Express Edition, Can both SQL Server 2005 and Express > Edition coincide peacefully on the same PC? Yes. SQL Server permits multiple instances being installed on the same server, and this can be multiple instance of Express Edition, multiple instance of, say, Enterprise Edition, or any mix thereof. Furthermore, to prevent collisions, SQL Express installs by default as a named instance, \SQLEXPRESS whereas other editions of SQL Server by default installs as default instances, which do not have any extra name, > -Which one will Visual Studio see? The one you point it to. I assume here that you mean the database that you connect to for development purposes. Some parts of VS like the compoent in Team System for Database development uses the Express ...

Trying to create a linked server from an SQL Server to another SQL Server on another machine.
I'm Trying to create a linked server from an SQL Server to another SQL Server on another machine. Can anyone suggest some good reference material or tutorials?? So far I'm only finding examples for a linked server to an ACCESS database. Thanks in Advance! gdev (paul.afamdi.okeke@gmail.com) writes: > I'm Trying to create a linked server from an SQL Server to another SQL > Server on another machine. > > Can anyone suggest some good reference material or tutorials?? So far > I'm only finding examples for a linked server to an ACCESS database. There are plenty of examples in the topic for sp_addlinkedserver. In many cases, it is as simple as: exec sp_addlinkedserver THATSERVEROVERHERE exec sp_serverioption THATSERVEROVERTHERE, 'data access', true Authentication does not always work though, and in this case sp_addlinkedsrvlogin comes to the rescue. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx ...

migrate Progress database to MS SQL Server 2000 #2
I am afraid that our customer has already made up his mind about movin to MS SQL server and there is nothing that we can do about it Is there a migration tool -- panagiotis@mel ----------------------------------------------------------------------- panagiotis@melo's Profile: http://www.progresstalk.com/member.php?action=getinfo&userid=817 View this thread: http://www.progresstalk.com/showthread.php?threadid=7937 Yes ther is. You'll find it between your ears. Regards...Dan. "panagiotis@melo" <panagiotismelo.1gvuzm@progresstalk.com> wrote in message news:panagiotismelo.1gvuzm@progresstalk.com... > > I am afraid that our customer has already made up his mind about moving > to MS SQL server and there is nothing that we can do about it. > > Is there a migration tool? > > > -- > panagiotis@melo > ------------------------------------------------------------------------ > panagiotis@melo's Profile: > http://www.progresstalk.com/member.php?action=getinfo&userid=8173 > View this thread: > http://www.progresstalk.com/showthread.php?threadid=79374 > crossmerge.com ? Regards...Dan. "panagiotis@melo" <panagiotismelo.1gvuzm@progresstalk.com> wrote in message news:panagiotismelo.1gvuzm@progresstalk.com... > > I am afraid that our customer has already made up his mind about moving > to MS SQL server and there is nothing that we can do...

Can Analysis Server and Report Server run on SQL Server 2000 Cluster
I have installed Analysis Server (AS) and Reporting Services (RS) on SQL Server 2000 before. Now I have been asked to install these on a failover Cluster we have. Previously I just ran the SQL Server 2000 install program off our network disk and then ran the SP4 patch to install AS. When I ran the install and chose AS there was no indication from the software that it recogned that I wanted it to install on a cluster. After it said it successfully installed the SP4 upgrade failed with a buffer overflow problem. Anyone out there know the proper procedure (url)? -- Mark D Powell -- On Aug 10, 2:57=A0pm, Mark D Powell <Mark.Pow...@eds.com> wrote: > I have installed Analysis Server (AS) and Reporting Services (RS) on > SQL Server 2000 before. =A0Now I have been asked to install these on a > failover Cluster we have. > > Previously I just ran the SQL Server 2000 install program off our > network disk and then ran the SP4 patch to install AS. =A0When I ran the > install and chose AS there was no indication from the software that it > recogned that I wanted it to install on a cluster. =A0After it said it > successfully installed the SP4 upgrade failed with a buffer overflow > problem. > > Anyone out there know the proper procedure (url)? > > -- Mark D Powell -- I had found a document that said RS 2000 can run on a cluster but what the document had not made clear is that while the RS 2000 database can be on a cluster that RS its...

Once a week Kerberos failure between IIS6 web server and SQL Server 2000 db server
Hi, Regularly once a week we get problems with a Kerberos failure on ouintranet application. Kerberos is set up with Constrained Delegation and Protocol Transition. Configuration: S3 ...

Sql Server 2000 linked server to Access 97/2000 incompatability
We are experiencing a problem with Sql Server 2000 linking to an Access 97 file. We have two machines that link to this .mdb file, and we recently upgraded one to newer hardware, SP3a, MDAC 2.8, etc. The link on this upgraded machine no longer works, giving this message: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [OLE/DB provider returned message: Cannot open a database created with a previous version of your application.] OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize r...

A server for SQL Server
We are considering migrating our Access backend to SQL Server or something similar. I am hearing rumors that our server will have to be a really expensive, beefed-up version. Can anyone shed some light on that? Thanks, Hank Reed No, because it's bogus. You can run SQL Server on some *very* minimal equipment, but remember that you get what you pay for. Running SQL on a under-powered machine works, but you loose time as the employees wait for it to respond. Think of it as owning a high performance car (Lamborghini, Porsche, Ferrari, etc.) as your desktop machine. It will seem like quite a waste if the only place you have to run it (the server) is on city streets. Likewise your network is also an issue. If you network can't handle the load.... Basically, you want your server to be faster then the client PCs, however you also should remember that you also want to transfer as much processing as you can from the Access application to the SQL Server to take advantage of the reduced network load and speed of a SQL Server. As such, and if you transfer the queries to the SQL Server, the Server machine doesn't have to be anywhere as "powerful" as the client machines hooked up to it. 3 or 4 systems back seems to be a good "rule of thumb" when looking at a machine to run SQL Server. The number of transactions and users who need to access the machine can change that upwards however. Or downwards, if only a couple of people need it. On 28 Jul...

Import XML file to database (MS Server 2000) using procedure (transact sql) ???
I must import some exemplary file to database (MS Srrver 2000) ofcourse using procedure Transact SQL. This file must: 1.Read the xml file 2. Create table 3. Import this date from xml file to my database Ps. I create procedure who File xml imports to base, but unfortunately she only schedule when earlier create a table or table is created.So I need (I think) create such mini parser in language transact SQL. Does someone have some ideas? For every help Thanks ==== example file xml =========================================== <root> <Cust> <IDosoby>1</IDosoby> <Imie>Lukasz</Imie> <Nazwisko>Przypadek</Nazwisko> </Cust> <Cust> <IDosoby>2</IDosoby> <Imie>Dariusz </Imie> <Nazwisko>Mroz</Nazwisko> </Cust> <Cust> <IDosoby>3</IDosoby> <Imie>Tomasz</Imie> <Nazwisko>Kolo</Nazwisko> </Cust> </root> =========================================================== -- Luk Not sure of the exact requirement. But if you can parse the XML and then using OPENXML shred it into a new table. SELECT * INTO <MyNewTable> FROM OPENXML (@idoc, '/root/') Where @idoc is the document handle of the internal representation of an XML document. -- HTH, Vinod Kumar MCSE, DBA, MCAD, MCSD ...

DTS Works, job fails!(data source Foxpro and destination SQL Server 2000
The DTS works perfectly when I run it manually. However, when I run it as a job it fails. Before you ask if i'm running it under different security context. I have already made sure of that. I was logged into the server through remote viewer, when I created and ran the package, as well as scheduling the job. So the accounts they're running under are consistent. They're the same accounts as the SQL Agent is running under and it's the sys admin account. The data source is a Fox pro database with a pull of two tables. I am using Microsoft OLE DB Foxpro driver as my source connection and OLE DB Connection for SQL Server as my destination. I am doing a simple table to table transformation. The path of my connection is a mapped Drive: E:\Main. There are other packages and jobs within my job queue that are pointing to the same database and they seem to run fine using the above mapped drive. The ONLY difference between this package and other packages are that, they're few months old and this one was created last night. I have also enabled logging on this package and here is the below error when the job fails: Package Steps execution information: Step 'DTSStep_DTSDataPumpTask_1' failed Step Error Source: Microsoft OLE DB Provider for Visual FoxPro Step Error Description:Invalid path or file name. Step Error code: 80040E21 Step Error Help File: Step Error Help Context ID:0 Step Execution Started: 9/23/2006 11:39:17 AM Step Execution Completed: 9/23/200...

Web resources about - Explicitly fail a SQL Server Job in SQL Server 2000 - comp.databases.ms-sqlserver

List of scientific societies explicitly rejecting intelligent design - Wikipedia, the free encyclopedia ...
Q & A on Evolution and Intelligent Design: Is intelligent design a scientific alternative to contemporary evolutionary theory? No. Intelligent ...

Facebook News Feed Algorithm To De-Emphasize Stories From Apps Unless They Are Explicitly Shared
... stories from applications in News Feed , as Facebook announced a change to its News Feed algorithm that will emphasize what it calls explicitly ...

Christian Refugees Prioritised In An Explicitly Unchristian Way.
Debate over increased intake of Syrian Refugees has heated up with calls that any agreement to resettle those fleeing should include stipulations ...

Coalition amends terror laws to explicitly prohibit torture by security agents
NATIONAL security agents will be expressly prohibited from committing torture, after Senate crossbenchers threatened to withdraw support for ...

Torture will be explicitly prohibited in new counter-terrorism laws, Attorney-General George Brandis ...
New laws to bolster the powers of security agencies could face changes because of crossbench fears that the legislation allows suspects to be ...

Facebook News Feed Algorithm To De-Emphasize Stories From Apps Unless They Are Explicitly Shared
... stories from applications in News Feed , as Facebook announced a change to its News Feed algorithm that will emphasize what it calls explicitly ...

Rick Warren explicitly bans "unrepentant" gays from membership in his church
... us in his church. This is from the Saddleback Church's own Web site . You know things are bad when the church goes out of its way to explicitly ...

Android adware can install itself even when users explicitly reject it
(credit: Lookout) Two weeks ago, Ars reported on newly discovered Android adware that is virtually impossible to uninstall . Now, researchers ...

Fox News decries movie designed explicitly to sell toys as "anti-business"
Following the instructions on the back of their ideological boxes, Fox constructs another controversy.

China gay arrests 'explicitly linked' to Tiananmen anniversary
The BBC's John Sudworth says the arrest of gay activists is a sign of how sensitive the Chinese authorities are ahead of the anniversary of the ...

Resources last updated: 3/22/2016 5:44:38 AM