What is in the job category and what makes you think it wasn't built in SQL Server?

Did you try running it? It will return all the jobs that are scheduled to run on 06/23/2009. Change the date to the 25th and run it...

select j.name, s.next_run_date, s.next_run_time

from dbo.sysjobschedules s join dbo.sysjobs j

on s.job_id = j.job_id

where s.next_run_date = 20090623

As far as I know, you can't do it. You could create multiple diagrams with different groups of tables in each. That could make it easier to find...

mike-g (6/17/2009)

---

I am a novice admin. I have a new instance of sqlserver 2005 installed and I want to begin with a naming convention that is scalable. Admin users have...

There are system tables in msdb that you can query (sysjobhistory, sysjobs) and stored procedures (sp_help_jobhistory), but it's far easier to use the SQL Server Management Studio GUI to look...

Does the user disappear from the database or just the permissions? My guesses would be another admin revoking the permissions or the database being restored to a point in...

Yes. It's very similar to running DTS in SQL 2005.

http://msdn.microsoft.com/en-us/library/bb500440.aspx

The recommended way is to query the catalog view sys.database_principals because sysusers may go away in future releases. I get the same results querying the view or sysusers.

I recommend figuring out your backup and recovery stategy before creating the backups themselves. See BOL http://msdn.microsoft.com/en-us/library/ms191239(SQL.90).aspx

The beauty of configurations is you can use them to update connection managers for different environments at run time so it's easy to move packages from dev to test to...

Jobs and schedules can be enabled or disabled independently, so you can disable the job as Pradeep suggested and leave the schedule untouched. After July 1, just enable the...

Yes, you can edit DTS package in SSMS when you have the DTS designer components installed. Right-click on the package in Management-Legacy-Data Transformation Sevices and select "Open...".

Configuration files are included in Integration Services and are saved as xml code. They store package variable values, connection strings, configuration info for log providers, etc. BOL has...

We've chosen to store packages as files because we can use configuration files and because the packages seem to be easier to move from instance to instance. We also put...