Forum Replies Created

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

  • 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

  • RE: how to do Automated restore script for UAT refresh for all the Database

    pretty loose on the details.

    do you have to copy the backup(s) from somewhere to the UAT server now?

    do you have the current backup(s) scripted out already so you can 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!

    February 22, 2012 at 11:23 am

    #1450470

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