Forum Replies Created

Viewing 14 posts - 6,331 through 6,344 (of 6,344 total)

  • RE: Could not obtain exclusive lock on database 'MODEL'. Retry the operation later.

    thats the thing, there are no errors in the event log of sql log, i am totally baffled to this

  • RE: Could not obtain exclusive lock on database 'MODEL'. Retry the operation later.

    database default locations where changed at the time of installation.

    D for data

    F for logs

    G for backups

    we have been stopping and starting the SQL services through out the day and all...

  • RE: SQL 2008 Licensing & Pricing

    The version will have to be enterprise due to the amount of RAM that is being installed into each machine.

    As per proc vs cals we have approx 1000 users who...

  • RE: SQL 2008 Licensing & Pricing

    So I take it this means I will have to buy the following

    SQL 2008 Enterprise 2 Processor Licence for the SQL server

    SQL 2008 Enterprise 2 Processor Licence for the SSIS...

  • RE: SQL 2005 Database Mail

    The issue is now resolved, there was a rule blocking the server from connecting to the exchange server.

    Our exchange servers are set up for SMTP.

    I know the account has an...

  • RE: SQL 2005 Database Mail

    The SQL Server can ping the exhcange server and outlook opens on the server with the same profile and pulls back all emails from the exchange server, so connectivity is...

  • RE: SQL 2005 Database Mail

    Date20/11/2008 13:22:49

    LogDatabase Mail (Database Mail Log)

    Log ID2820

    Process ID7492

    Mail Item ID2701

    Last Modified20/11/2008 13:22:49

    Last Modified Bysa

    Message

    The mail could not be sent to the recipients because of the mail server failure. (Sending Mail...

  • RE: SQL Server Page Size

    Yes I was aware that MS purchased 4.2 off Sybase and rebranded as SQL

  • RE: The Tempermental ODBC Connection

    The server has a static IP and port specific for its own SQL Server. We have a number of web boxes and other servers which hook into the databases.

    It...

  • RE: AWE Memory Options

    The /PAE and /3GB stay in the boot.ini file yes.

    The server still shows 16 in the lowest value for max server memory but the maximum shoots back up to the...

  • RE: AWE Memory Options

    I would of thought that the changes would have to be done to each instance of SQL, with that in mind I would have to change AWE Enabled and Max...

  • RE: AWE Memory Options

    Just on another note also to do with memory, if we where to throw the full 64GB of memory to the server, would we have to increase to 64 bit...

  • RE: AWE Memory Options

    Sorry should of also included that the OS is Win Srv 2003 Ent and SQL is 2005 Ent.

    Thanks

    Anthony

  • RE: Table Constraints

    Guys

    Created a SPROC usp_InsertEpisode to which I will pass values, seems to work, but any tweaks you can think of

    CREATE PROCEDURE usp_InsertEpisode

    (

    @TVShowIDINT,

    @Episode_NameVARCHAR(100),

    @seasonINT,

    @Episode_NumberTINYINT

    )

    AS

    BEGIN

    DECLARE @CurrentSeason INT

    SET @CurrentSeason = ISNULL((

    SELECT Current_Season...

Viewing 14 posts - 6,331 through 6,344 (of 6,344 total)