Forum Replies Created

Viewing 15 posts - 1,141 through 1,155 (of 1,518 total)

  • RE: How do I enable SQL 2005 instance (SE) to access 3 GB of VAS memory?

    MohammedU (6/2/2008)

    Here is the MS article...

    How to configure SQL Server to use more than 2 GB of physical memory

    http://support.microsoft.com/kb/274750

    Thanks, but that link does not apply in my case (I have...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    June 2, 2008 at 12:41 pm

    #823199

  • RE: Linked Server using Windows Authentication

    My 0.2 cents on this:

    If you are starting off connecting through SQL auth, save yourself the heartache and go with it all the way.

    Setting up Windows auth double-hop/chaining is not...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 30, 2008 at 3:28 pm

    #822573

  • RE: DOS commands for stopping SQL services remotely and in sequence

    Thanks Matt, all you are saying makes a lot of sense.

    I'd also rather leverage the .NET framework.

    I'll give it a try...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 30, 2008 at 10:15 am

    #822445

  • RE: DOS commands for stopping SQL services remotely and in sequence

    Thanks guys for your suggestions, I will have a look at the info provided.

    Matt, I was thinking of creating a .NET console app, but I'm not sure all machines of...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 30, 2008 at 8:55 am

    #822374

  • RE: Database Missing

    Mani raises very good points.

    Auditing is a must in a prod environment, as is removing BUILTIN\ADMINS from a prod instance.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 30, 2008 at 7:59 am

    #822326

  • RE: DOS commands for stopping SQL services remotely and in sequence

    SQL ORACLE (5/29/2008)

    You may try the following DOS command. But you have to make them workable on a remote server.

    at 6:30pm /EVERY:Monday,Tuesday,Wednesday,Thursday,Friday,Sunday "c:\stop.bat"

    at 6:30pm /EVERY:Monday,Tuesday,Wednesday,Thursday,Friday,Sunday "c:\start.bat"

    Where stop.bat

    net start mssqlserver

    start.bat

    net stop...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 30, 2008 at 7:35 am

    #822310

  • RE: Use SQLCMD to check whether any jobs running, then stop SQL Agent service

    I managed to resolve this the following way.

    main.bat:

    sqlcmd -S srvr\instance -i D:\checkJobsRunning.sql

    sqlcmd -S srvr\instance -i D:\stopAgent.bat

    checkJobsRunning.sql:

    SET NOCOUNT ON

    CREATE TABLE #JobStatus

    (

    job_id uniqueidentifier,

    LastRunDate int,

    LastRunTime int,

    NextRunDate int,

    NextRunTime int,

    NextRunSchedule int,

    RequestedToRunint,

    Request_Source int,

    Request_Source_ID varchar(100),

    Running int,

    CurrentStep int,

    CurrentRetryAttempt...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 29, 2008 at 2:41 pm

    #822007

  • RE: Finding un-used indexes

    There is no such thing for SQL 2000 unfortunately.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 29, 2008 at 12:18 pm

    #821925

  • RE: Use SQLCMD to check whether any jobs running, then stop SQL Agent service

    Steve Jones - Editor (5/29/2008)

    I think you'd implement this as T-SQL logic, a stored proc perhaps, and then call that from SQLCMD.

    I'm almost there, but I'm stuck trying to pass...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 29, 2008 at 11:18 am

    #821883

  • RE: Database Missing

    Ola Hallengren (5/29/2008)

    If you drop a database it is captured in the default trace.

    Look in the trc - files that are located in the same directory as the error logs.

    Ola...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 29, 2008 at 10:33 am

    #821859

  • RE: SQLCMD error - Unable to connect to instance using sqlcmd -i option

    Steve Jones - Editor (5/29/2008)

    Is this a remote or local connection? You might need to set the user and password or perhaps the trusted connection switch in your command or...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 29, 2008 at 8:17 am

    #821777

  • RE: SQLCMD error - Unable to connect to instance using sqlcmd -i option

    I think I got it. I have to connect to an instance from the cmd line and THEN reconnect with the :CONNECT directive.

    Like this:

    On cmd prompt:

    sqlcmd -S srvr1\instance1 -i "test.sql"

    test.sql...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 29, 2008 at 8:11 am

    #821770

  • RE: Database Missing

    Ratheesh.K.Nair (5/29/2008)

    I have error log ..Is that helpful.Can i find who deleted the database and when???

    Start with who currently has db_owner/sysadmin permissions.

    Hopefully not too many people...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 29, 2008 at 7:42 am

    #821751

  • RE: Sql Mail Problem

    In SSMS, right-click on the Database Mail node under Management, and pick View Database Mail Log.

    This will give you a list of recent activity along with possible errors.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 29, 2008 at 7:27 am

    #821740

  • RE: Database Missing

    Ratheesh.K.Nair (5/29/2008)

    Hi Experts,

    Is there any way to know about a database which...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    May 29, 2008 at 7:24 am

    #821737

Viewing 15 posts - 1,141 through 1,155 (of 1,518 total)