Forum Replies Created

Viewing 15 posts - 6,046 through 6,060 (of 13,460 total)

  • RE: Determining where or how a connection is being made to SQL

    C# Screw (1/19/2012)

    This sounds interesting Lowell,

    I don't know how to add an IP address, but I think have seen you can get SQL to listen on multiple different ports.

    So 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 19, 2012 at 9:35 am

    #1436002

  • RE: Determining where or how a connection is being made to SQL

    hostname returns the machine name of the client;

    i think he wanted to know if the client resolved the server address, for example as 192.168.1.200 as MyDB.MyFirm.co.uk vs OldServerName vs oldServername.MyFirm.co.uk

    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!

    January 19, 2012 at 8:50 am

    #1435935

  • RE: Script out Jobs & Logins Master DB

    I'll look for or create a script for linked servers;

    the problem is the credentials for the remote user, if you identify one, cannot be scripted out, because they are part...

    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 19, 2012 at 8:16 am

    #1435900

  • RE: Is there an accurate script for datediff format in years:months:days?

    thanks drew;

    it's actually inaccurate in a lot of other situations too, depending on the range between the two dates; that date -1 stuff works just for the date supplied in...

    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 19, 2012 at 7:56 am

    #1435876

  • RE: Automating a "create all jobs" script

    OLDCHAPPY (1/19/2012)

    i get a boatload of errors with that script in SQL2008. 🙁

    the code from the post is filled with CHAR(160) instead of spaces; it was used to mainiian formatting...

    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 19, 2012 at 7:52 am

    #1435868

  • RE: DECRYPTSP2K Issues in 2008

    ok a correction. it's more than just the DAC, as i just double checked to make sure my post was correct.

    you need to connect via DAC, and then use 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 19, 2012 at 7:08 am

    #1435816

  • RE: DECRYPTSP2K Issues in 2008

    easiest way is to simply connect via the DAC: Dedicated Admin connection.

    procs are not encrypted when connecting via the DAC.

    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 19, 2012 at 6:29 am

    #1435776

  • RE: what it should return max(name)?

    it would return strings that start with the highest ascii value;

    i would expect it to return a string that starts with the letter "z" if it existed, and if there...

    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 19, 2012 at 6:10 am

    #1435763

  • RE: db link access

    newbieuser (1/18/2012)

    Thanks a lot.

    Another question, when the users run a select on the Oracle table via linked server from SQL db, will there a lock created in the sql...

    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 19, 2012 at 5:20 am

    #1435745

  • RE: SSMA and SYSDB

    did you migrate your data into the [sysdb] instead of a different database?

    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 19, 2012 at 4:10 am

    #1435718

  • RE: SSMA and SYSDB

    five_ten_fiftyfold (1/19/2012)

    We have a system that has been ported from Oracle using SSMA. I can find very limited info about permissions for the SYSDB database. I've noticed that there 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 19, 2012 at 3:49 am

    #1435713

  • RE: SQL SERVER(T-SQL)

    when you have a result set where the order matters, you must have an ORDER BY clause; in your example, you'd need an additional column that you want to order...

    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 19, 2012 at 3:40 am

    #1435708

  • RE: What is the safest less risky way to move System Databases to another Server?

    for the scripting of jobs and linked servers, look in the script section here; there's several that do a great job there;i haven't done it in a while, so 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!

    January 18, 2012 at 6:09 pm

    #1435619

  • RE: "Scrollable" list on the page

    all Reporting services is is a front end for generating html from your data; there's no built in ScrollableArea object, so you'll have to expand your boundaries a little bit...

    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 18, 2012 at 6:01 pm

    #1435616

  • RE: bulk insert from csv file and physical order

    mymistake, it's the TABLOCK option that prevents parallellism for BULK INSERT:

    BULK INSERT BULKACT FROM 'c:\Export_o.txt'

    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!

    January 18, 2012 at 1:55 pm

    #1435497

Viewing 15 posts - 6,046 through 6,060 (of 13,460 total)