datediff(dd,getdate(),getdate()) IS ALWAYS 0 and therefore LESS THEN 1

What is the purpose of doing that?

Hmm...I still don't understand what you want?

This code is what I believe you're asking for:

select 21 / (datediff(dd,getdate(),getdate()) + 1)

But you could just as easily replace (datediff(dd,getdate(),getdate()) + 1) by...

What do you mean? Output of 21?

In your code there's a ")" missing. Like this:

select 21/(datediff(dd,getdate(),getdate()))

But it's no good anyway.

This code will give you 21 as output but I'm quite...

Clear. Thanks for your explanation. I'm always having difficulties with semantics :unsure:

I'll be the fourth then 😛

Perhaps you're looking for this?

I'm having the same problem as leoR. Even when I enter a perfectly valid object name the procedure returns...

Create a new job in SQL Server Agent.

To tell the job to execute your stored procedure:

Add a new step. Give it a name like 'Step 1: delete data from myTable'....

Create a stored procedure which deletes the data you wish to delete.

Next create a job which executes the stored procedure. You can schedule the job to run once a week,...

Have you tried moving your scripts to your harddrive (I mean locally stored versus networkshare)? Perhaps the networkshare is the problem (virusscanner scanning the share?)...

I'm just guessing 😎

Well I receive the same message, but that's when I actually do edit the script outside of SSMS.

Are you sure the scripts aren't opened / used in some way? Perhaps...

I don't know if I completely understand what you're asking for but perhaps you are interested in database mirroring. CLICK

Take a look at the high-safety mode with automatic failover...

Here are some suggestions:

CLICK

Ever heard of search engines? ;)[/url]

Is guess you're using MSSQL2000...

Try this one (it's a rewrite of Abhijit's code which was written for MSSQL2005):

select object_name(id), * from sysobjects where object_name(id) like 'sys%' and type = 'U'