Did you check common table expressions (CTE) ?

This has recursive capacities.

There are some nice examples at SSC, as well as performance articles regarding CTE and the alternatives.

AFAIK: No.

Locking is also dependant on the type of connection isolation level or command isolation level you are using. Hence, no info regarding execution plan.

However, you can launch sql profiler...

did you check Jeff's concatenation article ?

http://www.sqlservercentral.com/articles/Test+Data/61572/

If not, you realy should 😉

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...