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...

doh thanks and i edited my psot...

SQL uses the CONVERT function to format dates...there's an optional parameter, like 101, which means dd/mm/yyyy; you can read the details inbooks online under "Cast and Convert"

i think this is...

AWE was the work around for 32 bit systems, because hard drives available RAM got larger than the upper limit of the # of address the system can keep track...

thanks for the clarification Gail!

you said "... If a plan is never cached, it won't appear in the query stats DMV at all...", can you clarify?

I thought every query...

i can think of two ways:

1. set up a DML trace, and after it's run for a while, look at the high values in Duration, Reads,Writes or CPU as a...

DAC is the Dedicated Administrative Connection...If you enabled in on your server (it's optional and off by default), when you have a runaway process you can still connect, and maybe...

forsqlserver (6/7/2011)

---

Shrink Creates Fragmentation, U can use other ways to shrink the database.

check the mdf,Ldf size,

Take a full backup,

Change the recovery model to simple,

again do a full backup,

check the ldf...

ok...i see the plan...but it goes back again to what will the table be used for? the purpose of the table has a lot to do with the best way...