Forum Replies Created

Viewing 15 posts - 6,241 through 6,255 (of 13,460 total)

  • RE: SQL login failure

    since you have control of the physical server on the laptop,

    you an stop and start the service in single user mode, connect and then add a domainuser or localuser...

    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!

    December 9, 2011 at 11:20 am

    #1419554

  • RE: Finding "sort of" duplicate records - multiple column aggregate??.. HELP

    something with row number will probably get you pretty close to what you are after, so you can still visualize the data:

    anything that is a duplicate (based on what you...

    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!

    December 9, 2011 at 11:13 am

    #1419549

  • RE: Insert Millions of rows into a table at a time

    becasue you mentioned you needed to do this for a datawarehouse, I was assuming you had the ability to adapt an example. I was demoing the concept on how 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!

    December 9, 2011 at 10:13 am

    #1419523

  • RE: Run a stored procedure automatically

    someone with access can backup the database and restore elsewhere as well; people who would detatch and detatch to get the data would simply be those persons who are not...

    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!

    December 9, 2011 at 9:54 am

    #1419513

  • RE: Restrict database access by date range?

    Interesting scenario;

    do you really want to prevent access completely, or should they only have read only access during specific restricted periods?

    if it was read only access, you could use a...

    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!

    December 9, 2011 at 9:01 am

    #1419470

  • RE: selecting only hour and minute from datetime.

    this trick of adding the # minutes to the minimum sql date will trucate to the last minute that occurred:

    select DATEADD(minute, DATEDIFF(minute,0,getdate()), 0)

    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!

    December 9, 2011 at 8:15 am

    #1419407

  • RE: How to run a script to update all 01/01/1900 to null in a date type column?

    Second Place...again 😉

    WTG Cadavre.

    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!

    December 9, 2011 at 7:08 am

    #1419328

  • RE: How to run a script to update all 01/01/1900 to null in a date type column?

    it's just a simple update...

    UPDATE MyTable

    Set MyDateColumn = NULL

    WHERE MyDateColumn ='1900-01-01'

    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!

    December 9, 2011 at 7:07 am

    #1419324

  • RE: Run a stored procedure automatically

    omidshf (12/9/2011)

    can a stored procedure run automatically when data files attach to a database?

    you mean when a database is attached, right? or do you mean when a database 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!

    December 9, 2011 at 6:17 am

    #1419259

  • RE: Insert Millions of rows into a table at a time

    ColumnList was a placeholder for multiple columns, not just a single one;

    I would image that table has half a dizen NOT NULL columns.

    you'll have to sp_help it, understand it's structure,...

    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!

    December 8, 2011 at 1:29 pm

    #1418948

  • RE: Insert Millions of rows into a table at a time

    here's one fast way: to use this code, you HAVE to knwo what table, and which columns you are going to insert.

    insert into TargetTable(ColumnList)

    SELECT

    TOP 400000

    ColumnList

    FROM TargetTable

    CROSS JOIN sys.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!

    December 8, 2011 at 1:13 pm

    #1418941

  • RE: How to bulk assign privilege to all sp to a specific role?

    anthony.green (12/8/2011)

    Sorry Lowell is that to myself or to Halifaxdal?

    wow you guys posted a lot of stuff while i tested my script;

    when i thought i was posting, there were...

    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!

    December 8, 2011 at 9:45 am

    #1418789

  • RE: How to bulk assign privilege to all sp to a specific role?

    how did you test that? did you grant anything to, say a public or other role the user might be in;

    this worked perfectly fine for me:

    --Create the Roles used 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!

    December 8, 2011 at 9:39 am

    #1418778

  • RE: SELECT - LIKE %

    if the column you are searching is a char and not varchar, it might not truely end in LA;

    try WHERE RTRIM(ColumnName) LIKE '%LA' 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!

    December 8, 2011 at 9:28 am

    #1418764

  • RE: Any way of verification

    nope no way to prompt or alert, not without you creating an application to do that for you.

    SSMS executes code, and presents the results...that's the typical applicaiton you might use.

    based...

    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!

    December 8, 2011 at 9:25 am

    #1418760

Viewing 15 posts - 6,241 through 6,255 (of 13,460 total)