If that's not a linked server issue, you might indeed be better off posting this here:

http://www.dbforums.com/f6

There shouldn't be a big difference between both methods. I only mentioned it because in most case you see someone coming up with cast and convert stuff between varchar and...

Definitely a 'No'.

Technically you can create triggers on certain tables in MSDB, but that's all. Do a search here. This has been discussed several times before.

Maybe you should tighten your permissions....

create view dbo.foobar

as

select top 100 percent * from authors order by au_lname

go

select * from dbo.foobar

drop view dbo.foobar

You're welcome!

Glad I could help.

Hm, sorry, I have no experience with MSDE. Would this be an alternative?

http://www.sqldev.net/xp/xpsmtp.htm

Both procedures are located in the master database. Did you already search there?

By any chance, did you change the underlying table structure? If so, you might want to read about sp_refreshview in BOL.

This one uses fast and efficient Integer operations, so it should give good performance:

SELECT

 DATEADD(MONTH,DATEDIFF(MONTH,30,GETDATE()),30)

A very cool script for lazycoders comes from SQL Server MVP Steve Kass. Try...

May I ask, why you keep the file in an image column AND on the filesystem? Or do you need this to determine if the file was updated? Anyway, here's...

Sorry, I don't use DTS, but http://www.sqldts.com is a frequently referenced source for such questions. Maybe you find something there.

Hm, if you use Windows Authentication only, why not delegate this task to the OS password policy?

But only if I use 'WITH TIES'?!

No, sorry if I confused you. Forget the WITH TIES in your case. It is redundant.

As for making it dynamic:

See http://www.sommarskog.se/dynamic_sql.html and http://www.sommarskog.se/dyn-search.html for...