I know changed my package to a Execute SQL Task and removed the cursor out completely and included just the SQL query to pull the data out. I am using...

The issue here is I need to run this package on every individual database and need to have the output appended to the same recordset destination for each individual database...

Do SSIS packages support cursors??

ok..thanks

Thanks for the script. I am thinking that the index was created around november 8th,2011. And they were atleast 2 sqlserver service restarts from then and also the server got...

I agree with Jeff

If an index has been added recently then you can try to get creation date from the default trace file otherwise there is no way you can do it unless...

Thanks Mat...You were right

I have verified that my database is in multi user mode.

but all what happened today was:

http://www.sqlservercentral.com/Forums/Topic1224426-391-1.aspx

I havent heard any slowness from developers initially. But now I am getting calls.

Currently the...

update: There was an auto restart this morning and I dint see any errors after that successful auto restart

But a couple of weeks back I had my SAN Admin carve...

Thanks Alzdba.

ALZDBA,

I am new to powershell. May I know what this statement does please. Thanks a bunch.

o..ok. The file shdnt grow bigger than 10 Mb, currently its at 388kb and it doesnt append to previously exisiting data as I am clearing the text file at the...

This is my code:

if((Get-Content "c:\scripts\appevents.txt") -eq $Null)

{

Send-MailMessage -To<> -From <> -Subject " " -body "There are no Errors or Warnings" -SmtpServer <>

}

else

{

Send-MailMessage -To <> -From <> -Subject "" -Attachments "c:\scripts\appevents.txt"...

🙂