changing collation for all the columns can sometimes be a pain, especially if there are contraints or defaults on fields that are agetting their collation changed;

things like CHECK columnname IN...

Are you talking about when you copy/paste from SSMS?

in Management Studio, it's an option you can turn on and off:

Tools>>Options>>Query Results>>SQL Server>>

Results To Grid has a checkbox for "Include...

A Crud generator simply creates some procedures for you (for Create Read Update Delete:CRUD) based on a template and might assume one row inserts or updates for example.

In a perfect...

something like this should be pretty close:

if you cannot drop a database user because it is the object owner, this would rroll it back so you can fix that first.

SET...

and another way:

download and install the SSMS add-on Called SSMS Tools Pack:

http://www.ssmstoolspack.com/

that adds a CRUD generator to the right click of any table, which is exactly what you were after:

the syntax is like this, is this what you were after?

EXEC sp_addrolemember N'db_datareader', N'MyDomain\NewADGroup'

if you want everything previous, then wouldn't it simply be less than or euql to @param?

create proc somename

(@paramname int

)

as

begin

select what ever

from some table

...

left inner join? no such animal exists in SQL, so that's probably not what you meant. it's either a left outer outer or an inner join

whatever your code...

it depends.

if the user is going to get access to ALL stored procedures no matter what, it's a single command.

if it is a group of specific procedures, then it's...

like i said, your IF EXISTS query was not quite right.

this works:

ALTER PROCEDURE [dbo].[TESTADDEXTENDEDPROPERTIES] (

...

the EXISTS command you are using now is checking for the specific values as well, , i think what you want to do is to simply check if the Extended...

you are using a format file out of habit, is that it?

can you run the same command without the format file?

ie

bcp egarchivedb.dbo.egpl_casemgmt_activity in R:\ArchivePurge\BCP_Mortgage_email_bodies.txt -T -S xxxxxxxxxxxxxxx\INST1,1433 -t"[||]" -r"[~~]"...

weird that you are getting no rows; my example is syntactically correct and runs fine for me.

can you paste your exact bcp commnad you are using?

did you try via...

i thought you had this solved.

from your previous thread, you said the values were blank and the ned user is oing to update them if desired.

in that case, it's going...

there's a LOT of things that could...