Forum Replies Created

Viewing 15 posts - 9,016 through 9,030 (of 13,460 total)

  • RE: will sql find my old master,msdb etc and upgrade it

    ron morgan (7/21/2010)

    my question is if i uninstall sql 2000 and then install sql 2008 or 2005 will it find and upgrade my pervious master and msdb left behind by...

    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!

    July 21, 2010 at 1:53 pm

    #1196467

  • RE: logon logout auditing

    after setting up that logging demo example, this query gets me the groups of login/logut elapsed times: note i am testing for a specific application name. i could then...

    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!

    July 21, 2010 at 9:59 am

    #1196274

  • RE: logon logout auditing

    can you infer that ALL logins are only used for the ERP program?

    a login does not know what database you are connecting to...the login happens before all that.

    assuming you are...

    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!

    July 21, 2010 at 9:16 am

    #1196237

  • RE: logon logout auditing

    you mean the first and last login per day?

    once the data is in the table "Logging " fromt hat article, you can easily create a view that might do...

    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!

    July 21, 2010 at 7:42 am

    #1196155

  • RE: Not sure with this

    Martin one of the things you can do to get a better look at what SQL is doing behind the scenes is to look at either the Estimated Execution Plan...

    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!

    July 21, 2010 at 5:55 am

    #1196083

  • RE: restore sql server system databases

    Oracle_91 (7/21/2010)

    Since we are restoring on a new server which is currently not in use and i have taken the sql server into single user mode then why cant we...

    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!

    July 21, 2010 at 5:44 am

    #1196080

  • RE: BCP IN error: #@ Row 1, Column 1: String data, right truncation @#

    lak's suggestion still stands; if you bracket the server name you'd fix the issue:

    select quotename(@@SERVERNAME)

    --or

    select quotename(ColumnName) from SomeTable

    you are probably building the bcp string, right? very simple to get the...

    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!

    July 21, 2010 at 5:33 am

    #1196074

  • RE: Dirty data

    that's the point...it's a business decision...some examples:

    1. Data was entered in all capital letters(SMITH) biz rule says it should be proper cased.

    2. duplicate data exists for 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!

    July 20, 2010 at 8:52 am

    #1195585

  • RE: Dirty data

    yeah, there's no built in way to determine what data is "clean" or "dirty", it's a decision based on analysis...and one man's definition of dirty is not the same as...

    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!

    July 20, 2010 at 8:26 am

    #1195564

  • RE: How to create new line when writing from table to txt file

    I'm assuming the variable @VsebZapis is the string you are writing?

    are you adding a CrLf to the end of it, so each record is on a single line in the...

    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!

    July 20, 2010 at 8:22 am

    #1195561

  • RE: trivial little anoying issue i've had for some time

    it's in the registry, and there's one for each version of SSMS, it looks like:

    for 2008, for exmaple it's here:

    HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell

    that's where you would change everything to default 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!

    July 20, 2010 at 8:14 am

    #1195557

  • RE: If...Else condition in store procedure to set value in variable

    i don't think your @r variable will ever be null.... count would return zero if nothing was found;

    SELECT @r = COUNT(*) FROM SchoolStudents WHERE roll = @roll

    --will return...

    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!

    July 20, 2010 at 5:44 am

    #1195430

  • RE: Image Data Type

    jyoti2705 (7/19/2010)

    "embed it like in this example i created: so you'll need to get the IMAGE datatype to a file so it can be attached prior to the email", how...

    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!

    July 19, 2010 at 12:16 pm

    #1195052

  • RE: Image Data Type

    AFAIK, images that will appear in an email must be an attachment. because html is interpreted, you can't just find and replace to ge tthe image in there.

    your choices...

    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!

    July 19, 2010 at 11:20 am

    #1195030

  • RE: mail sending issue

    James i'm guessing that you'd need to post the code for the procedure sp_sendmailsimmediately

    clearly it's using CDO instead of the newer msdb.dbo.sp_send_dbmail, and a required parameter is missing.

    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!

    July 19, 2010 at 6:46 am

    #1194863

Viewing 15 posts - 9,016 through 9,030 (of 13,460 total)