Forum Replies Created

Viewing 15 posts - 5,056 through 5,070 (of 13,460 total)

  • RE: Derive column

    also watch for those fields that are missing the dash:

    SELECT

    CASE

    WHEN CHARINDEX('-', CID) >= 0

    THEN LEFT(CID, CHARINDEX('-', CID) - 1)

    ...

    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!

    August 3, 2012 at 11:09 am

    #1521534

  • RE: SQL Server Login/Logout Audit

    Id say that a server side trace has an incedibly small footprint because its not capturing much; plus you get better tracing than watxhing a dmv and infering a logoff.

    Test...

    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!

    August 3, 2012 at 10:32 am

    #1521518

  • RE: SQL Server Login/Logout Audit

    the advantage of the procedure is if i decide i want one running all the time, i can set the procedure to execute on server startup, so the trace gets...

    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!

    August 3, 2012 at 9:33 am

    #1521474

  • RE: SQL Server Login/Logout Audit

    I do.

    this script adds a stored procedure, which i assume you would put in master:

    linky for sp_AddMyLogonTrace.txt

    After running the script to create the procedure, if you run

    EXEC sp_AddMyLogonTrace

    it will...

    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!

    August 3, 2012 at 9:29 am

    #1521472

  • RE: SQL Server 2008 - Hosting permissions

    while not exactly a hosted environment, we provide our testers with he ability to restore their own specific database from a web page;

    the page lets them select the path to...

    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!

    August 3, 2012 at 9:08 am

    #1521460

  • RE: newbie sql S.o.S - please help

    for me , RBS needs the acronym spelled out, please;

    is that Remote Backup Software? Remote Buying System? Royal Bank of Scotland? Really Bad Service? some software package?

    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!

    August 3, 2012 at 7:36 am

    #1521389

  • RE: Procedure causes out of memory error

    i think the cursor is missing the FETCH that is supposed to be inside the cursor, so it knows to get the next record.

    as it is now, it is processing...

    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!

    August 3, 2012 at 7:21 am

    #1521373

  • RE: objects never being used -?

    Reverse the order of the tables isnmy recommendation.

    Select from sys.tables where not exists in then dmv isnthe way ive done it.

    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!

    August 2, 2012 at 6:07 pm

    #1521192

  • RE: Exiting sqlcmd with RAISERROR(50001,10,127)

    i think raising an error of level 20 disconnects the connection, so no further processing after the error would occur regardless of terminators; would that help instead?

    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!

    August 2, 2012 at 2:04 pm

    #1521126

  • RE: How to read data in a pdf file in SSIS

    can you go back to the source and get the same data in another format?

    AFAIK, there's no way to import from a PDF; you might be able to grab teh...

    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!

    August 2, 2012 at 1:59 pm

    #1521125

  • RE: Reindex job fails

    yogi123 (8/2/2012)

    Lowell (8/2/2012)

    the reindexing can be a huge operation; 1.5x the size of the indexes being rebuilt, as i seem to remember it. so the reindexing of a bunch...

    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!

    August 2, 2012 at 12:57 pm

    #1521095

  • RE: Reindex job fails

    the reindexing can be a huge operation; 1.5x the size of the indexes being rebuilt, as i seem to remember it. so the reindexing of a bunch of indexes...

    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!

    August 2, 2012 at 12:40 pm

    #1521076

  • RE: Reindex job fails

    a post here by Gail Shaw(Gilamonster) says it might be the log has filled up on the database:

    http://www.sqlteam.com/forums/topic.asp?topic_id=132921

    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!

    August 2, 2012 at 12:31 pm

    #1521071

  • RE: Reindex job fails

    was the password recently changed for the user PPSCENTRAL\mrcluster , and the job not updated withthe updated password, 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!

    August 2, 2012 at 12:19 pm

    #1521060

  • RE: Query help regarding selecting the second highesh value

    row_number() is your friend in this case.

    that will allow you to rank/assign a value to each row:

    SELECT ROW_NUMBER() OVER (PARTITION BY tblContactID ORDER BY tblContactID,TotalDue) AS RW,* FROM #TEST

    then with...

    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!

    August 2, 2012 at 11:21 am

    #1521029

Viewing 15 posts - 5,056 through 5,070 (of 13,460 total)