Forum Replies Created

Viewing 15 posts - 5,896 through 5,910 (of 13,460 total)

  • RE: Opinion on SQL scripting contract

    I know there sites like rent a coder and stuff where people bid/lowball programming services based on the often poorly defined requirements of a post there. If you have 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!

    February 25, 2012 at 10:07 am

    #1451710

  • RE: Script to find all objects owned by a user (loginname)

    sgtmango333 (2/24/2012)

    Well I tried and couldn't get it to work. So if you know the secret, please share. I spent half a day trying and it kept failing.

    If...

    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!

    February 25, 2012 at 8:42 am

    #1451703

  • RE: Is there a SET based alternative to using CURSOR for adding numbers of user defined and localized error message with sp_addmessage?

    doesn't look like it;

    if you look at sp_addmessage via sp_helptext sp_addmessage,

    you'll see tat besides a boatload of validation, it still calls an internal proc proc a bunch of times for...

    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!

    February 25, 2012 at 8:35 am

    #1451701

  • RE: Identify Logins that are members of a Windows Group

    take a look at this thread from just a day or two ago:

    Windows Group as Login linked to User Login

    I posted some examples of some extended stored procedures 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!

    February 25, 2012 at 8:27 am

    #1451700

  • RE: SQL Command needed ASAP

    eba.seller (2/25/2012)

    I have a SQL database name company and a table named users, what SQL command would I run to get a list of the contents of that table?

    i may...

    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!

    February 25, 2012 at 8:22 am

    #1451697

  • RE: Incrementing a table name

    quick simple example if you are still using that route:

    --build some sample tables

    create table raw4 (id int,somedata varchar(30) )

    create table raw14(id int,somedata varchar(30) )

    create table raw7 (id int,somedata varchar(30) )

    --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!

    February 24, 2012 at 2:43 pm

    #1451615

  • RE: Calling SP through SSMS vs .NET app

    SQL_Surfer (2/24/2012)

    Just calls the sp and shows that results to the grid.

    how is it loading into a grid? DataAdapter.LoadDataTable, then binding the grid to the datatable?

    is it using a sql...

    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!

    February 24, 2012 at 2:37 pm

    #1451610

  • RE: Incrementing a table name

    instead of multiple tables, why not a single table with your 1-19 etc indicators as a column value in that table? wouldn't that be easier to use and maintain?

    why 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!

    February 24, 2012 at 2:24 pm

    #1451601

  • RE: delete file script

    my Google-Fu is strong.

    you can optionally delete to the recycle bin with powershell:

    http://stackoverflow.com/questions/502002/how-do-i-move-a-file-to-the-recycle-bin-using-powershell

    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!

    February 24, 2012 at 12:50 pm

    #1451566

  • RE: SQL 2008 R2 database backup file size tripled overnight without major changes - what is causing it?

    rebuilding the index requires a lot of space...I've heard a rule of thumb as 1.5x the size of the table.

    maybe you rebuilt the indexzes? large overnight ETL?

    from MS:

    http://msdn.microsoft.com/en-us/library/ms191183.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!

    February 24, 2012 at 10:38 am

    #1451513

  • RE: Windows Group as Login linked to User Login

    glad I could help a little bit!

    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!

    February 24, 2012 at 8:53 am

    #1451455

  • RE: TSQL Help

    SQLEnthus (2/23/2012)

    apologize for the formatting, attached a spreadsheet with good formatting

    here you go; this is the best way to provide sample data in the future; anyone who follows the thread...

    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!

    February 23, 2012 at 2:43 pm

    #1451109

  • RE: Bulk Insert - (0 row(s) affected)

    also, it depends on the file format;

    if the original source text file was created in unix, you might need to use \r ( vbCr = CHAR(13)/ Return/Carriage...

    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!

    February 23, 2012 at 6:53 am

    #1450814

  • RE: How to grant permissions to run a specific sql agent job

    sqlfriends (2/22/2012)

    But we have 3 peoples may take turn to run the job.

    And I don't want give them rights to view or run other jobs because this is a production...

    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!

    February 22, 2012 at 2:00 pm

    #1450557

  • RE: Windows Group as Login linked to User Login

    these two extended procs examples might help.

    one tells you who belongs to a group, the other can tell you all the grouls i belong to:

    EXEC master..xp_logininfo

    @acctname =...

    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!

    February 22, 2012 at 1:17 pm

    #1450536

Viewing 15 posts - 5,896 through 5,910 (of 13,460 total)