see the option clause on the select statement.

I can't find the knowledgebase article about it.

Try posting this on the microsoft site

http://msdn.microsoft.com/newsgroups/

I'll do some more research and see if I can...

no.

see sp_renamedb in bol

Cursors never.

DTS - only when needed and never to control.

select count(*) from master..sysprocesses

where db_id = dbid('dbname')

Cursors never.

DTS - only when needed and never to control.

Is it the only thing accessing the table?

If so try with maxdop = 1.

Do you have the latest service pack?

There have been some bugs fixed with parallelism causing deadlocks.

Cursors never.

DTS...

???

Why do you care what a variable is named?

Why do you want it to be based on a parameter?

Cursors never.

DTS - only when needed and never to control.

You can name tthe columns and use convert(varchar(7000,txtcol) on the text column.

Do you want to include the text in the distinct?

Cursors never.

DTS - only when needed and never to control.

There is currently no equivalent of this in sql server - you have to coed it yourself.

You can use a recursive SP or function but probably better to use a...

Full backup only backs upenough of the tr log to do a restore.

You can restore tr logs across full backups - it is one of the reasons for doing them....

see

http://www.nigelrivett.net/spFormatOutputBuffer.html

Cursors never.

DTS - only when needed and never to control.

>> The order table has a unique index key which surly must need a Clustered index to speed performance?

No.

Depends on the nature of the system. A clustered index will help...

declare @i int

select @i = -1

while @@rowcount > 0

begin

select @i = @i + 2

insert newtbl

select SalesID, substring(States,@i,2)

from oldtbl

where len(Sales) >= @i + 1

end

Cursors never.

DTS - only when needed and never...

You will need something to provide the dates but you can join to the table rather than insert.

Cursors never.

DTS - only when needed and never to control.

Given the same parameters it must return the same result.

You cannot use things like getdate() within the function.

There are a lot of restrictions on functions - see bol.

Cursors never.

DTS -...

No idea what you want - can you give an example.

Cursors never.

DTS - only when needed and never to control.

a stored procedure is executed

exec s_mysp

whereas a function can be used in a select statement - depending on it's type.

A function has to be deterministic.

See bol for a description.

Cursors never.

DTS...