Forum Replies Created

Viewing 15 posts - 1,081 through 1,095 (of 13,460 total)

  • RE: Run/create a query/datasource to Central Management Server query in SSRS

    i put together this prototype;

    basically, for every SQL server in msdb.[dbo].[sysmanagement_shared_registered_servers_internal], i'm creating a linked server for it, and passing commands;

    my example is just running a fancy @@version++ inventory...

    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!

    May 3, 2016 at 12:20 pm

    #1876381

  • RE: Alternating weekly schedule

    two ideas.

    can you just use two jobs, one scheduled to start on Saturday, and repeat each two weeks?

    can you use a datemath and inline logic within the job step 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!

    May 3, 2016 at 12:13 pm

    #1876376

  • RE: Creating a View in Another Database Using OpenQuery

    imani_technology (5/3/2016)

    Thanks. Will this work if the linked server is NOT a SQL Server database?

    if the command is compliant with the other DBMS (mysql, oracle, etc,) then yes.

    the ODBC...

    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!

    May 3, 2016 at 11:31 am

    #1876360

  • RE: xp_logininfo gives error while trying to fetch group info

    some groups cannot be enumerated , I've seen that on my AD, where we have two forests of AD accounts with two way trusts.

    I've found we've got a groups with...

    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!

    May 3, 2016 at 11:25 am

    #1876358

  • RE: Local admin rights

    if you are local admin, you probably want to do a takeover of the server,

    then i believe you can at least add yourself via a dedicated admin connection...

    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!

    May 3, 2016 at 9:56 am

    #1876300

  • RE: Which Stored Procedure changed

    Tac11 (5/3/2016)

    Hi Lowell,

    in the result header there are 2 columns 'date' and 'Start_time' what are these can you put specific column name? plus if I want to filter by date...

    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!

    May 3, 2016 at 6:59 am

    #1876208

  • RE: Issue while fetching data on execution of stp

    since you don't have the error yet, i'm leaning towards checking things that are different in the other environment, like ANSI_NULLS and QUOTED_IDENTIFIER.

    maybe the procedure was compiled or is running...

    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!

    May 3, 2016 at 6:19 am

    #1876183

  • RE: Create After Update Trigger that Updates a Column in a table based on an Update in Another. Table

    i would add dates and whodunnit information to the history table as well. From what you have show so far, you cannot tell when it occurred, which could be important,...

    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!

    April 29, 2016 at 11:47 am

    #1875672

  • RE: Using reserved words as column names

    j-1064772 (4/29/2016)

    Sioban Krzywicki (4/28/2016)

    I keep trying to convince people that the most secure database would be one where they can't use alphanumeric table and column names. I created one that's...

    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!

    April 29, 2016 at 8:50 am

    #1875606

  • RE: Unable to connect named instance through VPN

    SQL!$@w$0ME (4/29/2016)

    Hello guys,

    I can't connect to a named instance(TCP/IP) through VPN connection. But I can connect to the default instance(TCP/IP) [highlight="#ffff11"]on the same server[/highlight] through VPN.

    The named instance 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!

    April 29, 2016 at 8:46 am

    #1875603

  • RE: DML Quries are taking long time to execute

    it's not a one line fix; performance and query tuning and analysis, a have entire books written on the subject.

    in general, my knee jerk reaction would be to update statistics...

    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!

    April 29, 2016 at 6:48 am

    #1875549

  • RE: Looking to "hack" the "Script As DROP"

    just the drops scripts are pretty easy, you can just build the statements from sysjobs;

    select

    'IF EXISTS (SELECT job_id FROM msdb.dbo.sysjobs_view WHERE name = N''' + name + ''')

    EXEC...

    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!

    April 29, 2016 at 6:38 am

    #1875547

  • RE: Using reserved words as column names

    Sioban Krzywicki (4/28/2016)

    I keep trying to convince people that the most secure database would be one where they can't use alphanumeric table and column names. I created one that's all...

    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!

    April 28, 2016 at 1:04 pm

    #1875384

  • RE: Using reserved words as column names

    Sioban I'm with you here!

    I try like crazy to make everyone replace reserved words, as well as fixing misspelled columns i inherited.

    I have a column ProvdierType that makes me crazy,...

    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!

    April 28, 2016 at 12:48 pm

    #1875375

  • RE: t-sql 2012 change query

    CTE's would work, as well as subqueries(same thing,really , just different format.

    here's my version of your post as CTE's:

    DECLARE @personID INT = 123999;

    WITH ELDASummary

    AS (SELECT...

    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!

    April 27, 2016 at 6:11 pm

    #1875123

Viewing 15 posts - 1,081 through 1,095 (of 13,460 total)