I would check the default trace first.

Makes sense.. thanks very much for your replies.

Thanks.

I'm aware of this but.. What I'm trying to achieve here is to avoid hard coded paths so that SP would be more generic. For...

try

create database contacts

on primary

(

name='contacts',

filename='D:\contacts\contacts.mdf',

size=5mb,

filegrowth=3%

)

log on

(

name='contacts',

filename='D:\contacts\contacts_log.ldf',

size=5mb,

filegrowth=3%

)

I would look into SSIS and play with the fast load options and the batch size to get an optimal solution. Consider dropping and recreating your indexes on the target...

Good point but with a FK in place the op would have probably gotten an error msg while trying to delete? Anyway I'm a bit confused what he is after...

http://msdn.microsoft.com/en-us/library/ms176057.aspx

Forget the arguments, just simply do

EXEC sp_helpdb

Edit:

Database...

mohan.bndr (6/6/2012)

---

Hi,

I want to know database sizes for all in my environment, and i am executing this query in 2008R2 it is working but when i am using this in...

mohammed moinudheen (5/25/2012)

---

We could configure a job which runs sp_who2 at certain intervals. Periodically review the output file of the job and verify the contents of the file. By this...

There's no way to do that. However you can set up a trace and leave it running for a while to see which objects are accessed.

Firstly, check whether the service is running.

opc.three is correct the PrimaryFilePath won't help much here, apologies.

However doing something like this

$server = "svr"

$sqlserver = new-object “Microsoft.SqlServer.Management.Smo.Server” $server

Invoke-Sqlcmd -Query "SELECT a.name ,

...

Wouldn't this do the same?

$sName = "mysvr"

$dbName = "mydb"

$server = New-Object Microsoft.SqlServer.Management.Smo.Server($sName)

$db = $server.Databases[$dbName]

Get-ChildItem $db.PrimaryFilePath -Recurse | Where-Object{($_.psiscontainer)} | Get-Acl

# ..