Viewing 15 posts - 6,991 through 7,005 (of 9,241 total)
are you able to send a test email with no attachment?
Execute the following and post the full results, not just a subset
EXECUTE msdb.dbo.sysmail_help_account_sp
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2011 at 10:34 am
GilaMonster (7/5/2011)
but it usually won't have time if windows is shutting down.
😀 especially if some monkey pulls the plug or holds the power button in for 4 secs 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2011 at 5:51 am
on a high traffic database how many transactions could take place in the space of a minute or even five minutes??
Have you ever wondered why when you shut down SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2011 at 5:37 am
Jayanth_Kurup (7/5/2011)
drop the indexes on the tables and run shrink database..........................then go ahead and perform your backup and restore followed by re creating all the indexes.
Please tell me you are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2011 at 5:31 am
Jayanth_Kurup (7/5/2011)
Also, i wasn't able to find...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2011 at 4:17 am
A faster shutdown, but a sloooooooooow startup 🙂
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 5, 2011 at 12:08 am
Syed Jahanzaib Bin hassan (7/4/2011)
SYS.DM_EXEC_SQL_TEXTthis is not DMV in bold?
Now you're just being pedantic. No, it's a function. The DMV suite is made up of views and functions. Stop trying...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 11:55 pm
This series of tests by Kendal Van Dyke give a better benchmark. It's worth noting that in most cases there isn't really much of a margin. View them and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 2:53 pm
Perry Whittle (7/4/2011)
Coolroof (7/4/2011)
windows authendicationI'm assuming you understand the implications of selecting that option?
can you execute the following on the sql server instance and post the results
EXECUTE msdb.dbo.sysmail_help_account_sp
:Whistling:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 12:02 pm
Jeffrey Williams-493691 (7/4/2011)
Perry Whittle (7/4/2011)
Jeffrey Williams-493691 (7/4/2011)
and it really does depend on how that particular SAN is configured and how the LUNs are carved out.
even right down to the HBA...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 10:23 am
timr-1113026 (7/1/2011)
sometimes you just have to hear someone give their perspective to start the thinking process... 🙂
The following in future may be helpful to trouble shoot these problems
RESTORE FILELISTONLY
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 10:21 am
Jeffrey Williams-493691 (7/4/2011)
Perry, that is exactly the point I was trying to get to - it depends 😉
i agree
Jeffrey Williams-493691 (7/4/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 10:06 am
Coolroof (7/4/2011)
windows authendication
I'm assuming you understand the implications of selecting that option?
can you execute the following on the sql server instance and post the results
EXECUTE msdb.dbo.sysmail_help_account_sp
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 9:58 am
depends on the SAN cache and its config. If it's large enough probably won't make any difference. More importantly check the HBA drivers and config and the LUN config as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 9:47 am
Coolroof (7/4/2011)
how to check SMPT authendication..?
when you ran the wizard it asked you how you want to authenticate to the SMTP server, what did you select??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 9:37 am
Viewing 15 posts - 6,991 through 7,005 (of 9,241 total)