I dont get any info from ' Select * from sys.master_files '.

Help please!

I need Available Free Space on of .mdf, .ndf, .ldf on whole instance addinf to existing script.

Thnaks XMLSQLNinja

Can we add 'Available Free Space of .mdf, .ndf, .ldf' to existing script

Your help is greatly appreciated!

Thanks SQLRNNR

But I was not able to get the right info Size, Can I have it in MB display.

Logical Name,

Physical_location,

DataSize,

DBGrowth,

DB Max,

LogSize,

LogGrowth,

Log Max.

Thanks clayman

Thanks surma,

But I cant get the Database size info, form the statement [select * from sys.databases]

I need database name, DB size & recovery model in single statement.

Thanks...

Thanks Perry Whittle & Anthony

Perry: How do I reset NTFS ACLs?

Anthony: how did you fix your issue?

I had admin access on the server,

I can copy backup files and delete them to that on the drive folder where I wanted to copy the .mdf file using...

I have tried everying thing, But it is not wokring.

Searching the following servers for: Jobs that run SSIS packages

Each job should have the owner as SA

Each job step calling...

Thanks Mark,

When I Run the script, In result pannel, nothing is coming up.

We have few SSIS packages on SA and orther Logins, I need to know which Jobs...

Thanks for the quick replay,

But there are 1 million rows in the table, adding DEFAULT value is a best pratice.

Is there any alternative solutions possiable?

How to modify the above script for creating index online.

@ Grant Fritchey

Thanks for the reply.

For sure the SQL Queries are slow. How do I start over and troubleshoot.

@ Syed Jahanzaib Bin hassan

Thanks for your replay, It is some what helpful,

there is no chance of increasing the memory on the server.

drive Totalsize

C ...

@ croberts

Thanks For your replay

When I run the query it gives:

scheduler_idcurrent_tasks_countrunnable_tasks_count

0 14 ...