SP

• TST1

  SSCommitted

  Points: 1798

  More actions

  June 14, 2011 at 1:43 am

  #242100

  Hi,

  I have an SP which runs at night to populate certain tables from production to Dev. The job runs fine but it didn't seem to populate the tables. Is there anything I can do? Bear in mind this is on sql 2000!

  thanks

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  June 14, 2011 at 12:09 pm

  #1338584

  yes

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

• Lowell

  SSC Guru

  Points: 323518

  More actions

  June 14, 2011 at 12:43 pm

  #1338611

  Sean Lange (6/14/2011)

  ---

  yes

  😀

  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!

• Matthew24

  SSCommitted

  Points: 1736

  More actions

  June 17, 2011 at 5:19 pm

  #1340739

  TST1 (6/14/2011)

  ---

  Hi,

  I have an SP which runs at night to populate certain tables from production to Dev. The job runs fine but it didn't seem to populate the tables. Is there anything I can do? Bear in mind this is on sql 2000!

  thanks

  Have you checked the cables ??

• Jayanth_Kurup

  SSC-Insane

  Points: 22967

  More actions

  June 18, 2011 at 4:09 am

  #1340768

  Details please ?? meanwhile u can run the sp minus the insert statement to check if its returning the required data, after that u can check for errors when trying to insert the data and any rollbacks which might be occurring.

  Try executing the sp directly to check if the executing runs fine.

  Jayanth Kurup[/url]