Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sesohoops3
Starting Member
1 Post |
 Posted - 2011-02-28 : 12:27:09
|
| I am pretty sure but isnt Windows Authentication used by default for SQL Server?When job scheduling from the tools of Enterprise Manager what are the 3 options or ways to do it?what are the 2 extensions associated with an SQL database?(.mdf, and?)and what types of functions return single values in a results pane, and do mathematical functions on en entire column? is it group by, having, truncate, aggregate, or view command. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-02-28 : 13:18:09
|
Pop quiz in class?  quote:
When job scheduling from the tools of Enterprise Manager what are the 3 options or ways to do it?
Trick question, you can't use Enterprise Manager with SQL 2005.quote:
what are the 2 extensions associated with an SQL database?(.mdf, and?)
There are 3 actually, and all are optional, so not much point in mentioning them.quote:
and what types of functions return single values in a results pane, and do mathematical functions on en entire column? is it group by, having, truncate, aggregate, or view command.
It's one of those answers.  I'll leave this unlocked for now, but please do not post exam or homework questions on SQLTeam. We do not answer them. |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2011-03-02 : 09:38:06
|
quote:
Originally posted by robvolk...quote:
When job scheduling from the tools of Enterprise Manager what are the 3 options or ways to do it?
Trick question, you can't use Enterprise Manager with SQL 2005....
Where there's a will, there's a way. Use Enterprise Manager to launch Query Analyzer and then do the needful.CODO ERGO SUM |
|
|
|
|
|
|
|
|
Basic SQL Server 2005 Questions