Viewing 15 posts - 7,006 through 7,020 (of 9,241 total)
yes quite right, can see the SP code offering hour minutes or seconds.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 9:00 am
🙂
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 8:56 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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 8:37 am
winston Smith (7/4/2011)
The restore job runs every 25 seconds.
Hmm, Hours or Minutes are the only frequency options for a job schedule!!!
can you post details of the backup, copy and restore...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 8:35 am
you're welcome!
I'm not entirely sure it's possible to find how long the restore took, if i find it I'll let you know
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 8:29 am
You're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 6:32 am
muthukkumaran Kaliyamoorthy (7/4/2011)
DMV will not work against the compatibility 80.
It can and will, see Paul Randall's article at the following link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 5:37 am
The Backup Exec SQL agent is especially useful for customers who wish to enable backup management within one product and not have to go configuring multiple jobs or plans, etc....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 5:33 am
System Centre Operations Manager?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 5:22 am
I concur, Michelle's script is awesome.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 5:18 am
i haven't mentioned Exchange server, i pointed the OP to Books Online to gain information on how to enable and configure Database Mail on a SQL Server instance 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 5:16 am
don't give out SA privileges 😀
I ask them to explain why they need SA, when they can't give a valid reason i use that as my push back 😉
It's...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 4, 2011 at 5:10 am
Viewing 15 posts - 7,006 through 7,020 (of 9,241 total)