Forum Replies Created

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

  • RE: Dynamic Management Views

    I think that the null value refers to the reosurce database....

    http://www.sql-server-performance.com/articles/per/Query_Execution_Statistics_p1.aspx

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

    March 1, 2009 at 3:07 am

    #951578

  • RE: Performance Tuning

    Doug Howk (2/27/2009)

    Probably need to update statistics on the tables involved in the SP.

    statistics are updated when the index are rebuild...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

    March 1, 2009 at 1:37 am

    #951576

  • RE: Timeout error

    balbirsinghsodhi (2/28/2009)

    All of a sudden all the processes are failing on SQL Server because of the timeout error. It was running fine before but not lot of processes are giving...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

    March 1, 2009 at 12:58 am

    #951575

  • RE: process for deleting extra log/ data file from a database

    deleting one of the data files, ensuring the data is placed in a file not marked for deletion.

    If you want to remove one or more files with in a file...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

    February 21, 2009 at 1:54 pm

    #948216

  • RE: SQL Jobs script

    tnolan (2/20/2009)

    Ahmad, what is the numeric value on this line indicating?

    job.Script 1203765415, sfileName

    here is the definition of script function

    Function Script([ByVal ScriptType As SQLDMO_SCRIPT_TYPE = SQLDMOScript_PrimaryObject], [ByVal ScriptFilePath], [ByVal Script2Type As...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

    February 21, 2009 at 12:51 pm

    #948206

  • RE: How to update multiple users, in multiple columns, and in multiple tables in a database at a time

    cshekhar (2/20/2009)

    Example:

    USERID: 'rex.arnold' must be changed to 'rexarnold' in multiple tables, in multiple columns.

    wherever it looks as 'rex.arnold' must be updated to'rexarnold'

    Sample Query : ...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

    February 20, 2009 at 2:24 am

    #947367

  • RE: Data not commin up in the Front End

    Md Yaqoob (2/19/2009)

    Hi ,

    I have a Sql Server 2000 and .net platform...

    The result in my front application is the result from the view directly.

    The view gives me the...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

    February 20, 2009 at 1:41 am

    #947348

  • RE: Script Application Roles

    MANU (2/19/2009)

    Hi,

    I need to script out database and application roles for databases on one of my server. Can someone provide any such script or tell me whish field stores the...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

    February 20, 2009 at 1:15 am

    #947343

  • RE: Error 3 -(the system cannot find the path specified)

    deba_20032004 (2/19/2009)

    Dear Sir

    I am in a big problem while i am trying to connect sqlserver 2000. It giving a proble which is below :

    An error 3 -(the system cannot find...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

    February 19, 2009 at 2:48 pm

    #947174

  • RE: Restore Script

    klnsuddu (2/18/2009)

    Hi,

    Could you give some simple Restore script. I found some on this forum, but I need some to understand.

    1.to restore full backups to different drives

    2.to restore diff backups

    3.to restore...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

    February 19, 2009 at 2:25 pm

    #947163

  • RE: SQL Jobs script

    pobeda (2/19/2009)

    how to script sql 2000 jobs at once as individual files?

    Can anyone help save me some time? I need to script all jobs on the server as separate files.

    Thanks...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

    February 19, 2009 at 1:59 pm

    #947137

  • RE: Moving TempDB files

    peace2007 (2/17/2009)

    Hi,

    I've moved tempdb files to another drive 2 hours ago (suppose D:\tempdb\..). and when I run exec sp_helpfile, it says that the tempdb files are in the new...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

    February 17, 2009 at 1:02 am

    #945000

  • RE: Any issue using tempdb at SQL Server Compatabilty 90 when some db's are set to 80?

    rmaggio (2/13/2009)

    I have a 2005 environment, where we have some legacy systems moved that require they be set at compatibility 80 (which I believe is sql server 2000 mode). The...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

    February 16, 2009 at 11:49 pm

    #944966

  • RE: Dynamically Creating Indexes

    aravind (2/11/2009)

    Hi

    how do i view transaction logs in sql server?

    Thanks in advance.

    you can use this

    http://www.apexsql.com/sql_tools_log.asp

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

    February 16, 2009 at 9:30 pm

    #944931

  • RE: Backup Process

    shri_sastry (2/16/2009)

    Thanks

    but I did not know how take the monthly backup.

    Thanks

    Shri

    you can schedule a job for monthly backup..there are lots of scripts on this site

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

    February 16, 2009 at 11:45 am

    #944756

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