So exec Sp_Cycle_ErrorLog or dbcc errrorlog do not work using Query analyser.

Did you also perform a checkpoint using Query analyser ?

If none of the above work, I guess you're...

Books online explains it !

A user can set a savepoint, or marker, within a transaction. The savepoint defines a location to which a transaction can return if part of the...

no !

Savepoints only work within your transaction.

(check BOL)

You'll need to search for other solutions to minimize your locking elaps time.

- Try to optimize setbased handling of your data.

- AVOID cursors

-...

you'd be better off keeping the presentation issues at the presentation layer ! (So handle it in your vb app. or whatever, maybe simply even use the clientside settings...

check the SPN ! if you rely on kerberos authentication.

the service principal name also includes the portnumber of your sqlserver.

Check the sqlserver error log for the spn message at startup...

as you have noticed, SQLServer does not work like MSaccess :sick:

As suggested by the previous responders, using columaliasses in your view will be the only solution. (view column names must...

- first be sure you have other access as sysadmin (windows or another user)

- just give it a password you cannot remember (mixture and very long) 😉

- Create a...

the error means there is dat in your column that it cannot convert to a valid date.

select case when yourcol = '' or yourcol is null then null

...

HTH

been there ... done that .... wrote the article :w00t::cool:

Sometimes it's these litte things that make the day 😉

use Books Online !!!

it states :

Important:

ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in...

in many case it will work, in others it won't.

Start with SQL2005 upgrade adivsor !

Test - Test - Test

if you can join the objects it may be pritty easy

begin transaction

update T1

set col1=T2.colx

from mytable T1

inner join myothertable T2

on T1.mycol = T2.mycoltoo

where

is it ok ?

-- rollback tran...

thanks for the feedback.

I'm glad you got it working.

you've missinterpreted the way "exists" work.

In your case it should be :

SELECT distinct section_code, source, section_name

FROM special_sections SpS

WHERE NOT EXISTS (SELECT *

FROM SPECSECTIONS S...