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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-10 : 08:11:20
|
| Cindy writes "Greetings Everyone,I am new to SQLSERVER and need some help from you guys1) I have created a DTS Package contains SQLTask and ActiveXscript task.The Sqltask contains the Query:IF (SELECT COUNT(*) FROM tblTempSMS) >= 0 BEGIN .. END I want to execute the ActivexScript task only if the count in the Query is greater than Zero?2)I am performing a daily differential backup.Is there anyway i can include the date&time in the Backup Filename?for ex: xxxprod_240709_1203.bakAny help is much appreciated.ThanksCindy" |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-06-10 : 19:48:20
|
| Please don't post multiples....http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=35982 |
 |
|
|
|
|
|
DTS problem