NO.. Because will never allow this operation, it leads to data loss.

Confirm whether your is database is partitioned or not. If database is partition we can empty the file...

do you need to monitor pending commands from distributor to subscriber?

if You need to check article wise pending commands kindly make use of below query , it has to execute...

Below script helps to script sql Jobs

param($sqlserver)

[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.Smo') | Out-Null

$srv = New-Object ('Microsoft.SqlServer.Management.Smo.Server') $sqlserver

$jobs = $srv.JobServer.Jobs

/*

#Scripting execept Maintenance & Logshipping Jobs

$jobs = $srv.JobServer.Jobs | Where-Object {$_.category -notlike "*repl*" -and $_.category -notlike...

Hi ,

Are You enabled Powershell?

Can You share the script in powershell

You May use data collection for instant reports. In this report you can memory, disk i/o, cpu bottlenecks, query statistics, disk usage etc.

Hope it will help..

I need an data for only one time. for eg if you execute the SP multiple times, need an data for first time alone not multiple data.

It has been achieved...

Pls advice to Finish the requirement soon

Requirement is not in trigger

By using below DMV's itself, To achieve i written like this. Can You modify

select distinct @@servername as [servername],dms.host_name, dms.login_name,

CONVERT(varchar(10),dms.login_time,101)as Logintime, dms.nt_domain as [Domain_Name], dms.nt_user_name as[User_Name]...

Pls help Me out

San,

Below requirement

I need tp Create a stored procedure to collect and store these data. The data needs to be populated into the table only if it is first time login...

Receiving an Errror.. Its not working

Which script i Need to check?

In mentioned Blog 3 scripts are available

Not for daily backup's.

Script only for db schema's

Regards,

V.Saranya

its Not working for me