Forum Replies Created

Viewing 15 posts - 7,426 through 7,440 (of 13,459 total)

  • RE: Making multiple copies using a Schema

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 7, 2011 at 10:15 am

    #1335147

  • RE: Making multiple copies using a Schema

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 7, 2011 at 9:53 am

    #1335126

  • RE: Making multiple copies using a Schema

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 7, 2011 at 9:46 am

    #1335113

  • RE: Making multiple copies using a Schema

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 7, 2011 at 9:20 am

    #1335088

  • RE: master db code

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 7, 2011 at 9:14 am

    #1335081

  • RE: To validate the column with only alphabets

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 7, 2011 at 8:41 am

    #1335059

  • RE: What is the replacement of AWE?

    doh thanks and i edited my psot...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 7, 2011 at 7:47 am

    #1335016

  • RE: ASP and SQL Help

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 7, 2011 at 7:37 am

    #1335007

  • RE: What is the replacement of AWE?

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 7, 2011 at 7:26 am

    #1334996

  • RE: How to find the stored procedure causing performnace problem

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 7, 2011 at 5:52 am

    #1334916

  • RE: How to find the stored procedure causing performnace problem

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 7, 2011 at 5:39 am

    #1334912

  • RE: What is DAC

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 7, 2011 at 5:26 am

    #1334905

  • RE: sharepoint db grows quickly

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 7, 2011 at 4:33 am

    #1334878

  • RE: Want to create a service broker broker application for auditing my databse

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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 6, 2011 at 11:09 pm

    #1334787

  • RE: Want to create a service broker broker application for auditing my databse

    a single, master table tracking all changes and the original values isn't really going to work well...think it through with me.if you want to keep old and new values, you...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 6, 2011 at 10:37 pm

    #1334783

Viewing 15 posts - 7,426 through 7,440 (of 13,459 total)