Forum Replies Created

Viewing 8 posts - 16 through 23 (of 23 total)

  • RE: Need to Shrink data & log file

    Hi,

    log_reuse_wait_desc detemines or givesDescription of reuse of transaction log space is currently waiting on one of the following:

    NOTHING

    CHECKPOINT

    LOG_BACKUP

    Note:

    If the reason is LOG_BACKUP, it may take two backups...

  • RE: disk report

    Hi,

    Stored below code in .VBS file & run file

    You can change parameter (Disk.FreeSpace/Disk.Size) < 0.30 in script

    Set DiskSet = GetObject("winmgmts:{impersonationLevel=impersonate}").ExecQuery("select FreeSpace,Size,Name from Win32_LogicalDisk where DriveType=3")

    for each Disk in...

  • RE: can anybody list the services created after installing SQL 2000 & SQL 2005

    Hi,

    MSSQLSERVER & SQL Server Agent both main services were created after installation of database engine. for more info refer book online....

    Rd,

    Deepali

  • RE: display permissions with database name

    Try Below Query..

    sp_msforeachdb @command1= "select '?' as Databasename EXEC ?.dbo.sp_helprolemember db_owner"

    Rd,

    Deepali

  • RE: Log file is full

    Hi,

    To resolve the problem backup your database;

    Backup log database with truncate_only

    this will truncate the non active logs from your log file then try to shrink your database Log...

  • RE: SSRS - Print Button & MS Security Update ??

    This problem is due to printing a report generated by SQL Server Reporting Services directly from the browser requires a control names RSClientPrint.

    SQL Server Reporting Services has this control in...

  • RE: SQL server on AMD/Intel?

    Hi Gift ,

    Thanks alot for your reply.

    Regards,

    Deepali

  • RE: what is "suspended" status of processes in sql server 2005?

    Thanks a lot, Michael.

    After executing sp_who2,

    one of my system process shows status like this,

    spid:9 status:SUSPENDED sa master CHECKPOINT...

Viewing 8 posts - 16 through 23 (of 23 total)