Re: FN-FORUM: sql server again

date posted 1st October 2003 19:59

if you can't manually overwrite the data then check the following:

its not in firehose mode
theres no triggers protecting the data
you're not in a view where constraints are stopping you editing data


PAMELA WHITTAKER wrote:

>I have got enterprise manager but I being rather thick as I can't work out
>how to do it. You can't just overwrite the data and I can't work out where
>you put in the sql to do it.
>
>Pam
>
>----- Original Message -----
>From: "J Sutton" [EMAIL REMOVED]
>To: [EMAIL REMOVED]
>Sent: Wednesday, October 01, 2003 4:30 PM
>Subject: RE: FN-FORUM: sql server again
>
>
>
>
>>If you use the SQL enterprise manager (if installed) that is the
>>easiest; If not have you got the "IMPORT EXPORT DATA" option in the
>>start menu (start > programs> etc...)
>>
>>Many thanks,
>>J Sutton
>>
>>-----Original Message-----
>>From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of PAMELA
>>WHITTAKER
>>Sent: 01 October 2003 16:26
>>To: FN-FORUM / [EMAIL REMOVED]
>>Subject: FN-FORUM: sql server again
>>
>>
>>Hi,
>> How do you change the data in an sql database in my personal sql
>>server
>>on my PC. I am on windows mx. I presume you use sql query anal
>>yser but it
>>doesn't seem to like (local) as the name of the server and the drop
>>down
>>does do anything.
>>
>>Pam
>>
>>
>>==========
>>redmail.com - webmail with a difference!
>>10Mb for just GBP 9.99 a year. Launch special 1Gb for GBP 99.99 a year
>>IMAP, POP3, Spam Filtering and Anti Virus as standard.
>>Visit http://www.redmail.com/?fl-signup to join.
>>
>>To advertise he
>>re: http://www.freelancers.net/advertising.html
>>
>>
>>==========
>>redmail.com - webmail with a difference!
>>10Mb for just GBP 9.99 a year. Launch special 1Gb for GBP 99.99 a year
>>IMAP, POP3, Spam Filtering and Anti Virus as standard.
>>Visit http://www.redmail.com/?fl-signup to join.
>>
>>To advertise here: http://www.freelancers.net/advertising.html
>>
>>
>>
>>
>==========
>redmail.com - webmail with a difference!
>10Mb for just GBP 9.99 a year. Launch special 1Gb for GBP 99.99 a year
>IMAP, POP3, Spam Filtering and Anti Virus as standard.
>Visit http://www.redmail.com/?fl-signup to join.
>
>To advertise here: http://www.freelancers.net/advertising.html
>
>