And you can do this by using T-SQL:

USE [msdb]

GO

EXEC msdb.dbo.sp_detach_schedule @job_name=N'name of the job', @schedule_name='name of schedule', @delete_unused_schedule=1

GO

Unfortunate I was one of the 45% answering...

small typo in the code from Jeff Moden...

SELECT * FROM dbo.mytable WHERE CHARINDEX(@FirstName,FirstName) + 0

should be

SELECT * FROM dbo.mytable WHERE CHARINDEX(@FirstName,FirstName) > 0

:hehe:

Thanks Lowel and Chris,

Your ideas point me to some new thoughts. I think it must be possible to transfer DDL from system tabels to a central location. By joining these...

Thanks Grant,

I will look into scripting Redgate SQL Compare. I was hoping someone knew a tool that has this function built-in. That would save me quite some work.

But this will...

The most important thing is to ship a product that is working 100% correct. If not all functionality is available, swah, it can be added later. But it is very...

With this code you will get a list of all tables with a column name of "DeptNo".

select

sys.tables.name as TableName

, sys.columns.name as ColumnName

, sys.columns.column_id

from

sys.tables

inner join sys.columns

on sys.tables.object_id = sys.columns.object_id

where

sys.columns.name = 'DeptNo'

Using...

Look at the DMV's for index usage.

taken from https://www.sqlservercentral.com/blogs/brian_kelley/archive/2006/06/12/639.aspx

sys.dm_db_missing_index_details

sys.dm_db_missing_index_columns

sys.dm_index_usage_stats

The first two allow us to identify cases when we need an index but one isn't present. If we...

you can also use "Activity monitor" from SSMS

I don't really know what you are asking, but I will try to answer.

To see when a user connects and disconnects from a database and to see what the user...

Do you have more specific error messages? (see LOGs)

Can you manually execute the command when you copy the code from the job to a query window?

Has anything changed 5 days...

SQL 2000 is not compatible with SQL 2005. Connect to the SQL 2005 instance using the SQL 2005 tools.

Are you able to break down the batch into seperate commands? If you run each part seprately, you can see wich part of the batch is causing the failure.

This is...

This error is generated by the...

More info is needed. Can you post the batch code?

Maybe a trace can pinpoint the problem?