Do the packages run if you execute them manually in the new instance?  Is the account that SQL Server Agent runs under the same as on the old instance?  Do...

I believe those are entries for tables that contain text or image data.

Greg

This is why I always use server names when using the wizard, never (local).

Greg

When I need to make a lot of changes to a job, I script it into an edit file, make the changes then recreate the job.  To script the job,...

If you open some of the stored procedures you'll notice they mention Visual SourceSafe.  I think they're created when Visual Studio is used to create database objects.  You can remove...

If you're trying to work on an object that you do not own, you must qualify the object name with the owner.  It doesn't matter how many objects with that...

I can't explain it better than Ewan did.  You just have to remember that the group is a Windows entity, not a SQL Server entity.  You'd have to know your...

1.  Are you making this change in Enterprise Manager?  If so, it takes a long time because EM will create a new table with the new column datatype, insert the...

You've almost got it, Lee.  A member of a group with access to the server and database WILL be able to connect without having an individual login in SQL Server. ...

If you're referring to the change in U.S. DST in 2007, SQL Server doesn't appear to need a fix.  See this editorial: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=263&messageid=331667

Windows, however needs a patch: http://support.microsoft.com/kb/914387/en-us

Greg

Lee,

If you see "via Group Membership" for a user in a database, they are members of a Windows group that has been granted access to the database.  Usually, you won't...

I think you're right, Robert.  I don't have an 7.0 instance, so I can't see for sure.

Greg

Russel,

In your original post, you said the table must be owned by dbo.  That would preclude the user from dropping it without being a member of the DDLAdmin or db_Owner...

My job checker runs every 10 minutes and it's so quick that I haven't noticed any slowdown.  Mine actually decides which of 6 different DTS packages should be run by...

Russel,

I did what you describe in your original post.  The user sets a bit in a table, a scheduled job reads the table and enables and starts a job that...