Forum Replies Created

Viewing 15 posts - 3,316 through 3,330 (of 13,460 total)

  • RE: Doubling up of Alpha numeric password

    glycere2000 (6/5/2013)

    Can you say what other specifics you need? This particular function has been working well for years and only about couple of months i realized this has happened sporadically....

    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, 2013 at 12:08 pm

    #1621453

  • RE: Doubling up of Alpha numeric password

    glycere2000 (6/5/2013)

    I have a vb6 application and the database is housed on an SQL2000 server. My problem is that the vb6 function should increment the numeric form of 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!

    June 5, 2013 at 9:42 am

    #1621396

  • RE: Audit changes in table using stored procedure

    lsalih (6/5/2013)

    I would like to ask for help with creating a stored procedure to generate below information:

    1- A time stampt for record creation in a table, a time stamp shows...

    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, 2013 at 8:53 am

    #1621368

  • RE: SQLCMD Utility and Input Parameters

    sure, just run sqlcmd /? to see the defaults, but BOL for details:

    sqlcmd /?

    Microsoft Windows [Version 6.1.7601]

    Copyright (c) 2009 Microsoft Corporation. All rights reserved.

    C:\Users\lizaguirre>sqlcmd /?

    Microsoft (R) SQL Server Command...

    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, 2013 at 7:20 am

    #1621344

  • RE: How to add Just a delete word in the column of the destination table while the record is found to be deleted. while using the stored procdure with MERGE.

    this is syntactically correct, and what i think you were looking for:

    now you will NOT use the procedure, but run this command instead.

    MERGE INTO linked.dbo.student tgt

    USING linked.dbo.studentdetails src

    ON src.[StudentID] =...

    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 4, 2013 at 2:58 pm

    #1621113

  • RE: How to add Just a delete word in the column of the destination table while the record is found to be deleted. while using the stored procdure with MERGE.

    run this command with the original/unaltered version of generate_merge , and copy and paste the results:

    EXEC [dbo].[generate_merge]

    @SrcDB = LINKEDCP,

    @SrcSchema = dbo,

    @SrcTable = student,

    @TgtDB = LINKEDCP,

    @TgtSchema = dbo,

    @TgtTable = totalstudent,

    @predicate =...

    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 4, 2013 at 2:43 pm

    #1621103

  • RE: How to add Just a delete word in the column of the destination table while the record is found to be deleted. while using the stored procdure with MERGE.

    don't modify the procedure.

    paste the results of the procedure for your table here.

    we can help you modify the results,a nd you'll execute those modified results instead.

    for example, after formatting, my...

    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 4, 2013 at 2:16 pm

    #1621099

  • RE: what are a given user's connection properties?

    i knew there was a dmv with this info (select * from sys.dm_exec_sessions) , but i had to google it myself to be sure;

    this blog has a nice explanation 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 4, 2013 at 2:02 pm

    #1621097

  • RE: How to add Just a delete word in the column of the destination table while the record is found to be deleted. while using the stored procdure with MERGE.

    we don't need the source code in this case, we just need to see the exact command you are trying to execute, i think;

    exec [generate_merge] 'CDM','dbo','tbstate','CDMLIVE','dbo','tbstate',@debug=1

    the issue with the code...

    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 4, 2013 at 1:58 pm

    #1621095

  • RE: sql server 2012 memory limit

    oops yes i see that now on this page:

    http://msdn.microsoft.com/en-us/library/cc645993.aspx

    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 4, 2013 at 1:36 pm

    #1621092

  • RE: sql server 2012 memory limit

    i don't think there's a limit on RAM;

    the default setting is 2048 terabytes of ram as the default maximum setting until you change it to something less than what 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 4, 2013 at 1:32 pm

    #1621090

  • RE: Use of brackets around data names

    Howard I have 2012, but I'm not sure where, specifically, you are talking about where the objects get bracketed by the quotename() function;

    do you mean when you script an object?...

    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 4, 2013 at 1:27 pm

    #1621089

  • RE: Are the posted questions getting worse?

    GabyYYZ (6/4/2013)

    SQLRNNR (6/4/2013)

    GabyYYZ (6/4/2013)

    Back...what I miss?

    We are busy writing the DR plan for SSC and RedGate. Nothing big.

    Ahhh...in our company, we consider naivete and blissful ignorance as sound DR...

    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 4, 2013 at 12:10 pm

    #1621071

  • RE: NOLOCK is giving different result sets.Why?

    sachin6139 (6/4/2013)

    I have 2 select statements. One with NOLOCK hint and other without NOLOCK hint. I am getting different result sets. Rows are same but there order is different....

    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 4, 2013 at 11:51 am

    #1621065

  • RE: Wny "JOIN expression not supported"?

    i had to add one more alias near the end to get this to parse correctly in SQL:

    (also several columns are using reserved word names: xxxSTAFF.[File],xxxBanks.[Desc], xxxPayrollBankGroups.[Group])

    ...

    FROM [xxxOES Absence 2006...

    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 4, 2013 at 10:37 am

    #1621043

Viewing 15 posts - 3,316 through 3,330 (of 13,460 total)