Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    34

    Unhappy Unanswered: CREATE FUNCTION owner_name

    Hi,

    I have a problem with a function I am creating. I am working on a project for Uni. I coded all my SQL on my home computer, but now I have transferred it all to the schools system and I have a problem with the permissions on the schools SQL Server.

    On my home computer I created

    CREATE FUNCTION GetDateOnly

    It automatically gave it the 'dbo' owner_name which worked fine at home, but on the Uni computers it says I dont have permission to execute it. The owner of all my other Procedures, tables etc. is SCMS/ral6 when I create them at school, which is also the owner_name of my function if I create it at school, but...

    If I try and run a function like this:

    SCMS/ral6.GetDateOnly()

    It does not like the '/'

    Nor does it work if I leave that part of, and just go:

    ral6.GetDateOnly()

    Does anyone know how I can run this? The Uni is not likely to change there whole permissions to run my one project, but without this FUNCTION, my project will not work.

    Thanks

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    try [SCMS/ral6].GetDateOnly()

  3. #3
    Join Date
    Sep 2003
    Posts
    34
    Cheers for that, I think you just saved my life

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •