Forum Replies Created

Viewing 15 posts - 4,516 through 4,530 (of 13,460 total)

  • RE: Linked server using MySQL ODBC 5.1.8

    maria_js (10/24/2012)

    Thank you Lowell 🙂 Your code worked for me.

    excellent! I'm glad you found this thread and the helpful 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!

    October 24, 2012 at 11:30 am

    #1552371

  • RE: batch file script need

    in a bat/cmd file or command prompt, you can get the computer name from the variable %computername%

    echo %computername%

    so you can build a script with that...does that help?

    edit

    also, 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!

    October 24, 2012 at 9:21 am

    #1552327

  • RE: SQLServer port change

    well there is two pieces of the puzzle.

    IF the linked server is using dynamic ports, you need to have the SQl Browser Service running on the linked server. If it'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!

    October 24, 2012 at 8:47 am

    #1552305

  • RE: Amazon cloud connection to SQL Server

    a post here on SSC says one person thinks that error is related to this:

    http://www.sqlservercentral.com/Forums/FindPost1168084.aspx

    The first error message actually looks a lot like the dynamic packet sizing (autotuning) in Windows...

    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!

    October 24, 2012 at 6:29 am

    #1552229

  • RE: Update in all table

    you could build the queries you want to execute for all tables meeting your criteria.

    if the table has a value in the UpdateBy column, are you trying to set...

    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!

    October 24, 2012 at 6:14 am

    #1552224

  • RE: Issue in using loopback linked server

    the error is pretty straight forward; it could not find the table in the database. maybe when you abstracted it out, you hid the issue.

    do you Really have a 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!

    October 23, 2012 at 3:14 pm

    #1552086

  • RE: sp_trace_getdata SP

    sp_trace_getdata is used by SQL Profiler to read it's trace and return the results to the SQL Profiler GUI/application;

    SQL Profiler is definitely known to have an impact on SQL server...it...

    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!

    October 23, 2012 at 2:49 pm

    #1552073

  • RE: HMAC-SHA256 or HMAC-SHA1 using private key

    Sreejith Sreedharan (10/23/2012)

    Thanks for the email. Based on my searches thats what I came across too. Do you know of any one who has created this as CLR function? May...

    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!

    October 23, 2012 at 12:43 pm

    #1552043

  • RE: HMAC-SHA256 or HMAC-SHA1 using private key

    Looks like you'll have to use a CLR routine.

    i grabbed this function in vb.net from Google, you'd have to convert it to a CLR function from there.

    source:http://stackoverflow.com/questions/7515164/visual-basic-2010-hmac-sha1

    edit: here's the converted...

    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!

    October 23, 2012 at 12:36 pm

    #1552041

  • RE: HMAC-SHA256 or HMAC-SHA1 using private key

    Sreejith Sreedharan (10/23/2012)

    Has any one encrypted data using HMAC-SHA1 or HMAC-SHA256 encryption method. I need this done for the current project that I am working and am unable to find...

    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!

    October 23, 2012 at 11:47 am

    #1552026

  • RE: Create and populate a Zip file

    OTF (10/23/2012)

    This problem could probably be more "cleanly" solved with a CLR object.

    Happy to help you knock one up if you'd like to go that route.

    That would be a valuable...

    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!

    October 23, 2012 at 9:10 am

    #1551968

  • RE: Create and populate a Zip file

    jim if you print the variable results, you'll see there's a quote in the wrong place.

    "C:\Documents and Settings\jamesshaffer\My Documents\7-Zip\7za.exe" a "F:\mtv\secure\Construction\Access\All Database Backup\2012-Oct_Backup\"12-10-23.zip F:\mtv\secure\Construction\Access\CPAS

    i've corrected your vbs code below 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!

    October 23, 2012 at 6:04 am

    #1551852

  • RE: Is it possible to execute an encrypted SQL script with SQLCMD?

    here's one way i've seen here on the forums to obfuscate a script that is to be deployed:

    -- obfuscate a command to send to the client:

    Declare @cmds Nvarchar(MAX)

    Declare @obfoo varbinary(MAX)

    --build...

    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!

    October 23, 2012 at 5:51 am

    #1551845

  • RE: Parsing out email address in FROM field

    forme, a CTE that pulls out the charindexes makes it easier for me to understand.

    With tblDoc([FROM])

    AS

    (

    SELECT 'John Doe1 <John.Doe1@abcd.com>' UNION ALL

    SELECT 'John Doe2 <John.Doe2@abcd.com>' UNION ALL

    SELECT 'John Doe3 <John.Doe3@abcd.com>' UNION...

    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!

    October 22, 2012 at 1:06 pm

    #1551600

  • RE: Open microsoft outlook by clicking field on SSRS report

    leefuji (10/22/2012)

    Hi,

    What is the command for BCC and CC , I tried MailCC or MailBCC and it didn't work.

    Thanks

    http://webdesign.about.com/od/beginningtutorials/a/aa041700b.htm

    code example:

    <a href="mailto:firstEmail@email.com, SecondEmail@email.com?bcc=TheBlidRecipient@email.com& cc=thirdaddress@email.com&subject=heres%20The%20Info%20You%20Asked%20For"> Click me!</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!

    October 22, 2012 at 12:08 pm

    #1551575

Viewing 15 posts - 4,516 through 4,530 (of 13,460 total)