Forum Replies Created

Viewing 15 posts - 11,116 through 11,130 (of 13,460 total)

  • RE: Oracle Linked Server

    ive always used the oracle driver from the client install, but the previous poster is right...you might need to install the driver first:

    SET @provider = N'ORAOLEDB.Oracle' --optionally 'MSDAORA' to use...

    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!

    May 11, 2009 at 7:01 am

    #992065

  • RE: SSIS - How to Set Output column width to varchar(max)

    behind the scenes, the length is set to -1 for the column in syscolumns. can you set the width to -1 instead of 8000?

    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!

    May 11, 2009 at 6:58 am

    #992060

  • RE: Text editor to copy n lines after occurence of search pattern

    raw text or RTF? editplus can do that easily to raw text,you just set a macro to search for a term to find the start, then make it select while...

    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!

    May 10, 2009 at 3:20 pm

    #991838

  • RE: Audit script

    within a trigger, there is a couple of functions you can use you can use to determine if a column has changed:

    IF (UPDATE(columnname) ) returns true or false, if you...

    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!

    May 10, 2009 at 6:01 am

    #991771

  • RE: Inserting into variable no. of columns

    are the columns in the spreadsheet in the same order as the columns in the dataset?

    what i mean is, if the spreadsheet has 10 columns today, and 14 columns tomorrow,

    do...

    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!

    May 10, 2009 at 5:31 am

    #991770

  • RE: Database mail not sending Reply email to multiple recepients

    not on the screens you were setting up; that set up the profile, where it is only one account.

    if you want replys to any email to go to multiple persons,...

    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!

    May 10, 2009 at 5:15 am

    #991768

  • RE: Restore a DB from SSMS always works fine, but...

    just checking the basics...the connection string your program is using is connecting to master database and not the database you are trying to restore right? if it connects to teh...

    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!

    May 9, 2009 at 4:38 pm

    #991687

  • RE: Restore a DB from SSMS always works fine, but...

    just checking the basics...the connection string your program is using is connecting to master database and not the database you are trying to restore right? if it connects to teh...

    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!

    May 9, 2009 at 4:30 pm

    #991686

  • RE: How can I get an Execution Plan into a table column?

    doh! that was it! thank you Gail, and thank you Barry for a handy snippet to add to my collection.

    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!

    May 8, 2009 at 9:56 am

    #991246

  • RE: How can I get an Execution Plan into a table column?

    RBarryYoung (5/8/2009)

    Looks like I answered my own question. The following seems to work fine:

    Declare @qp as XML

    SELECT @qp = query_plan

    From sys.dm_exec_requests

    Cross Apply sys.dm_exec_query_plan(plan_handle)

    Where session_id =...

    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!

    May 8, 2009 at 9:43 am

    #991234

  • RE: Trigger for updating date ?

    if the trigger does not exist, you can't ALTER it..change to CREATE TRIGGER.....

    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!

    May 8, 2009 at 8:47 am

    #991161

  • RE: Trigger for updating date ?

    my WAG on the column name was perfect!

    change that last line to this:

    WHERE tblPerson.PersonID = INSERTED.PersonID

    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!

    May 8, 2009 at 8:31 am

    #991134

  • RE: Trigger for updating date ?

    you pasted your current trigger...i modified it.

    however, i made a WAG(Wild *** Guess) as to whether your table tblPerson had a PersonId in it.

    you'd have to modify it to be...

    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!

    May 8, 2009 at 8:06 am

    #991104

  • RE: Selecting from a table where any column is named like 'ServiceNumber%'

    you probably want to change it to test for OR instead of AND...so it builds like this

    SELECT * from MyTable WHERE 1 = 2 --never happens

    OR ServiceNumber001Volume...

    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!

    May 8, 2009 at 7:50 am

    #991085

  • RE: Trigger for updating date ?

    your current trigger would update everything, where you really want to restrict it to the rows that were updated.

    inside a trigger, there are two virtual tables called INSERTED and DELETLED,...

    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!

    May 8, 2009 at 7:39 am

    #991069

Viewing 15 posts - 11,116 through 11,130 (of 13,460 total)