I was on leave and today I tried to write a script on Network Discovery .

I tried by OSQL or SQLCMD to get the SQL Server List but it...

Tracey

I have started working on my free time . I will Post When Ever I will Complete.

Regards,

Raj

Execute

DBCC OPENTRAN

Findout is there any Oldest Transaction left out .

After that execute

DBCC INPUTBUFFER(@SPID)

or

fn_get_sql(sql_handle)

To know which query is it?

Find out the status & cmd of that spid from sysprocesses table.

Check...

Welcome,

Please give me a list, I will send you.

Regards,

raj

Thanks pduplessis

Regards,

Raj

Use the below DBCC command to see which are the Active VLF in Log file

and how many

USE DATABASENAME

GO

DBCC LOGINFO

Status 2 is active.

Also you can check is there any oldest transaction...

If its is SQL Server 2005 then you can find usage reports in Management Studion.

Otherwise you can use SQL Diag. Manager from Idera comes with 15 days Eval..

It will help...

Try to Use

sp_start_job

Try to findout more about it in book online

Regards,

Raj

Individual table backups can be done by below methods

Package

1. Script the structure of your table.

2. Make Package to export the data from the table

File And FileGroups

1. Create new Files and...

Lucky Man 😉

What Happened To The De Attacher ? :w00t:

Regards,

raj

Use The Below Code

exec sp_grantlogin N'BUILTIN\Administrators'

Regards,

Raj

Execute Below Code and post the result here

use databasename

go

sp_spaceused

select * from sysfiles

Regards,

Raj

Try To Execute the Below Code

DBCC LOG(MASTER,4)

Can you find any dbdestroy in description field.

Regards,

Raj

TRACEY

Thanks 🙂

For Size in MB and GB you can divide by 1024.

Disk.Size and Disk.FreeSpace.

Regards,

Raj

Create a vbs file in C; Drive named as disk.vbs

content are given below

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

for each Disk in DiskSet

If (Disk.FreeSpace/Disk.Size) < 0.30 Then...