Forum Replies Created

Viewing 15 posts - 256 through 270 (of 13,460 total)

  • RE: Bulk copy from one server into another server.

    stick with the SSIS wizard and avoid a linked server.
     the SELECT INTO FROM linkedServer... will be a massive logging operation, and you might run out of disk space due...

    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 3, 2019 at 5:29 am

    #2020951

  • RE: Can you add line breaks in stored text?

    yes, i store queries like that in a table, and execute them all the time.
    there are two simple ways, note i had to escape the single quotes within the...

    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 3, 2019 at 5:24 am

    #2020949

  • RE: carriage return in dynamic sql

    grid view always compresses the data to a visible sinlge row, and makes CrLf appear as spaces.
    what you want is to make sure a copy/paste from a grid 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!

    February 2, 2019 at 5:27 pm

    #2020936

  • RE: split data in equal halves

    here is an example, splitting the list of all your tables in your current database, into five columns;

    i think you can adapt that to only have four 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!

    February 2, 2019 at 11:33 am

    #2020930

  • RE: What is the best way allow third-party access to a limited view of your database?

    the issues is object owner chaining.  cross schema or cross database queries break the object chaining inheritance, and require select permissions to teh underlying tables.
    you don't want that, 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!

    January 31, 2019 at 1:06 pm

    #2020764

  • RE: How can I add the server name to the subject line of a SSIS subscription email?

    if you have the enterprise version, Data Driven subscriptions are an option.
    with data driven subscription, you might have a view that has all the info on a per row...

    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!

    January 25, 2019 at 2:50 pm

    #2020178

  • RE: Is sp_send_dbmail Asynchronous?

    here's a  scripts i actually put into views ie (GoodMail and FailMail) by toggling the WHERE statement; very handy for at a glance status of emails.
    so i can review...

    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!

    January 24, 2019 at 9:19 am

    #2019990

  • RE: RPC:Completed in SQL Profile, but the data is not updated

    I would assume that some other process is toggling all rows back to zero, and not that SQL is not updating after it explicitly said it updated/Completed.

    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!

    January 23, 2019 at 7:16 pm

    #2019895

  • RE: What is Alternative of numbered_procedures?

    this link describes numbered procedures fairly well; it is a little used capability that is now deprecated.

    you can have different versions of the same procedure, or even completely...

    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!

    January 23, 2019 at 10:36 am

    #2019846

  • RE: Migrate all user logins

    i've been using a modified version of this script sp_help_revlogin_roles, which scripts logins and some server roles for you for an easier migration:

    https://www.itprotoday.com/strategy/cloning-security-objects-between-servers

    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!

    January 21, 2019 at 2:30 pm

    #2019561

  • RE: Is sp_send_dbmail Asynchronous?

    sp_send_dbmail is asynchronous. the whole process is already a service broker.
    it returns success and an mail_od immediately without actually sending anything, and puts it in a queue.

    the...

    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!

    January 21, 2019 at 12:13 pm

    #2019552

  • RE: Run New PowerShell Process As A Different User

    not sure if this helps.
    Fore security reasons, i never log in as my elevated account, but as a regular account,and spawn applications with the privileged account as needed. via...

    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!

    January 15, 2019 at 3:17 pm

    #2019014

  • RE: SQL getting locked up - Important please help!

    Here's my first suggestion:

    grab a copy of Adam Mechanic's sp_whoisactive and put it in the master database:
    http://whoisactive.com/downloads/

    running a command like this manually will give...

    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!

    January 10, 2019 at 3:06 pm

    #2018640

  • RE: Recommendations for "phasing out" of local SQL backups for NetApp SNAPS

    For Production, NetApp SNAPs cannot do an individual databases point in time restore, can it?
    if they can demo you can rollback to a specific point in time, for one...

    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!

    January 10, 2019 at 12:56 pm

    #2018615

  • RE: security ? for SSAS tabular

    they need to bump up their skillset, and this is your opportunity to help them.
    do not allow SQL connections. period. eventually that password gets passed around and is insecure.

    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 31, 2018 at 12:33 pm

    #2017674

Viewing 15 posts - 256 through 270 (of 13,460 total)