Couldn't you create a dts package to copy the views to the new database, dropping them first copying the new ones over each time and creating a schedule to run...

Is the restore on the same server or are you restoring to a different server?  If it's the same you probably need to rename the files and/or include the move...

Thanks!  My brain must have fallen asleep as I didn't think of joining the tables that way.

l

When sql 2000 was first released with the xml support microsoft had a download that was available for sql 7.  As far as I know they didn't update the bol. ...

I'm not aware of a way to move the registered servers, but you could write a script using the sp_addserver so that you would just have to run the script...

Doesn't issuing the Checkpoint command do this?

Check out sp_update_job in bol

Thanks for the info.  On one of the machines it was a file path issue that has been corrected.

However on the MSDE when I try to apply the sp the...

Thanks!  I thought it was something like that but wasn't sure.

Thanks, I've seen those but was looking for a little more.  The vendor is creating a series of 5 new tables each month with one filegroup for the table and...

The problem is that they have access through an app that requires certain permissions I'm not allowed to change.  The app has already been purchased (prior to my being in...

If you just stop and restart the SQL services once the profile has been created, SQL will usually recognize the profile and you're all set.  Rarely you might have to...

Try

grant select,insert,update,delete, references on <mytable> to <myuser>

L