Kad pravim neku tabelu, i kad je usnimim SQL mi ne dozvoljava nikakvu promenu tabele. Naprimer ako hocu da dodam jos kolona on mi prilikom usnimavanja kaze da nemam prava na re-creating. Molim iskusne sa SQL da mi pomognu gde da sebi stavim to pravo i sva prava da me ne gnjavi vise stakvim glupostima??? Ovako kakada dizajniram tabelu zbog jedne kolone moram brisat celu tabelu i sve ponovo !!! Pls, Help !!!
Kako da ovo resim u SQL 2008 Express ???
Zaključano
Zakačeno
Predpostaviću da koristiš Microsoft SQL Server Management Studio.
Idi na Tools->Options, otvori granu Designers->Table and Database Designers i isključi opciju "Prevent saving changes that require table re-creation".
Imaj u vidu da je ova opcija po defaultu aktivirana s razlogom, pa je isključi samo ako znaš šta radiš.
Idi na Tools->Options, otvori granu Designers->Table and Database Designers i isključi opciju "Prevent saving changes that require table re-creation".
Imaj u vidu da je ova opcija po defaultu aktivirana s razlogom, pa je isključi samo ako znaš šta radiš.
Potpis
"There is a theory which states that if ever anybody discovers exactly what the
Universe is for and why it is here, it will instantly disappear and be replaced by
something even more bizarre and inexplicable. There is another theory which states
that this has already happened."
-- Douglas Adams
Universe is for and why it is here, it will instantly disappear and be replaced by
something even more bizarre and inexplicable. There is another theory which states
that this has already happened."
-- Douglas Adams