Forum Replies Created

Viewing 15 posts - 796 through 810 (of 13,460 total)

  • RE: Browsing network for SQL instances

    it's a combination of being on the same subnet, and that sql instances that have the SQL browser service running.

    the ODBC drivers poll the network for advertised services.

    you 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!

    December 1, 2016 at 1:36 pm

    #1915576

  • RE: open a SSIS package in design view fro SSIS catalog

    you can download it from the catalog:

    start a new project File>>New>>Project

    make sure you choose Templates>>Business Intelligence>>Integration Services>> Integration Services Import Project Wizard.

    there you can choose the server,a dn then 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!

    November 30, 2016 at 2:12 pm

    #1915285

  • RE: Investigate SQL server Shutdown caused by tempdb maxing out.

    typically something like this is due to an automated process, combined with not a lot of available disk space.

    the dmv's will not be any help, as they are really run...

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

    #1915253

  • RE: Investigate SQL server Shutdown caused by tempdb maxing out.

    i'd say look at the SQL server error log first. see exactly what time, and what errors occurred. the error might point to something obvious.

    compare that to your job schedules;...

    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 30, 2016 at 10:29 am

    #1915237

  • RE: Query required for my scnario

    great job on providing the set up!

    i'm a little unclear on what the rule is for the gracemarks, though;

    if they have a Practical_mark > 30, they get get a 70...

    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 29, 2016 at 6:49 am

    #1914932

  • RE: Free eBook from PacktPub: Getting Started with PowerShell - TODAY ONLY!!!

    darn i missed this one.

    day late, dollar short.

    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 29, 2016 at 6:15 am

    #1914923

  • RE: Find last business day from table with date and day in SQL 2008 and 2012

    duplicate post.

    no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

    the "Recent Posts" link shows us everything.

    continue the thread here:

    http://www.sqlservercentral.com/Forums/Topic1838607-360-1.aspx...

    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 29, 2016 at 6:13 am

    #1914921

  • RE: Find last business day from table with date and day in SQL 2008 and 2012

    A Calendar Table is really handy for this.

    As an Inline calculation

    the way i would tackle it is with DateMath, and a case statement that checks for Saturday or Sunday

    here i...

    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 29, 2016 at 5:38 am

    #1914913

  • RE: DDL event for job changes

    Thomas makes a good paint on the procedures being the way the GUI makes job changes; that means besides triggers, you could also modify the procedures themselves so that they...

    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 27, 2016 at 10:32 am

    #1914637

  • RE: DDL event for job changes

    i think job changes are actually DML changes, and not DDL changes; those are insert/update/delete to the tables in msdb: dbo.sysjobs, dbo.sysjobsteps and dbo.sysjobschedules for example.

    you could put DML triggers...

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

    #1914519

  • RE: Help

    you need a master list of all employees to compare against;

    then you can use an EXCEPT operator and your existing code

    I would stick your results in a temp table,...

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

    #1914094

  • RE: Update column data from Linked Server

    tocy1980 (11/18/2016)

    I have tried this:

    update Server_FINAL

    set Server_FINAL.Parts = [Linked Servers].[DATA STORE LINKED].['ET NEW$'].[Parts Used]

    and it doesn't work.

    Get this error: he multi-part identifier "Linked Servers.DATA STORE LINKED.'ET NEW$'.Parts Used" could not...

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

    #1914092

  • RE: Filter on database name for sqlserver.sp_statement_completed, sqlserver.sql_statement_completed extended events

    yes you can.

    I think in 2012, you had to hand script everything, right?

    i used the 2016 GUI, which shows the GUI filtering criteria , and then scripte dit;

    hope this helps!

    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 22, 2016 at 10:06 am

    #1914059

  • RE: Creating a database is slow based on role held, what am I missing?

    i googled a bit to find reasons SSMS is slow sometimes;

    i see SSMS can sometimes validate some .net packages;

    https://www.virtualobjectives.com.au/sqlserver/ssms_slow.htm

    this one implies a few basics: virus scanners, the default connection type...

    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 22, 2016 at 6:36 am

    #1913975

  • RE: Deployed report and Studio report not matching

    I bet it's a cache in VS.

    visual studio creates a local *.data file with cached data so that it doesn't have to go back and forth to the server 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 21, 2016 at 11:09 am

    #1913821

Viewing 15 posts - 796 through 810 (of 13,460 total)