Forum Replies Created

Viewing 15 posts - 166 through 180 (of 13,460 total)

  • Reply To: SQL job runs fine alone but fails when added to larger job

    i might consider checking the  ansi and date_format sessions settings for default dates, as they could be different on the server, running as an agent , vs running in SSMS

    ie...

    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!

    August 27, 2019 at 8:55 pm

    #3674866

  • Reply To: Alert me Export table data to .MSG file using Stored Procedures or any plugin ?

    without using .NET, then no, the specific file extension *.msg ends up requiring C# to do something like this, since the msg is a binary file:

    you could save as text...

    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!

    August 26, 2019 at 12:04 am

    #3674286

  • Reply To: SSIS adding new columns to existing table

    qadding the columns them selves is just a DDL operation. you would not need to do that inside SSIS.

    ALTER TABLE ADD Column1 varchar(etc...

    i suspect you mean what about the data...

    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!

    August 25, 2019 at 11:44 pm

    #3674285

  • Reply To: business intelligence development studio(Bids)

    BIDS is the older version for SSIS development from SQL2005 to SQL2008R2

    in 2012 and Above, BIDS had a name change to SSDT(SQL Server Data Tools). it is basically the same...

    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!

    August 25, 2019 at 11:33 pm

    #3674284

  • Reply To: How can I convert %5B and %5D to [ and ] in a string

    i think this will fix just two items though; won't he have continued issues when he discovers %20 or other url encoded values?

    i would think  we need to consider all...

    • This reply was modified 6 years, 9 months ago by Lowell.
    • This reply was modified 6 years, 9 months ago by Lowell.

    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!

    August 23, 2019 at 8:13 pm

    #3674082

  • Reply To: Backing up a database named update

    that reminds me of one of those bad practice examples i wrote, to show how confusing keywords as object names could be.

    IF NOT EXISTS(SELECT 1 FROM sys.databases...

    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!

    August 23, 2019 at 3:38 pm

    #3674005

  • Reply To: User datareader access problem

    can you try EXECUTE AS LOGIN='domain\user' instead of execute as user, and execute from , say the master database as the context?

    can you duplicate the user error then?

     

    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!

    August 22, 2019 at 3:19 pm

    #3673625

  • Reply To: User datareader access problem

    it sounds like you might have removed public permissions from the server,and specifically in master? could that have happened?

    if the end user is using something like SSMS, they typically get...

    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!

    August 21, 2019 at 8:43 pm

    #3673304

  • Reply To: disable CEIP

    i wrote/modified/collected some powershell scripts to disable various group policies or services that are related to CEIP and other unnecessary services.

     

    I hope this helps.

     

    ###################################################################################################
    ##disable cortana 
    ###################################################################################################
    New-Item -Path...

    • This reply was modified 6 years, 9 months ago by Lowell.

    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!

    August 20, 2019 at 4:13 pm

    #3672844

  • Reply To: How to get the list of login accounts logged in over specific period of time

    Unfortunately, unless you have set something up previously, this is not possible. No default setting captures that level of information, as the log would probably exceed the database size.

    also, no-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!

    August 13, 2019 at 4:54 pm

    #3671104

  • Reply To: How to run package (catalog) from PowerShell with Environment variable in DTExec

    dtexec /Server "SERVER-INSTANCE" /envreference "DEV" /isserver "\SSISDB\Sample\Sample\pkg_Sample.dtsx" /par "$ServerOption::SYNCHRONIZED(Boolean)"

     

    the red part i highlighted is the definition, and not the value, isn't it?

    i think it is supposed to actually also...

    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!

    July 23, 2019 at 10:04 am

    #3665316

  • Reply To: how to get 0 if records have empty or null values when column datatype is numeri

    your issue is ISNULL and implicit conversions.

    ISNULL(NumericColumn,'') fails because numeric column can never be empty string  (the value of '')

    the isnull function is attempting to cast the varchar value of...

    • This reply was modified 6 years, 10 months ago by Lowell.

    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!

    July 23, 2019 at 9:54 am

    #3665314

  • Reply To: Error: 17892 Severity: 20 State: 1

    are you sure you are sysadmin on the server? the error implies either the spelling of the trigger is incorrect, or you do not have permissions.

     

    if you have view any...

    • This reply was modified 6 years, 10 months ago by Lowell.

    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!

    July 21, 2019 at 2:44 pm

    #3664867

  • Reply To: Error: 17892 Severity: 20 State: 1

    on the SQL server itself, someone has created a logon trigger on all server.

    that trigger is preventing the login...it might be doing it on purpose, or it might be an...

    • This reply was modified 6 years, 10 months ago by Lowell.
    • This reply was modified 6 years, 10 months ago by Lowell.

    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!

    July 21, 2019 at 11:12 am

    #3664840

  • Reply To: Configuring HTTP access for Analysis Services: Web server

    looks like although it has a lot of moving parts to set it up, there's a decent article from Ms to help with the walk through:

    this link is for SQL2017,...

    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!

    July 19, 2019 at 4:18 pm

    #3664578

Viewing 15 posts - 166 through 180 (of 13,460 total)