The use of EXISTS implies that the column list is not even checked only the WHERE predicate is taken into account.

So with EXISTS: select 1, select 'x' and select *...

Those Registry keys apply to SQL Server 2000

select *

from yourtable

where len(address) - len( replace(address,' ','')) <= 1

I am not really sure I understand your question.

Those stored procedures can not be executed by non sa users. And they imply cycling the error log, setting up log shipping,...

Linda,

That message is ususally cause by an OS trim in memory and if the sql server Edition you have is the Standard Edition you are out of luck. There is...

Examples:

sp_configure -- although you can use serveradmin role I prefer this is only done by sysadmins

sp_cycle_errorlog

sp_procoption

sp_addextendedproc -- although you can use CLR now...

Cool.

WITH (NOLOCK) Can produce dirty reads and invalid spureous ROWS.

Also you Could Try Truncating the log ...Note that this is not recommended but given your situation it may get you out of the problem.

sqlquery (10/5/2007)

---

Hi ,

I have scenario where we have huge tables Transactional replication and now requirement is to re-initialize the subscription , what are the things we need to take care...

Not really that...

great catch. Sometimes we don't see the forest for the trees ... 😀

John,

Merge gives you "automatic" identity range handling. you do want to replicate the identity values and you will have to either partition the values or use the "automatic" range. In...

joachim.verhagen (10/5/2007)

---

noeld (10/5/2007)

---

Not entirely sure but you should check client side code for any unhandled exception. The "missing cursor declaration" part is a hint that something is not working properly...

sysadmin is necessary for SERVER wide settings changes.