Viewing 15 posts - 7,006 through 7,020 (of 9,253 total)
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...
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...
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:
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...
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
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)
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
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...
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??
July 4, 2011 at 9:37 am
yes quite right, can see the SP code offering hour minutes or seconds.
July 4, 2011 at 9:34 am
when adding the SMTP account what authentication did you use?
Windows
Basic
Anonymous
Have you verified the SMTP server address is correct?
What profile security did you select?
July 4, 2011 at 9:29 am
and don't be tempted to hold the power button for 4 seconds neither, it'll take just as long otherwise when you restart 😉
July 4, 2011 at 9:00 am
GilaMonster (7/4/2011)
The DBA exams do cover the DMVs, especially the session-related ones. Hence if you passed that exam you should know these DMVs.
The same thought occurred to me instantly upon...
July 4, 2011 at 8:52 am
winston Smith (7/4/2011)
all instances on my own personal machine.
so, standalone then.
what user account do the sql server services run under?
What ACLs have you applied to the NTFS permissions and the...
July 4, 2011 at 8:37 am
Viewing 15 posts - 7,006 through 7,020 (of 9,253 total)