Forum Replies Created

Viewing 15 posts - 4,396 through 4,410 (of 13,460 total)

  • RE: windows user is created and unable to connect to sqlserver

    new users are at least a three step process:

    create the user in Active directory (you said that was done)

    create a login for the user in SQL Server(you said that 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!

    November 14, 2012 at 6:16 am

    #1558891

  • RE: windows user is created and unable to connect to sqlserver

    --deleted duplicate post.

    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!

    November 14, 2012 at 6:08 am

    #1558889

  • RE: Index scan on foreign key reference

    the index scan is normal, from what i read, since the constraint for the foreign key needs to be validated; to do that, it has to check the existing values...

    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!

    November 14, 2012 at 5:30 am

    #1558867

  • RE: How To Calculate Aggregations Over Time Periods using T-SQL

    YSLGuru (11/13/2012)

    Lowel

    Thank you for the reply but I'm not following how this can be used to get the answers I'm looking for. Could you perhaps provide an example using...

    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!

    November 13, 2012 at 3:17 pm

    #1558682

  • RE: Request for migration advice

    Just one question, though. Why do you leave the new server unpatched until later in the migration?

    it's just something i saved in my notes...i think it has more to 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!

    November 13, 2012 at 2:47 pm

    #1558669

  • RE: When was server last rebooted?

    edit; for reference for others , he mentioned he already knows this one, as opposed to when the OS restarted:

    select

    sqlserver_start_time

    from sys.dm_os_sys_info

    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!

    November 13, 2012 at 2:42 pm

    #1558666

  • RE: Request for migration advice

    side by side migration, or an in place upgrade?

    there's not a lot of difference in the preperation, as compared to a full on disaster recovery plan....if the new server doesn't...

    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!

    November 13, 2012 at 2:22 pm

    #1558658

  • RE: Query to find anywhere in database where there are sets of 16 or 17 numbers

    ok, i *think * this works fine.

    i'm testing it for shorter 4-number-in-a-row patters for simplicity.

    it doesn't quote work when the patter exists multiple times...it does fix one offending string each...

    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!

    November 13, 2012 at 1:40 pm

    #1558639

  • RE: How To Calculate Aggregations Over Time Periods using T-SQL

    YSL I have a pair of TableValued functions for this, that i use to join against existing data so i can group by the rounding up or rounding down 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!

    November 13, 2012 at 1:18 pm

    #1558630

  • RE: Query to find anywhere in database where there are sets of 16 or 17 numbers

    SQLKnowItAll (11/13/2012)

    Don't need the OR for the 17.. The 16 will catch it 🙂 and anything more than 16.

    doh! thanks, how did i miss that?!

    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!

    November 13, 2012 at 12:44 pm

    #1558621

  • RE: Search All Tables

    create a temp table,and change the query to insert something into the table instead of a simple select...maybe the table name and the column name or something...or a PK...

    you can...

    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!

    November 13, 2012 at 12:42 pm

    #1558620

  • RE: Query to find anywhere in database where there are sets of 16 or 17 numbers

    the next part, the find and replace gets ugly very quickly.

    is it possible that more than one number appears int eh memo field? ie two or three 1/17 digit numbers?

    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!

    November 13, 2012 at 12:39 pm

    #1558617

  • RE: Query to find anywhere in database where there are sets of 16 or 17 numbers

    if you know it's a single table, it's going to look something like this:

    you can use the pattern matching , regular expression style of the LIKE statement:

    SELECT *

    FROM YOURTABLE

    WHERE...

    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!

    November 13, 2012 at 12:28 pm

    #1558609

  • RE: Dropping Constraints from multiple tables

    instead of dropping and recreating, it would be a lot easier to simply rename the existing constraints instead. sp_rename takes any object name that exists in sys.objects , not just...

    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!

    November 13, 2012 at 11:29 am

    #1558587

  • RE: Stored Procedure

    edward_hall76 (11/13/2012)

    ok. where I work not all people know how to write tsql code and if they mess up the tsql they do not know how to fix it 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!

    November 13, 2012 at 9:33 am

    #1558545

Viewing 15 posts - 4,396 through 4,410 (of 13,460 total)