Forum Replies Created

Viewing 15 posts - 3,856 through 3,870 (of 13,460 total)

  • RE: Validating trace file events

    johnnyrmtl (3/20/2013)

    Since the trace will never be closed and it will be started via command line , how would I go upon this if at all possible in validating which...

    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!

    March 20, 2013 at 12:01 pm

    #1599050

  • RE: Validating trace file events

    johnnyrmtl (3/20/2013)

    K thanks !

    I've launched a profiler trace and piped it towards a directory and a file...

    I see 2 ID's within sys.traces but with the one I launched has 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!

    March 20, 2013 at 11:28 am

    #1599031

  • RE: Validating trace file events

    johnnyrmtl (3/20/2013)

    Just to clarify ... if I am starting a custom trace ( not server default ) from profiler and would like to confirm the events that I am tracing...

    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!

    March 20, 2013 at 9:51 am

    #1598995

  • RE: Best approch to finding/fixing miss-spelled names.

    i cannot imagine any way to automate this;

    this really requires someone to go thru the data, and familiar with a lot more than just the names/users;

    you don't have any other...

    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!

    March 20, 2013 at 8:59 am

    #1598957

  • RE: Incrementing code to add code

    akberali67 (3/20/2013)

    CTE wouldnt work because I am joining the table to itself meaning the field names would be the same and SQL doesnot accept that.

    davidandrews13 (3/20/2013)

    are you doing something 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!

    March 20, 2013 at 5:43 am

    #1598841

  • RE: Sql server back ground processes.

    there's far more information out there than we can provide in a simple forum post; forum posts are great for specific questions, but not so much for general research.

    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!

    March 20, 2013 at 5:38 am

    #1598838

  • RE: Handling foreign key with no value

    most foreign key constraints are placed in a column that allows NULL, which is undefined;

    if you are storing 'empty' or an empty string or anything else that's not in 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!

    March 20, 2013 at 5:30 am

    #1598836

  • RE: Create table structure

    kapil_kk (3/20/2013)

    Hi,

    I have a scenario according I have to create a table struture. As I have never designed any table structure based on a scenario of SRS. Plz guide 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!

    March 20, 2013 at 5:20 am

    #1598833

  • RE: Time out option on DB

    have the developer change the application connection string.

    both SQLOLEDB and SQLNCLI providers have a default timeout of 30 seconds unless otherwise overridden in the connection string created by the application.

    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!

    March 19, 2013 at 2:46 pm

    #1598644

  • RE: Bulk Insert via VBA - Operating system error 5

    peter.griffin 45527 (3/19/2013)

    Hi,

    I hope this is the correct location for my question.

    I have written a simple piece of VBA to convert some data and save as a csv file which...

    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!

    March 19, 2013 at 12:16 pm

    #1598594

  • RE: BombProof Data Import from Excel ?

    i think it has nothing to do with SQL, but rather the ACE drivers that are used to access via Excel;

    the ACE driver does the peek at the first 100...

    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!

    March 19, 2013 at 12:10 pm

    #1598589

  • RE: SQL to divide one row by another row based on formula or rule.

    the OP's data as sample data:

    i got that far, but my eyes blurred on the expectations:

    With MySampleData (Date, Name, ID, Result )

    AS

    (

    SELECT CONVERT(datetime,'3/18/2013') ,'A',1,5 UNION ALL

    SELECT '3/18/2013','B',2,16 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!

    March 19, 2013 at 11:19 am

    #1598551

  • RE: BCP to import tab delimited file with header

    look your command over again, it's got multiple places where other dual-single quotes exist.

    try this line instead:

    SET @sql ='bcp DatabaseName.[dbo].ABt_file_load_2012 in "' + @IncomingPath + @FileName + '" -c...

    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!

    March 19, 2013 at 7:58 am

    #1598441

  • RE: Track changes to database objects

    oops sorry: it's from an article i posted here:

    sp_GetDDL_Latest.txt (scripts any object, returns varchar(max)

    sp_GetDDLa_Latest.txt (scripts any object, returns multi row recordset)

    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!

    March 19, 2013 at 7:23 am

    #1598414

  • RE: BCP to import tab delimited file with header

    the issue is subtle: you need to use dbl quotes, and not two single quotes, to identify teh field and row delimiters:

    -t''|'' -r''\n''

    --should be

    -t"|" -r"\n"

    Declare @sql varchar(8000),@IncomingPath varchar(500),@FileName varchar(500)

    set @FileName='12272012_114537_AB123.txt'

    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!

    March 19, 2013 at 7:01 am

    #1598403

Viewing 15 posts - 3,856 through 3,870 (of 13,460 total)