Forum Replies Created

Viewing 15 posts - 121 through 135 (of 140 total)

  • RE: Database owners

    This will show you the owner of any databases

    select

    name, suser_sname(sid) [User]

    from

    ...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    August 10, 2006 at 2:16 am

    #654216

  • RE: MS Access & Excel installed on DEV server

    But what happens when it's time to move the solution into Production?  Unless you allow Access and Excel (and whatever else they end up wanting on the DEV box) onto the...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    June 13, 2006 at 3:21 am

    #643307

  • RE: Data Reader and View Creator

    The syntax would be:

    GRANT CREATE  FUNCTION TO <user>

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    June 1, 2006 at 8:57 am

    #641207

  • RE: Data Reader and View Creator

    Using Query Analyser

    GRANT CREATE VIEW TO <user>

    GRANT SELECT ON <table> TO <user>

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    May 31, 2006 at 3:50 am

    #640855

  • RE: Seucring MSDE

    Deny Builtin/Administrators access

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    May 16, 2006 at 5:05 am

    #638101

  • RE: Replacing machine name in where clause in SQL 2000

    Build a sql string and execute.

    DECLARE

    @SQLString varchar(1000)

    DECLARE @S2 nvarchar(1000)

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    May 3, 2006 at 4:08 am

    #635527

  • RE: SQLServer 2000 Scheduled Job recurring every second

    You might want to search the forum for SQL Server Job Scheduling.  I remember someone posting about setting a schdule to run at fractions of a minute (editing a value in...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    April 28, 2006 at 3:34 am

    #634770

  • RE: Install of SQL server on Windows XP operating System

    You can't. You can only install the client tools or MSDE on XP.

    To install an actual server instance you need a "proper" server O/S (Win 2000/2003 server editions)

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    April 25, 2006 at 4:14 am

    #633957

  • RE: select top 10 * from table Takes long time to run

    Since NOLOCK does not apply any locks the time saved is from the Lock acquired, Lock released.  It does run the risk of dirty reads if there are any transactions...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    April 20, 2006 at 4:17 am

    #633207

  • RE: How was this table populated??

    If it is a fact table then it's most likely,  as Allen originally suggested, to be populated via a DTS package.

    Also if the db has been copied onto the test server...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    March 16, 2006 at 3:18 am

    #626966

  • RE: Complicated Sub / Sums Query

    All the syntax errors go away once you remove the comma after

    GROUP BY dd.CustomerNumber,

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    March 1, 2006 at 7:37 am

    #623964

  • RE: DTS Package failure

    Permissions are the usual suspect. 

    When the job is run manually it runs with that users privileges on.  When it is run as a job it runs with the privileges of the...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    January 5, 2006 at 4:06 am

    #612830

  • RE: ActiveX job step in SQL Server Agent

    If you don't want your job to report a failure then you will need to remove the

    Main = DTSTaskExecResult_Failure

    You might want to create an empty (null) file and have the DTS...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    December 22, 2005 at 3:20 am

    #611063

  • RE: Problem using the Copy SQL Server Objects Task in DTS Package

    Theare the files that must have matching versions

    %SystemRoot%\system32\sqlsrv32.dll

    %SystemRoot%\system32\sqlsrv32.rll

    %SystemRoot%\system32\odbcbcp.dll

    There is a free Microsoft tool that can be used to check versions.  Below is the link.

    http://www.microsoft.com/downloads/details.aspx?FamilyID=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    December 12, 2005 at 1:34 am

    #608945

  • RE: SQL Server on a Virtual Server

    Oh b####r.  That's the path our It department is heading...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

    December 9, 2005 at 3:19 am

    #608600

Viewing 15 posts - 121 through 135 (of 140 total)