Forum Replies Created

Viewing 15 posts - 166 through 180 (of 1,109 total)

  • RE: Problem calculating a negative variance

    Andy Carroll (7/8/2008)

    A little help required if possible...

    I am trying to create a report that calculates and returns a week-on-week variance both as an integer and as a percentage.

    My query...

    July 8, 2008 at 1:28 am

    #839294

  • RE: Import/Export

    alikhan.mayana (7/7/2008)

    Dear friends

    I want to know the import/export tables from enterprise in SQL Server 2005.

    I know that,we can import/export database but i want to know,

    about tabels ?

    This last message together...

    July 8, 2008 at 1:22 am

    #839292

  • RE: Import/Export

    alikhan.mayana (7/7/2008)

    Dear Friends

    Can anybody tel me How to import/export tables in SQL Server 2005.

    Have a look at the BCP utility http://msdn.microsoft.com/en-us/library/ms162802.aspx

    But there are many different ways to export/import tables....

    July 7, 2008 at 6:29 am

    #838791

  • RE: Bitwise menu problem

    Since you are not requiring that all permission bits should be present when comparing, but only one permission bit is set, you could use:

    SELECT MenuItem, URL

    FROM ...

    July 7, 2008 at 6:28 am

    #838789

  • RE: 2005 equivalent

    Au4848 (7/3/2008)

    Andras the statment fails at 'GRANT ALL' which is deprecated in 2005 so I'm looking what can be used in place ALL

    It is deprecated, but it still seems...

    July 3, 2008 at 9:13 am

    #837934

  • RE: PASS

    karthikeyan (7/3/2008)

    is it a group ? do we need to pay for this group ? Can you explain me the purpose of PASS ?

    Have a look at http://www.sqlpass.org/

    Regards,

    Andras

    July 3, 2008 at 8:21 am

    #837890

  • RE: 2005 equivalent

    Au4848 (7/3/2008)

    Hi all,

    Below statement works fine in 2000 what is equivalent in 2005?

    SET Grant = 'GRANT ALL PRIVILEGES ON /* ' + @object_type + ' */ ' + @owner_name...

    July 3, 2008 at 8:20 am

    #837887

  • RE: Generating database dynamically

    sreerekhavs (7/2/2008)

    I have to generate an online survey tool. Using this system we can generate surveys dynamically.

    The system may have, say hundred of surveys and related data within it.

    Our...

    July 3, 2008 at 1:38 am

    #837644

  • RE: dynamic database generation

    sreerekhavs (7/3/2008)

    I have to generate an online survey tool. Using this system we can generate surveys dynamically.

    The system may have, say hundred of surveys and related data within it.

    Our...

    July 3, 2008 at 1:37 am

    #837643

  • RE: Session ID

    sudhakara (7/2/2008)

    Sql server data base generating session id in negative value like -1,-2 .could you explain ?

    Orphaned transactions get a session id of -2. Most common reason is DTC....

    July 3, 2008 at 1:32 am

    #837639

  • RE: Check for Existence before delete (Set Based Delete)

    First a question, do you have an index for the day column? If you do, then my suggestion would be to go with the direct delete.

    Also, is the delete done...

    July 3, 2008 at 1:21 am

    #837634

  • RE: Create logins script

    Imke Cronje (7/2/2008)

    Thanks..i already know that....i have always done it manually...i ran the script below and it basically solved the problem:

    sp_change_users_login

    If you are familiar with the UI already, you...

    July 2, 2008 at 8:17 am

    #837262

  • RE: Create logins script

    Imke Cronje (7/2/2008)

    it worked the first time when I used it...i deleted the user, recreated the user again, when I execute the command it says "Command Completed Successfully" but it...

    July 2, 2008 at 7:00 am

    #837189

  • RE: Create logins script

    Imke Cronje (7/2/2008)

    Thanks...just one problem....The script below doesn't work:

    EXEC sp_addrolemember N'db_owner', N'TestUser'

    I will keep looking.

    Could you tell me how it does not work? I.e. is there an error message? If...

    July 2, 2008 at 6:31 am

    #837160

  • RE: Create logins script

    You can, on 2005 try something along the lines of:

    USE particularDatabase

    GO

    CREATE USER TestUser FOR LOGIN [TestUser]

    GO

    EXEC sp_addrolemember N'db_owner', N'TestUser'

    GO

    Regards,

    Andras

    July 2, 2008 at 2:48 am

    #837052

Viewing 15 posts - 166 through 180 (of 1,109 total)