Forum Replies Created

Viewing 15 posts - 7,441 through 7,455 (of 13,460 total)

  • 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

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

    sure!

    more information about SQL2008 Change Data Capture

    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:26 pm

    #1334779

  • RE: MDS Home page redirecting to unauthorised.aspx

    so many acronyms on the internet...no way for me to know or infer what MDS was...

    ok, i googled a little bit for you here:

    http://www.google.com/search?hl=&q=Master+data+services+unauthorised.aspx

    and i found this information at...

    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:22 pm

    #1334776

  • RE: Splitting qualified name into table and schema

    yep there's a built in function to help;

    PARSENAME; give it a try, here's an example:

    SELECT

    PARSENAME(TheString,4),

    PARSENAME(TheString,3),

    PARSENAME(TheString,2),

    PARSENAME(TheString,1)

    FROM

    (SELECT '192.168.1.55' AS TheString UNION ALL

    SELECT 'Discount' UNION ALL

    SELECT 'dbo.Discount'...

    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 2:17 pm

    #1334661

  • RE: MDS Home page redirecting to unauthorised.aspx

    is the "MDS homepage" here on SQLServerCentral.com, or somewhere on the internet?

    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 1:12 pm

    #1334631

  • RE: Grant EXECUTE to user for ALL stored procedures (existing & new) in a schema.

    doh Gail beat me to it..i found the example in my snippets:

    GRANT EXECUTE ON Schema::schemaname TO <RoleName>

    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 12:21 pm

    #1334605

  • RE: Grant EXECUTE to user for ALL stored procedures (existing & new) in a schema.

    for the default schema... if you leave out the specific objectname it it grants to all objects:

    GRANT EXECUTE TO [YourRoleName]

    i think for a specific, non-default schema, say QA schema i...

    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 12:09 pm

    #1334599

  • RE: Simple Join taking too much time

    can you post the execution plan as a .sqlplan file here as an attachment?

    maybe we can see something you overlooked? a second pair of eyes never hurts!

    also, why is there...

    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:27 am

    #1334558

  • RE: Database Connection Time Outs

    Syed Jahanzaib Bin hassan (6/6/2011)

    check the locks on the database,if resources or locks are using by queries and taking time to login then enable the ROW Versioning in SQL Server

    What?...

    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:41 am

    #1334525

  • RE: sharepoint db grows quickly

    sqlfriends (6/6/2011)

    So, if shrinking files are not a good option, then what should I do?

    Just watch it getting bigger every day?

    regularly scheduled transaction log backups throughout the day.

    a database in...

    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 9:22 am

    #1334451

  • RE: Changing Databases in SSMS

    sdownen05 (6/6/2011)

    We all know the command to change from one table to another in SQL code:

    USE Table1

    GO

    USE Table2

    GO

    My question is this: Is there a way to change from one database...

    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 8:00 am

    #1334401

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

    SQL2008 introduced CDC...Change Data Capture...which is going to do everything you are asking and more, it's built in and it's documented, working and can be implemented on each table 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 7:49 am

    #1334394

  • RE: What is the difference between "tempdb.#tmptbl" and "tempdb...#tmptbl"?

    every object is resolved to a four part name when a statement is compiles

    ServerName.DatabaseName.SchemaName.ObjectName

    ServerName.DatabaseName.SchemaName.Tablename

    sometimes you can skip explicitly nameing the object and leave the word between the periods out, and...

    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 5, 2011 at 9:07 pm

    #1334171

  • RE: Why do we use # for temp tables name?

    cino (6/5/2011)

    I even notice ppl using ## or ###, does this have another meaning?

    Is this a common good practice? Or is there other specific good reasons we are using these...

    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 5, 2011 at 8:57 pm

    #1334170

  • RE: Use of partition Functions

    i think a quick google and read would be more beneficial to you than a brief forum post; once you've read up on the subject a little bit, if 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 5, 2011 at 8:08 pm

    #1334169

Viewing 15 posts - 7,441 through 7,455 (of 13,460 total)