Forum Replies Created

Viewing 15 posts - 466 through 480 (of 1,136 total)

  • RE: SQL Server Job Status

    tusharbedekar (9/30/2009)

    I want to display status of SQL server jobs with last run date and time, in one of my application. But I am not having administrative privileges for database....

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    September 30, 2009 at 6:39 am

    #1059909

  • RE: Doing both Differential and Transaction Log Backups (regularly)?

    Fred Zimmerman (9/30/2009)

    My environment (coming in with it set) for SQL Server 2005 dictates that I have the multiple back-end SharePoint databases set to FULL recovery mode (not Simple).

    This being...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    September 30, 2009 at 6:30 am

    #1059906

  • RE: SQL Server Job Status

    What rights do you have?

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    September 30, 2009 at 6:09 am

    #1059897

  • RE: How to show the duration of SPs called from master SP

    I have heard that UDF's; while not technically stored procedures will get traced with the statement level events, such as SP:StmtStarting

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    September 30, 2009 at 1:35 am

    #1059833

  • RE: Monitoring a Table/ Log for a table

    http://www.databasejournal.com/features/mssql/article.php/3720361/Microsoft-SQL-Server-2008----Change-Data-Capture--Part-I.htm

    This is one of the new features in sql 2008, you also have more advanced auditing functionality as well.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    September 30, 2009 at 1:28 am

    #1059831

  • RE: Running DOS Command Prompt(cmd) command thought SSMS

    naveenreddy.84 (9/30/2009)

    Hi,

    I am using a xp_cmdshell method of running command and i used the following tsql statement

    exec xp_cmdshell 'bop_cmd'

    but it gives following error

    'bop_cmd' is not recognized as...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    September 30, 2009 at 1:26 am

    #1059830

  • RE: Nested Case statement

    pitso.maceke (9/30/2009)

    The problem with my query is that the AND on the case statement seems not to be working as supposed, most of the example that I saw does not...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    September 30, 2009 at 1:21 am

    #1059827

  • RE: Monitoring a Table/ Log for a table

    The solutions mentioned will help in most scenarios, it is totally different and a lot easier in sql 2008, as changes can be tracked.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    September 30, 2009 at 1:03 am

    #1059819

  • RE: Changing Flat file destination doesn't change

    smthembu (9/30/2009)

    Hi All

    I have a package with the flat file destination set to c:\ drive now i need to change the file destination to another drive but after i have...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    September 30, 2009 at 12:52 am

    #1059813

  • RE: Reports in Firefox browser issue(Design and Print button issue)

    This link will help you around the issues

    http://forums.asp.net/p/1135437/1940011.aspx#1940011

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    September 30, 2009 at 12:49 am

    #1059811

  • RE: Running out of space on E drive

    Steve Jones - Editor (9/29/2009)

    Open Source != free. It means that someone is allowing you to see how the code works.

    Lots of these little utilities are written by someone that...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    September 29, 2009 at 10:27 am

    #1059595

  • RE: Running out of space on E drive

    TheSQLGuru (9/29/2009)

    Silverfox (9/29/2009)

    TheSQLGuru (9/29/2009)

    Free download for evaluation doesn't make it a free product. If people would actually pay for products they use I think we would all benefit because...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    September 29, 2009 at 10:23 am

    #1059589

  • RE: DBA Objectives For Apriasal

    RTaylor2208 (9/29/2009)

    Hi,

    I have been asked to define my own objectives for my yearly appraisal and to be honest I am not entirely sure where to start as I have never...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    September 29, 2009 at 10:01 am

    #1059578

  • RE: Running out of space on E drive

    TheSQLGuru (9/29/2009)

    Free download for evaluation doesn't make it a free product. If people would actually pay for products they use I think we would all benefit because developers would...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    September 29, 2009 at 9:48 am

    #1059567

  • RE: Running out of space on E drive

    TheSQLGuru (9/29/2009)

    Buy FolderInfo and use it to quickly spot space consumers on the drive of concern. Very useful utility I have been using for a LONG time.

    Also, instead of...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    September 29, 2009 at 8:11 am

    #1059490

Viewing 15 posts - 466 through 480 (of 1,136 total)