Forum Replies Created

Viewing 15 posts - 2,911 through 2,925 (of 13,460 total)

  • RE: how to reset SA password

    i found this bat file from microsoft which is pretty much bullet proof:

    it adds the current user as an administrator to the sql server that is prompted in the 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!

    November 20, 2013 at 6:28 am

    #1667776

  • RE: Pushing inserts into SQL server with C# ?

    bulk insert into a single table is incredibly fast. switching away from INSERT statements being generated to sticking the data into a local DataTable, and either syncronizing the changes or...

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

    #1667760

  • RE: Linked server/ very restricted access

    Beatrix Kiddo (11/20/2013)

    We have a user who has access to just one view on one database, and he needs to create a linked server from his database to that view....

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

    #1667754

  • RE: Bulk Inserts using a variable

    you have to switch to dynamic SQL for the whole thing, when you try to parameterize BULK INSERT; it only accepts static strings, and not variables.

    DECLARE @sql varchar(8000)

    --bulk insert won'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 19, 2013 at 2:55 pm

    #1667601

  • RE: SQL Logins output to a file via sp_help_revlogin

    easy fix for you guys.

    I assume you went to this page and downloaded the procedures from Micorsoft:

    http://support.microsoft.com/kb/918992

    from there, all you really need to do is modify the code, so 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 19, 2013 at 1:58 pm

    #1667578

  • RE: How to insert data into table from linked server

    my personal rule of thumb, based on my own experiences, is that if a table has more than 50K rows, i'd rather use SSIS (or The Import/Export Wizard, technically still...

    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 19, 2013 at 1:24 pm

    #1667565

  • RE: How to insert data into table from linked server

    the openquery for a simple select is what you are after, it's just what you do witht eh results(sticking them into your local table instead of displaying)

    INSERT INTO...

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

    #1667548

  • RE: Migrate from SQL 2005 to SQL 2008 -- Pre/Post Migration Steps?

    rebuilding the indexes updates the statsitics for the columns of the indexes, but not all the statistics for the given table.

    statistics on non indexed columns let the query engine...

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

    #1667546

  • RE: How to find whether an object is used by any sp , view ?

    Ed Wagner (11/19/2013)

    I may be remembering incorrectly, but if you use dynamic SQL in your procedures, the dependency might not show up in the list. If you find that's...

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

    #1667518

  • RE: what will be the best delimiter for bcp file? Dont want to use , |,^. Any suggestion will be appreciated

    don't limit yourself to think it must be a single char.

    i export stuff like html in and out all the time; as a result, i use multi character delimiters 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 19, 2013 at 11:25 am

    #1667516

  • RE: Migrate from SQL 2005 to SQL 2008 -- Pre/Post Migration Steps?

    just a few things i'd throw in there, but it sounds like you've got it covered pretty well.

    Post-Migration, make sure you rebuild statistics for all tables, in each database with...

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

    #1667509

  • RE: Schedule a SQL Job only for the first ten working days of each month

    d.velders (11/19/2013)

    It's indead an idea to generate a SP that does the calculation of these working days.

    Does anyone have an example on how to do this or even better 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!

    November 19, 2013 at 8:35 am

    #1667437

  • RE: Create Table Default Data Type Length

    the default length is 1.

    when you use cast or convert, the default length is 30, but for column definitions, it's a single character.

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

    #1667414

  • RE: How to find whether an object is used by any sp , view ?

    this seems to work for me;

    I had this saved in my snippets:

    SELECT depz.referenced_schema_name,

    depz.referenced_entity_name,

    objz.type_desc,

    ...

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

    #1667402

  • RE: problem with new query ...

    with the data you posted, everything is older than 40 months, so i assume the item has no official value any more; i added one example to the sample data.

    so...

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

    #1667394

Viewing 15 posts - 2,911 through 2,925 (of 13,460 total)