Forum Replies Created

Viewing 15 posts - 7,306 through 7,320 (of 13,460 total)

  • RE: check the version of backup

    and an example to save you a trip to BOL:

    RESTORE HEADERONLY

    FROM DISK='C:\Data\SandBox9090_081010.bak'

    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 27, 2011 at 5:56 am

    #1344432

  • RE: Database compatibility level(s) - log/history

    i just checked, and found that you can find the changes in the Application Log of the server.

    It doesn't count as a DDL statement, so the default trace doesn't have...

    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 27, 2011 at 5:38 am

    #1344424

  • RE: Converting a string to a generalized format

    you can easily add a CLR for regular expressions, so since it's something you can do yourself, i don't think you'll ever see it included in a future version.

    search fro...

    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 26, 2011 at 10:04 am

    #1344220

  • RE: DBA member updated the data. How to confirm that he did the update.

    george sibbald (6/24/2011)

    beg to differ, for example:

    http://www.apexsql.com/sql_tools_log.aspx

    why would there be such tools if it wasn't for auditing purposes, to see WHO did what, so that information is in the log.

    george...

    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 24, 2011 at 6:27 pm

    #1344007

  • RE: data export to csv file

    sounds like you opened the file in Excel, and not a simple text editor;

    excel might reformat the presentation of any column to what it thinks is best...

    open the csv 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 24, 2011 at 2:13 pm

    #1343917

  • RE: DBA member updated the data. How to confirm that he did the update.

    jvskarthick (6/24/2011)

    Nice one. Using the server side trace is there a way we can log the data only for perticular user. like the filter we set on SSMS trace file.

    Thanks,

    JK

    yes...

    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 24, 2011 at 2:08 pm

    #1343914

  • RE: How can I tell when the last time a table was accessed?

    another thing you could do is restore an old backup and a "today" backup, and compare the tables between the two databases; if any table is not the same...

    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 24, 2011 at 1:28 pm

    #1343900

  • RE: How can I tell when the last time a table was accessed?

    can you create a job today, pull from that view, and log the changes for 6 months or something?

    at least you'd be able to answer better with some time...

    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 24, 2011 at 1:26 pm

    #1343899

  • RE: How can I tell when the last time a table was accessed?

    james.massey (6/24/2011)[hrCorrect me if I'm wrong (occurs entirely often), but that only tracks changes and does not pay attention to selects.

    it has the last tiem an index had a SEEK...

    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 24, 2011 at 1:14 pm

    #1343895

  • RE: DBA member updated the data. How to confirm that he did the update.

    running profiler has a huge impact, but a server side trace has minimal impact;

    I have a DML/Login trace, kind of like the default trace, keeping track of the last...

    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 24, 2011 at 1:11 pm

    #1343893

  • RE: How can I tell when the last time a table was accessed?

    james.massey (6/24/2011)

    Lowell, unfortunately, I believe you are correct. I've already looked that blog entry while looking for answers, and this method is accurate only since the SQL Server was...

    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 24, 2011 at 1:07 pm

    #1343887

  • RE: DBA member updated the data. How to confirm that he did the update.

    if you do not have a trace already in place, you cannot identify who did it;

    you can read the log with some third party tools, but the log only has...

    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 24, 2011 at 1:01 pm

    #1343878

  • RE: How can I tell when the last time a table was accessed?

    run this and see if it gets you the info you are looking for...

    if a table has not been acccessed at all, it's not on the list; read the article...

    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 24, 2011 at 12:55 pm

    #1343871

  • RE: Mask a column for SSMS

    Garadin (6/24/2011)

    I think he 'cheats' by having a big repository of all these code snippets right at hand!

    Yes I'm jealous =).

    guilty as charged i've got an aweful lot of snippets...

    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 24, 2011 at 12:38 pm

    #1343861

  • RE: Mask a column for SSMS

    Sean Lange (6/24/2011)

    Excellent. Thanks Lowell. Of course now I have no excuse not to work this afternoon. 😛

    there's always work to do in the salt mines...i'm sure. I wanted 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 24, 2011 at 12:23 pm

    #1343851

Viewing 15 posts - 7,306 through 7,320 (of 13,460 total)