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 |
|
jonsey_54
Starting Member
8 Posts |
 Posted - 2007-01-05 : 08:11:11
|
| Hi,I am just wondering if anyone could let me know what happens in a SQL Server job step if the "Database" field is left blank?Regardless of whether or not it's blank does it use some sort of database as its default?If anyone could pont me to any material on the web it would be much appreciated.Many Thanks, |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-01-05 : 12:51:47
|
| master will be used by default. You can use three part names in the T-SQL so the database that you specify is just to make it simpler if everything you're doing in the step is always in the same database. |
 |
|
|
|
|
|
Database blank in a SQL Server Job