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 |
|
icw
Constraint Violating Yak Guru
378 Posts |
 Posted - 2009-09-30 : 03:07:57
|
| I have a query which I want to run every night on my sql 2000 database.delete from profile where ISNULL(profile.surname, '') = ''I know the answer is to create a DTS package but I can't remember how to do this. Do I need two connections or just one and do i also need a "data transformation task" and how do i join them?Sorry for being daft, I just can't remember this stuff! |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-30 : 03:12:03
|
On the desired server create a new job. In a new job step of typ T-SQL Script you can choose the desired database and type in your delete statement. Then give it schedule. done.No need for a DTS-package.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
sql 2000 run a query every night