Forum Replies Created

Viewing 15 posts - 706 through 720 (of 13,460 total)

  • RE: Decommissioning SQl 2005 server

    whenever i do a SQL consolidation, i actually stop the SQL Service on the old machine afterwards, and see who complains that they cannot connect anymore, so I can 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!

    January 10, 2017 at 7:58 am

    #1921629

  • RE: How to write a string to a file in SQL.

    this knowledge base from MS says that support for bcp.exe to use UTF-8 was added to SQL2014 in service pack 2, so if you are in SQL2012, i think you'll...

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

    #1921609

  • RE: Access Violation Exception when starting SSMS 2012

    does the issue go away if you run it in administrator mode instead? Right click...run as administrator?

    I've seen that same error before in places where permissions were locked down pretty...

    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 9, 2017 at 4:06 pm

    #1921506

  • RE: Server and Agent Icon in Object Explorer Not Showing Status

    When it is blank white circles, it is specifically telling you that you do not have permissions to start and stop the service (where the MSSQL or the SQL Agent)

    if...

    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 9, 2017 at 1:30 pm

    #1921486

  • RE: Query Assistance

    here's my first pass, does this do what you are asking?

    SELECT distinct jobnbr,tasknbr

    FROM (

    --do not have a JPRE or JPOS route,

    SELECT * FROM #JobRoutes WHERE jobnbr NOT IN(SELECT jobnbr FROM...

    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 4, 2017 at 1:58 pm

    #1920759

  • RE: Trigger isn't firing

    New Born DBA (1/4/2017)

    Can someone explain why the @@ROWCOUNT = 0 statement was causing the problem with the trigger.

    it's not that intuitive, but you have to remember that...

    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 4, 2017 at 1:21 pm

    #1920750

  • RE: Extended Events

    yes there is Jim!

    i had worked diligently on this same issue, and put together a pretty good version code base that creates a script by reading the metadata, to 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 4, 2017 at 12:12 pm

    #1920734

  • RE: How to parse numbers out of text string

    This is what i slapped together to get started: i figured strip out anything Alpha might work, and preserve numbers, spaces and math symbols? but one of your examples had...

    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 4, 2017 at 10:03 am

    #1920684

  • RE: Dilbert Termination Notice Strip

    i found it: it's from Friday January 07, 1994

    about halfway down on tis search:

    http://dilbert.com/search_results?terms=Opportunity

    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 4, 2017 at 8:11 am

    #1920634

  • RE: SSMS 2016 Settings being lost

    Thom I had the same issue with some of the earlier versions of SSMS2016; in my case, my settings(which are stored in %appdata%\Microsoft\SQL Server Management Studio\13.0\SqlStudio.bin)

    would reset, lose previous history,...

    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 4, 2017 at 5:44 am

    #1920581

  • RE: Create TAB delimited file using BCP cmd line

    Lord Slaagh (1/3/2017)

    Hello,

    I am trying to export data from our staging environment to a .txt file on my local machine. I am using CMD Prompt for this. When I execute...

    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 3, 2017 at 2:34 pm

    #1920510

  • RE: restoring database in sql server 2012

    ATTACH is for an db1.MDF/db1.LDF pair of files.

    what you need to do is RESTORE the database from a file.

    http://www.mytechmantra.com/LearnSQLServer/How-to-Restore-Database-SQL-Server-P1.html

    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 3, 2017 at 2:30 pm

    #1920507

  • RE: db_Mail Syntax error message when attempting to pass variable to @Body

    the variable assignments CANNOT be a calculation. it has to be a variable or static string.

    below you are appending things together.

    @Body = '**** This is an automated email - Please...

    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 3, 2017 at 2:09 pm

    #1920496

  • RE: Unable to view full SSRS portal

    browse to http://127.0.0.1/Reports instead!

    that is the web page interface that you are expecting.

    http://127.0.0.1/ReportServer is the deployment target, so it shows up as a directory listing.

    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 3, 2017 at 12:49 pm

    #1920467

  • RE: SSMS 2016 / Windows 10 / Multiple Desktops

    I use the free applciaiton Dexpot(http://dexpot.de/?lang=en) to manage multiple desktops, instead of anything that is built in. i use it in both Win10 at home and Win7 at work.

    Using that...

    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 3, 2017 at 12:41 pm

    #1920462

Viewing 15 posts - 706 through 720 (of 13,460 total)