what is the...

well, you are mixing up DML and DDL, and they should be completely seperate steps...first alter the tables if needed, then do your transaction.

something like this, and note i explicitly...

well, i don't have a products table, to alter, and it was not included in your sample script, so here's mny best guesses:

you don't have GO statements after your...

TYPE is a keyword, so you'll need to put it in brackets:

ALTER TABLE product

ALTER COLUMN [TYPE] VARCHAR(25) NOT NULL

all of the DotNet versions install side by side in the %windir%\Microsoft.NET folders, they never overwrite each hooter, so you won't have an issue.

you'll just end up seeing a...

via TSQL, the best answer is no, you cannot install a new SQL instance via TSQL.

it has to be done from the operating system side, with the example parameters supplied...

i think i'd export the tables out to a different database, restore, and then delete and insert back into the original table...but if you've got foreign keys involved, that would...

i would guess it's due to the joins:

bd.SORTUSER_EMPID = ed.[Employee ID]

i think maybe one column is an integer or numeric column, and the other is varchar?

due to data type precedence,...

my concerns mirror steve's;

If this was a suite of web pages i dropped into a virtual folder on my own IIS server, yeah it would probably be a good idea.

If...

for me, it doesn't matter if it's entity framework or an ADO connection or anything else. it doesn't make a real difference in what it's going to do.

in our shop,...

srimkumarp-720356 (7/22/2013)

---

Thanks for the information.

We are using only Server level audit trigger.

For example :- I created the login on one server and later drop the same login. Now I want...

srimkumarp-720356 (7/22/2013)

---

Hi ,

I want to capturethe Audit Server Security Events , like if any one doing Create / Alter / Drop logins on server level ,...

truncate is not granular like that; it's inherent in db_owner and db_ddladmin, i believe.

just make sure noone has those rights.

what difference is there if the user is allowed to delete...

Guras (7/19/2013)

---

I need to find the disk space estimation to create a new database with all the objects of the current databases ( without the data copied) ..for e.g. I...

fraggle i just tested this myself;

i was hoping i could alter a user and remove their mapping to the existing login, but i found i had to crop and recreate...