as far as i know, you could use a case sensitive specific, but all the examples i've tripped on here in the forums always go compare binary; some collations cannot...

i think you'll have to bulk insert into a staging table, and then move fromt he staging table to a final table. BULK insert doesn't have any data massaging like...

yes...all you have to do is COLLATE using a case sensitive collation just for the comparison/where statement:

...where name <> upper(name) collate Latin1_General_BIN

SELECT

CASE

WHEN 'India'...

Stefan one of the things i love to do is test the permissions... you don't need to login as them or anything.

for example, supposed add a user to a database......

Stefan Krzywicki (6/7/2011)

---

Thanks, I'll take a look at that. It is actually a single person I'm granting access to a single table. In the scenario I described, they shouldn't see...

not really a basic question; usually developers are used to having full permissions on everything, and preventing access isn't really part of the picture until later.

SQL is deny by default...so...

is every field dbl quote delimited, regardless of value being integer, decimal or string, or just strings?

please post back if it works for you; this same issue comes up on otehr posts, this is the first time i really jumped in at it.

my idea worked fine for me; copied 1637 tables, and thier data with no problem.

I had to do recompile all the views, and script htem and procs/functions separately.

in my case,...

toparsi (6/7/2011)

---

Thanks Lowel,

I will probably have to do the generate scripts for creating DDL Scripts. But I need to have all the schemas in the same Database, so the second...

ok how about this...untested but i'm brainstorming.

backup and restore the database as a new database.

go to the "new" database, and rename a specific schema to a new name.

use the "Transfer...

i assume that working within the new/specific schema is critical, and so copying the database and restoring under a new database name is not really an option?

is using the ideas...

toparsi (6/7/2011)

---

Hello Guys,

I have an application which has one dbo schema and 2 other schemas. Client wants me to create copies of certain schema for his testing with different name....

there's more to the job than you posted...this is all that was in the docx file you posted:

set nocount on

declare @ppdate datetime

declare @sqlcmd nvarchar(4000)

declare @cmdTxt nvarchar(4000)

DECLARE @i int

EXEC master..xp_fileexist...

Sriram.RM (6/7/2011)

---

your query would not find if it contains special charecters.... try this..

SELECT COUNT(*) VAL2 FROM

(

SELECT COLUMN_NAME FROM TABLE_NAME WHERE (C1 NOT LIKE...