Forum Replies Created

Viewing 15 posts - 1,306 through 1,320 (of 13,460 total)

  • RE: Mitigating STIGs

    hope that helps;

    in the article a mentioned, search for DATABASE_OBJECT_CHANGE_GROUP , as i think that is the audit spec you are looking for;

    I think that section, complete with screenshots, can...

    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 11, 2016 at 2:01 pm

    #1851132

  • RE: Mitigating STIGs

    michael.k.choffy (1/11/2016)

    Hi Jeff,

    Thanks for the quick response! There are three that I have been struggling with, V-41403, V-41404, V-41406. They all have to do with "SQL Server must...

    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 11, 2016 at 1:20 pm

    #1851112

  • RE: How to Build Inventory Server

    New persopn (1/11/2016)

    If we have multiple networks how it will capture. In our environment we have multiple domains and networks.

    it is an extremely robust solution. it has half a dozen...

    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 11, 2016 at 12:59 pm

    #1851104

  • RE: How to Build Inventory Server

    New persopn (1/11/2016)

    Using this Toolkit can we monitor and maintain multiple servers.

    it literally scans the entire network for all types of devices; it just happens to have a checkbox 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!

    January 11, 2016 at 11:40 am

    #1851076

  • RE: How to Build Inventory Server

    also, if you run the Microsoft Assessment and Planning Toolkit, instead of letting it create a default (localdb)\maptoolkit, you could have it create databases in your CMS server; it 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!

    January 11, 2016 at 11:27 am

    #1851070

  • RE: SSMS: First connection to DBMS takes over 15 minutes

    this thread seems to have the same issue:

    DNS

    http://dba.stackexchange.com/questions/104378/sql-server-management-studio-slow-connection-or-timeout-when-using-windows-authe

    Certificates?

    http://superuser.com/questions/7247/why-does-it-take-so-long-for-sql-management-studio-to-connect

    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 8, 2016 at 10:38 am

    #1850601

  • RE: SQLPS Meets the DMV's

    Nice contribution, but a little too brief of an article for me ; i'd hope to see something like what the purpose of the script is and how it would...

    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 8, 2016 at 10:25 am

    #1850591

  • RE: ideas for file import and process

    you could also use a simple ForEach Loop Container, and have the Files us a pattern -"In-force for Sales and Client Services*.txt"

    inside the loop you could have something conditional 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!

    January 8, 2016 at 10:22 am

    #1850589

  • RE: SSMS: First connection to DBMS takes over 15 minutes

    if you connect via IP address instead of server name, is it near-instant? maybe it's still networking/dns?

    how about fully qualified instead of WINS name?

    ie connecting to 10.40.10.100 or SQLProd.Yourdomain.local or...

    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 8, 2016 at 10:02 am

    #1850577

  • RE: SSMS: First connection to DBMS takes over 15 minutes

    since you are restarting the instance, and it takes a long time, i'd say it's because the databases are not coming on line quickly.

    the first thing i would check 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!

    January 8, 2016 at 9:10 am

    #1850561

  • RE: SSIS query produces different results over the day.

    what do you mean by varying results ? is the data the SSIS touches absolutely static(ie a staging table only you touch, with no joins to other data), or are...

    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 8, 2016 at 9:02 am

    #1850558

  • RE: Unable to remotely access SQL server.

    CELLIOTT-497809 (1/8/2016)

    Verified with 2 other users and they are getting the same error. One of the users was a Domain admin account. BTW... I forgot to add 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 8, 2016 at 7:34 am

    #1850527

  • RE: Unable to remotely access SQL server.

    CELLIOTT-497809 (1/7/2016)

    I have a SQL 2012 Server that I am not able to access from my workstation using SQL MGMT Studio with my Active Directory username. However, I am...

    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 7, 2016 at 2:47 pm

    #1850358

  • RE: executing dynamic DDL for each object in my database...

    just to confirm, there is no way to cross apply and execute RBAR style;

    since you mentioned you had a procedure you want to call, you could modify or copy procedure...

    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 7, 2016 at 11:45 am

    #1850298

  • RE: executing dynamic DDL for each object in my database...

    using cursors or loops to generate commands that pull from metadata related to objects are what i consider the exception to the general rule of avoiding cursors/loops.

    the avoid cursor rule...

    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 7, 2016 at 11:07 am

    #1850279

Viewing 15 posts - 1,306 through 1,320 (of 13,460 total)