Forum Replies Created

Viewing 15 posts - 286 through 300 (of 13,460 total)

  • RE: Trigger on saving a stored procedure or function.

    ok, this looked fun, so i combined and modified a couple of techniques:

    DROP TRIGGER TR_PopulateExendedEventOnEachObject
    ON DATABASE
    GO
    --Our Trigger to limit our role:
    CREATE...

    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 14, 2018 at 10:07 am

    #2013508

  • RE: Login sa failed

    i think the [Domain\dbc_agent] login issue the query finds is a separate issue than the process logging in as sa, i would look at the Error/Severity columns to confirm.

    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 9, 2018 at 1:39 pm

    #2013028

  • RE: Login sa failed

    you could run it from any machine on the network, so no difference; DNS is DNS from any machine.
    the IP resolves to some server name, which i think 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!

    November 8, 2018 at 3:21 pm

    #2012915

  • RE: Login sa failed

    using ping -a will return the machine name, i like it better than nslookup..
    then you can check the machine itself for either applications, or windows tasks, or even 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 8, 2018 at 3:09 pm

    #2012912

  • RE: Parameterize connection manager

    Yes, I do something exactly like that against my own CMS servers.

    I create a SQL connection manager, and in expressions, I point the servername property to a user...

    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 5, 2018 at 10:52 am

    #2012429

  • RE: Need to change the connection string because the app is pointing to an old server

    if there is no server name, then it is implied that the database exists on the local server; is that how it was set up originally? if you can find...

    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!

    October 19, 2018 at 12:16 pm

    #2010464

  • RE: Need to change the connection string because the app is pointing to an old server

    Classic ASP often made use of include files, so as Sue_H suggested, you just need to search the files for the database/server name and zoom in on possible locations to...

    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!

    October 18, 2018 at 12:38 pm

    #2010290

  • RE: Talking about SARG

    Brandie I've always done something like this to keep it Sarg-able; does that help? it's an OR, i know, but it would allow indexes to be used if they exist...

    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!

    October 15, 2018 at 9:29 am

    #2009635

  • RE: Windows Reboot time in sys.dm_os_sys_info does not match systeminfo

    ok  more info for everyone.
    I scanned all 100+ sql instances in my Central Management Servers.
    I have seven servers that have a variance of over one day. one is...

    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!

    October 10, 2018 at 2:42 pm

    #2008952

  • RE: Windows Reboot time in sys.dm_os_sys_info does not match systeminfo

    That is the funny part of this dilemma Sue;
    I also found references that systeminfo can be incorrect.
    in this case, it is the value from sys.dm_os_sys_info that is incorrect.

    these...

    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!

    October 10, 2018 at 1:40 pm

    #2008934

  • RE: Using Central Management server to schedule and email report on failed jobs.

    here's an explicit string array declaration example for powershell:
    MyServers=@("VMSQL01","VMSQL02\SQL2016","AnotherSrver\ETL")

    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!

    October 1, 2018 at 1:32 pm

    #2007587

  • RE: Using Central Management server to schedule and email report on failed jobs.

    it's not a one line query, unfortunately.
    SSMS opens a query to each server, executes it, and aggregates the results.
    You will have to do the same, and it's 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!

    October 1, 2018 at 8:38 am

    #2007516

  • RE: SSIS Package to exec multiple SPs stored in a table

    I do something similar, where i loop through a table full of queries, execute them on a server, and capture the results in a dataset, which is then pumped out...

    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!

    September 24, 2018 at 3:24 pm

    #2006833

  • RE: Replacement of role db_owner

    ALTER ANY DATABASE expects a [login] as the target, and not a database(user) role.

    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!

    September 24, 2018 at 7:56 am

    #2006738

  • RE: SQL Server stored procedures fast in SQL but slow when called by ASP.NET

    don't forget the basics: make sure you've added SET NOCOUNT ON at the  top of your procedure, as well as commenting out any PRINT statements.
    those add some added overhead...

    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!

    September 24, 2018 at 7:53 am

    #2006736

Viewing 15 posts - 286 through 300 (of 13,460 total)