Hi Kushla,

you mean something like

SELECT * FROM Users WHERE id between(7-2) AND (7+2)?

Cheers,

Frank

Hi Roust_m.

do you really have to reinvent the wheel?

That what you are trying to implement can easily be done with a maintenance plan.

Cheers,

Frank

Hi Howard,

it isn't a production server, right?

Cheers,

Frank

hmm,... I haven't done this before, so please consider this only as my thoughts.

I would write down the values for the entry of that db in sysdatabases.

Then delete the...

Is there an entry in sysdatabases in master?

Cheers,

Frank

Hi Howard,

sp_dbremove <db_name> is not working?

Cheers,

Frank

Hi Anabel,

I do a full backup every night with logs backup'd every 1 hour between 7:00 and 20:00.

On the dialog where you define your maintenance plan there are two tabs...

No problem!

I think that's one feature Snitz Forum Software is missing. You can only delete a topic, but not change a topic's category.

Cheers,

Frank

Cross post in different categories?

Cheers,

Frank

Hi pmanisekaran,

EXEC sp_spaceused '<your_table>'.

Is also explained in BOL.

Cheers,

Frank

Hi Brian,

I would prefer questions covering different topics rather than questions on one specific topic. Just like the first test. Maybe some SQL Syntax?

Cheers,

Frank

Hi ngkh,

here is a fix for months <10

set @new_name = datepart(mm,getdate())

if (@new_name < 10)

begin

set @new_name = '0'+ cast(@new_name as varchar(50)) +'_'

end

else

begin

set @new_name = cast(@new_name as varchar(50)) + '_'

end

Not sure if...

Another great site to keep up to date with security issues is http://www.securityfocus.com . They offer also a great variety of mailing lists

Cheers,

Frank

Edited by - a5xo3z1 on 05/26/2003 08:46:14...

Oops,

quote:

---

Check the dependencies with sp_depends before renaing the object.

---

definetely DO this, when you received...

Hi,

a quick and dirty solution could be

declare @new_name varchar(50)

set @new_name = cast(datepart(mm,getdate())as varchar(30)) + '_f_policy'

exec sp_rename 'f_policy', @new_name

Note: This returns a 5_f_policy instead of 05_f_policy. It needs to be...