Viewing 15 posts - 226 through 240 (of 360 total)
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 28, 2011 at 2:25 pm
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 28, 2011 at 10:47 am
Do SSIS packages support cursors??
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 28, 2011 at 9:40 am
ok..thanks
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 27, 2011 at 9:43 am
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 22, 2011 at 9:14 am
I agree with Jeff
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 22, 2011 at 9:05 am
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 21, 2011 at 7:00 pm
Thanks Mat...You were right
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 20, 2011 at 9:48 am
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 20, 2011 at 9:21 am
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 20, 2011 at 7:51 am
Thanks Alzdba.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 16, 2011 at 2:14 pm
ALZDBA,
I am new to powershell. May I know what this statement does please. Thanks a bunch.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 16, 2011 at 1:46 pm
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...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 16, 2011 at 1:18 pm
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"...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 16, 2011 at 12:53 pm
🙂
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
December 16, 2011 at 12:29 pm
Viewing 15 posts - 226 through 240 (of 360 total)