Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
|
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 15th, 2008, 09:54 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 108
Thanks: 0
Thanked 0 Times in 0 Posts
Default What needed to create a job in SQL Server 2005

Hi, all experts,
I am a database user not sa, I have SQLAgentUserRole permission, I need to create a job to read data from text file and store these data in DB. I try to create a job but get something like "Execute
permission was denied...........".

I did almost whole day study from goole, cannot get any help.
Can anybody tell me in details about the following two questiong:
1: What else needed to create a job, except SQLAgentUserRole permission, any setting in system, master, msdb.....

2: From where I can add my source codes to the job?

Thanks!

Andraw

 
Old July 16th, 2008, 11:21 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 108
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Excuse me, why nobody can answer my question??????????

 
Old July 16th, 2008, 11:33 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 108
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello, is somebody there?
I have a text file inside it each row has 65 data delimited by tab, there is no array and split function in stored procedure, what is the best way to parse this file?


 
Old July 20th, 2008, 05:48 PM
Registered User
 
Join Date: Jul 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

haha...guess no one familiar wid ur question...if u giv me somtime i will answer...gud luck..am readin this stuff now..i am gud wid oracle..

mohammed





Similar Threads
Thread Thread Starter Forum Replies Last Post
reg conn to sql server 2005 from vb.net 2005.. veda SQL Server 2005 2 July 1st, 2008 12:16 AM
Conflict in SQL Server 2000 and SQL Server 2005 ayan.mukherjee SQL Language 0 June 30th, 2008 03:34 AM
HELP NEEDED: Trouble Connecting with SQL Server mutinousguy ASP.NET 2.0 Basics 2 September 17th, 2007 01:21 PM
how to create databases using SQL server 2005 jayraj_pune ASP.NET 2.0 Basics 2 March 6th, 2007 02:06 PM
migrating from sql server 2000 to sql server 2005 abinashpatra SQL Server 2005 2 December 1st, 2006 03:45 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.