Forum Replies Created

Viewing 15 posts - 1 through 15 (of 36 total)

  • RE: SQL code running against Server group names.

    Hi,

    Thanks for your replies. I already use the registration grouping feature to run queries against multiple servers. My query relates to running a command against a registration group...

  • RE: GRANT EXECUTE ON xp_cmdshell

    Great,

    Ok when i change to the user DB and run the helpuser account i get data back. However, when i go to run the following :-

    use USERDB

    GRANT EXECUTE...

  • RE: GRANT EXECUTE ON xp_cmdshell

    Great,

    Ok when i change to the user DB and run the helpuser account i get data back. However, when i go to run the following :-

    use USERDB

    GRANT EXECUTE...

  • RE: GRANT EXECUTE ON xp_cmdshell

    Ahh great.

    The message is :-

    The name supplied (User) is not a user, role, or aliased login.

    Does this help?

  • RE: GRANT EXECUTE ON xp_cmdshell

    Hi,

    Thanks for your advice. I changed the username I'm logged on with and tried again. The message "Cannot find the user 'PostOptApp', because it does not exist or you...

  • RE: Permissions Issue

    Hi,

    I removed said components from the script and remarkbly the process work correctly.

    Many thanks for you help!.

  • RE: Permissions Issue

    Hi,

    Thanks for your reply. To confirm this is SQL 2008.

    The procedure is the same as the first submission, a simple drop and recreation of the date data type....

  • RE: DTS Issues

    Hi Jeff,

    I split out the file into four segments and loaded it into Excel. I could then filter out the formatting characters until I found the row with illegal characters.

    A...

  • RE: DTS Issues

    The issue is now resolved.

    Thankyou all for you assistance.

  • RE: DTS Issues

    Hi,

    Thankyou all for your replies. I have imported the file into a seperate table and have noted the error.

    It would appear that carriage returns are causing the issue,...

  • RE: Columns Deletion

    Adam,

    Thanks for the reply. I need to keep the structure but set all the data in some columns to null whilst leaving the data in other columns

  • RE: Date / Time transactions

    Hi,

    I would like to find the time difference between column B Eg 24/07/2007 17:55 and column A 24/07/2007 14:29.

    Thanks,

  • RE: Date / Time transactions

    Hi,

    Here's the table

    CREATE TABLE

    (

    [SHIFT] [char] (6) COLLATE Latin1_General_BIN NOT NULL CONSTRAINT [DF___OPERATOR__2A90068A] DEFAULT (''),

    [END_DATE] [smalldatetime] NOT NULL CONSTRAINT [DF___END_DATE__23E308FB] DEFAULT ('1900-JAN-01'),

    [END_TIME] [int] NOT NULL CONSTRAINT [DF___END_TIME__24D72D34] DEFAULT ((-1)),

    [OPERATOR]...

  • RE: Concatenating fields

    Spot on .... Thanks.

  • RE: Concatenating fields

    HI,

    They field one is varchar, field two is int.

     

Viewing 15 posts - 1 through 15 (of 36 total)