If these rows make up your entire table, use truncate and you log will not grow.

Truncate will not work if your table is parent table for others.

Otherwise you may want...

- xp_cmdshell needs to be enabled if you want to use it.

SAC or sp_configure will show it.

- If using a param-table to manage sequence numbers, locking will be a big disadvantage.

- with identity columns, that is not the case.

Just keep in mind to only use...

Have a look at http://www.sqlservercentral.com/articles/Advanced+Querying/2871/

With dbmail you should qualify your object 3-part way

select xyz, abc from [db].[schema].[objectname]

- within a table timestamp is unique and is modified every time a row is modified.

- if you want global unique, use uniqueidentifier (generated)

putting the recovery model to simple will not prevent it to grow.

The alter is performed in a single transaction so it will need the log space

to cover the whole...

As you know sql2005 starts with a closed configuration.

If you want to be able to use sp_oa... you'll have to enable "ole" using sp_configure or SAC-features (surface area configurator).

Check out...

as already stated more than once.

SQL2005 : nomore update to system objects. And that's a nice job !

I guess with "Delete sys.sysdatabases where DBID = 16" you're trying to fool...

I've noticed you use double quotes in your script in stead of two single quotes !!

This code executed fine at my testserver

Declare @name sysname

Declare @statement nvarchar(1000)

declare helpdb_cursor cursor for

select name...

-If you only want it in all new userdatabases, grant the users auth in model db.

- in your cursor solution, you should execute the "use db" and the other statements...

Did you enable "auto close" for this database ?

If you did, the database will be closed by sqlserver if it is not being used for some time.

If the...

If you are on SP2, you can use login triggers.

They only fire at login time.

If a user switches db in his current connection, you may not see it.

Check bol

char is a fixed length datatype that takes all the length as defined in the clause, no matter if you actualy fill it up or not, so that would not...

Using the scripts is the "shortest" way.

You could also restore the database with a new name and then

delete all datacontent using truncate table or delete from table.

(watch out for...