Forum Replies Created

Viewing 15 posts - 3,286 through 3,300 (of 13,460 total)

  • RE: Login History - who connected to a database?

    rajborntodare is correct;

    the information is not saved anywhere on SQL server, unless you explicitly added one of the many audit options available to SQL server.

    so going forward, I would recommend...

    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 13, 2013 at 6:15 am

    #1623653

  • RE: My row_number() is misbehaving or I'm an not a smart man

    wow amazing what a little coffee can do for me!

    my issue was the wrong tool for the job.

    i needed to use DENSE_RANK() and not ROW_NUMBER

    this is what i should 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 13, 2013 at 6:06 am

    #1623640

  • RE: Import CSV File

    arooj300 (6/13/2013)

    Hi,

    I have a 4 GB CSV file , which i am unable to import in SQL Server 2008 R2, even I not able to open file also. I tried...

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

    #1623635

  • RE: How to get the list of tables that has specific column name from linked server, available in SQL SERVER 2008 R2

    prtk.raval (6/7/2013)

    Hi champion, What is SSMS..where I have to copy the result of column1.?

    SSMS = SQL Server Management Studio, sorry about the acronym!

    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 7, 2013 at 3:04 pm

    #1622194

  • RE: How to get the list of tables that has specific column name from linked server, available in SQL SERVER 2008 R2

    here's two ways how i might do it.

    first create yourself a temp table to capture the results from the code below:

    the code below is doing TWO examples,

    one to build...

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

    #1622180

  • RE: How to get the list of tables that has specific column name from linked server, available in SQL SERVER 2008 R2

    prtk.raval (6/7/2013)

    I am just wondering about the the tables as they are located as following structre in SQL SERVER MANAGMENT STUDIO

    SERVER OBJECT => LINKED SERVER => [ORACLE LS] => [CATALOG]...

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

    #1622122

  • RE: Time out Expired

    vs.satheesh (6/7/2013)

    i am using CTE in following ways

    with CTE1

    (

    select * from xx

    ),

    CTE2

    (

    select * from xx a inner join CTE1 CT on xx.id=CT.id

    ) ,

    CTE3

    (

    select *...

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

    #1622120

  • RE: How to get the list of tables that has specific column name from linked server, available in SQL SERVER 2008 R2

    it's incredsibly similar; you just have to use the four part naming convention:

    SELECT

    TABLE_NAME,

    COLUMN_NAME

    FROM

    MyOracleLinkedServer...ALL_TAB_COLUMNS

    WHERE

    COLUMN_NAME LIKE '%PATTERN%';

    if you are not a sysadmin on the linked server, you might have to use USER_TAB_COLUMNS...

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

    #1622084

  • RE: Error converting Varchar to Float

    not sure which of the two tables are the problem, but i'd start by looking at any values that cannot convert to a numeric datatype:

    SELECT * from [dbo].[Final] ...

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

    #1622048

  • RE: prevent simultaneous update

    whether is was near simultaneous or five minutes apart, what prevents two people form overwriting the task at all?

    does the business /app portion present a list of available task slots...

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

    #1622046

  • RE: Performace issue while updating records and trigger on table

    it's going to look a lot like this:

    the only thing i could not determine was the primary key that woudl related the INSERTED to the DELETED ; your example did...

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

    #1622042

  • RE: How can we find the Null values on indexed columns from all tables in SQL Server.

    Sean Lange (6/6/2013)

    I for one would be super interested in seeing how you reverse engineer your indexes. I just went through this process and I have a feeling yours 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!

    June 6, 2013 at 3:31 pm

    #1621920

  • RE: read registry w/o sysadmin, is it possible?

    here's a start to finish example, where i create a user, grant just the permissions Perry identified in his posts, specifically impersonate that user for testing, and then read from...

    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, 2013 at 3:18 pm

    #1621918

  • RE: How can we find the Null values on indexed columns from all tables in SQL Server.

    Sean mine was just a lazy adaptation of something that already existed; it was easier than from- scratch script to find them; this adapted snippet from the middle of your...

    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, 2013 at 3:06 pm

    #1621913

  • RE: How can we find the Null values on indexed columns from all tables in SQL Server.

    bslchennai (6/6/2013)

    Yes, i have to take care of all null values because in our database we should not insert null values on indexed columns. and now my database size 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 6, 2013 at 2:55 pm

    #1621908

Viewing 15 posts - 3,286 through 3,300 (of 13,460 total)