Launch Enterprise Manager and navigate to Management/SQL Server Agent/Jobs. Right-click in the Jobs window and select 'New Job'. Give the job a name and click on the Steps...

Please explain what Indian time is.

Your error message is not appearing - please add it to your post.

If SQL Server is powering a web app, you cannot buy a licence that refers to CALs and must instead purchase a 'processor' licence.

So you need the standard edition with...

Please post the query that is generating the error and details of how it is submitted - eg are you using a pass-through query in Access?

You may be receiving the...

Try this in Northwind (try varying the table_name in the WHERE clause) and you should be on the right track:

select a.constraint_name, b.column_name from information_schema.table_constraints a

inner join information_schema.constraint_column_usage b

on a.constraint_name =...

I actually think that the JOIN method will execute faster than the subquery I proposed. However, the subquery method is easier IMO to write and I had a hangover...

Hi Karen

This should work:

DELETE FROM [SD_Order_Dev].[dbo].[ProjectDemand]

WHERE

dbo.ProjectDemand.ProjectNumber in

(select ProjNum from dbo.CADFilePath)

Phil

Jack, please do not post the same query on multiple SQLServerCentral forums.

Others, please refer to

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=147644

for original post.

Your application sounds fairly standard in architecture (though what do you mean by 'agent', exactly?). Please be a bit more specific - what issues/problems do you foresee?

Phil

Please post some sample data - both source and how you would like it to look after processing.

If your question is: "Is it better to have a single table with the capacity for multiple addresses in a single row, or one master table linked to an address...

Correct, it doesn't - would be damn useful though.

Your use of CAST is incomplete. Do you mean

cast(b.begindate as datetime) perhaps?

Phil

Are you suggesting that you will need to store long strings of narrative? Will you need to perform any structured analysis on the data, or do you just need...