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

If you don't use the alter table.. add colum ... methode you also need to take care of foreign keys (from or towards your table) !!

if you perform it the EM-way (rename / create new / insert / drop renamed), you may be able to avoid a needed rebuild index because of e.g relocated...

keep in mind sqlserver is actualy recreating your table and indexes and inserting the existing rows into it.

IO is your slowest operation.

btw you can script this operation with Enterprise manager...